using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
|
namespace CostM
|
{
|
public partial class CB_WorkTimePeriodAdd : Form
|
{
|
public CB_WorkTimePeriodAdd()
|
{
|
InitializeComponent();
|
}
|
|
public int HYear;
|
public int HPeriod;
|
long HMaterID;
|
string HMaterNumber;
|
long HDeptID;
|
string HMESDeptName;
|
double HRelWorkTimes;
|
private void cmdHMaterID_Click(object sender, EventArgs e)
|
{
|
|
DAL.ClsK3_Material_View oMater = new DAL.ClsK3_Material_View();
|
if (oMater.RefreshView())
|
{
|
txtHMaterID.Tag = oMater.omodel.HItemID;
|
txtHMaterID.Text = oMater.omodel.HNumber;
|
txtHMaterName.Text = oMater.omodel.HName;
|
}
|
else
|
{
|
txtHMaterID.Tag = 0;
|
txtHMaterID.Text = "";
|
txtHMaterName.Text = "";
|
}
|
}
|
|
private void txtHMaterID_TextChanged(object sender, EventArgs e)
|
{
|
if (txtHMaterID.Text.Trim() == "")
|
txtHMaterID.Tag = "0";
|
}
|
|
private void cmdHCostItemID_Click(object sender, EventArgs e)
|
{
|
DAL.ClsK3_Department_View oDept = new DAL.ClsK3_Department_View();
|
if (oDept.RefreshView())
|
{
|
txtHDeptID.Text = oDept.oModel.HName;
|
txtHDeptID.Tag = oDept.oModel.HItemID;
|
}
|
else
|
{
|
txtHDeptID.Text = "";
|
txtHDeptID.Tag = 0;
|
}
|
}
|
|
private void txtHCostItemID_TextChanged(object sender, EventArgs e)
|
{
|
if (txtHDeptID.Text.Trim() == "")
|
txtHDeptID.Tag = "0";
|
}
|
|
private void CB_WorkTimePeriodAdd_Load(object sender, EventArgs e)
|
{
|
|
//获取本期成本会计期间
|
if (DBUtility.ClsPub.Sub_CBGetCurPeriod() == false)
|
{
|
MessageBox.Show("获取成本会计期间失败!");
|
return;
|
}
|
cmbHYear.Items.Add(DBUtility.ClsPub.CBCurYear);
|
cmbHYear.Items.Add(DBUtility.ClsPub.CBCurYear - 1);
|
cmbHYear.Items.Add(DBUtility.ClsPub.CBCurYear - 2);
|
cmbHYear.Items.Add(DBUtility.ClsPub.CBCurYear - 3);
|
//cmbHYear.SelectedIndex = 0;
|
//cmdHPeriod.Text = DBUtility.ClsPub.CBCurPeriod.ToString();
|
cmbHYear.Text = DBUtility.ClsPub.isStrNull(HYear);
|
cmbHPeriod.Text = DBUtility.ClsPub.isStrNull(HPeriod);
|
}
|
|
private void button2_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void button1_Click(object sender, EventArgs e)
|
{
|
//获取本期成本会计期间
|
if (DBUtility.ClsPub.Sub_CBGetCurPeriod() == false)
|
{
|
MessageBox.Show("获取成本会计期间失败!");
|
return;
|
}
|
//判断是否本期间
|
if (Pub_Class.ClsPub.isInt(cmbHYear.Text) != DBUtility.ClsPub.CBCurYear || Pub_Class.ClsPub.isInt(cmbHPeriod.Text) != DBUtility.ClsPub.CBCurPeriod)
|
{
|
MessageBox.Show("只能保存本期数据！");
|
return;
|
}
|
//
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet Ds;
|
HYear = DBUtility.ClsPub.isInt( cmbHYear.Text);
|
HPeriod = DBUtility.ClsPub.isInt(cmbHPeriod.Text);
|
HMaterID = DBUtility.ClsPub.isLong(txtHMaterID.Tag);
|
HMaterNumber = DBUtility.ClsPub.isStrNull(txtHMaterID.Text);
|
HDeptID = DBUtility.ClsPub.isLong(txtHDeptID.Tag);
|
HMESDeptName = DBUtility.ClsPub.isStrNull(txtHMESDeptName.Text);
|
HRelWorkTimes = DBUtility.ClsPub.isDoule(txtHRelWorkTimes.Text);
|
Ds = oCn.RunProcReturn("select * from CB_WorkTimePeriod where HYear=" + HYear + " and HPeriod=" + HPeriod + " and HMaterID=" + HMaterID + " and HDeptID=" + HDeptID + " and HMESDeptName='" + HMESDeptName + "'", "CB_WorkTimePeriod");
|
if (Ds.Tables[0].Rows.Count > 0)
|
{
|
if (MessageBox.Show("本期此产品在该部门已存在工时，是否覆盖？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
|
{
|
oCn.RunProc("delete CB_WorkTimePeriod where HYear=" + HYear + " and HPeriod=" + HPeriod + " and HMaterID=" + HMaterID + " and HDeptID=" + HDeptID + " and HMESDeptName='"+HMESDeptName+"'");
|
}
|
else
|
{
|
return;
|
}
|
}
|
|
oCn.RunProc("insert into CB_WorkTimePeriod (HYear,HPeriod" +
|
",HDeptID,HMaterID,HMaterNumber,HMESDeptName,HRelWorkTimes" +
|
")" +
|
"values('" + HYear + "','" + HPeriod + "'" +
|
"," + HDeptID + "," + HMaterID + ",'" + HMaterNumber + "','" + HMESDeptName + "'," + HRelWorkTimes + ")");
|
MessageBox.Show("保存完毕！");
|
}
|
}
|
}
|
