private void set_txtbox(转出类 mycls)
{
txt_blje.set_value(mycls._bjje.ToString());
txt_bzf.set_value(mycls._bzf.ToString());
txt_bzje.set_value(mycls._bzj.ToString()); // 标准件
txt_clxje.set_value(mycls._clxje.ToString());
txt_djje.set_value(mycls._djje.ToString());
txt_djsl.set_value(mycls._djsl.ToString());
txt_gs.set_value(mycls._gs.ToString());
txt_gzfl.set_value(mycls._gzfl.ToString());
txt_mhje.set_value(mycls._mhje.ToString());
txt_ptje.set_value(mycls._ptje.ToString());
txt_ptje.set_value(mycls._ptje.ToString());
txt_rclf.set_value(mycls._rclf.ToString());
txt_rldl.set_value(mycls._rldl.ToString());
txt_sjf.set_value(mycls._sjf.ToString());
txt_syje.set_value(mycls._syje.ToString());
txt_sysl.set_value(mycls._sysl.ToString());
txt_wgje.set_value(mycls._wgje.ToString());
txt_wjgf.set_value(mycls._wjgf.ToString());
txt_xsptj.set_value(mycls._xsptj.ToString());
txt_ysf.set_value(mycls._ysf.ToString());
txt_ysje.set_value(mycls._ysje.ToString());
txt_yssl.set_value(mycls._yssl.ToString());
txt_zgje.set_value(mycls._zgje.ToString());
txt_zgsl.set_value(mycls._zgsl.ToString());
txt_zhgs.set_value(mycls._zhgs.ToString());
txt_ztje.set_value(mycls._ztje.ToString());
txt_ztsl.set_value(mycls._ztsl.ToString());
txt_zxfy.set_value(mycls._zxfy.ToString()); // 专项费用
txt_zzfy.set_value(mycls._zzfy.ToString());
}
// 得到已转出的数据， Update 用
public 转出类 getUpdateInfoByWorkno(string workno, DateTime mydate, int deptcode)
{
转出类 mycls = new 转出类();
int tempfactor = -1;
string type;
Decimal weight, cost;
string sql = @"SELECT a.材质, isnull(SUM(a.重量),0) AS 重量, isnull(SUM(a.金额),0) AS 金额
FROM dbo.原始凭证 AS a where 工作令号= '{0}' and year(a.日期) = {1} and month(a.日期)={2} and id in (select id from 原始凭证转出表 )
GROUP BY a.材质";
sql = string.Format(sql, workno, mydate.Year, mydate.Month);
SqlDataReader dr = SqlHelper.ExecuteDataReader(sql);
mycls._workno = workno;
if (dr.HasRows)
{
while (dr.Read())
{
type = dr.GetString(0).Trim();
weight = decimal.Parse(dr.GetValue(1).ToString());
cost = decimal.Parse(dr.GetValue(2).ToString());
switch (type)
{
case "A":
mycls._bzf = cost * tempfactor;
break;
case "B":
mycls._bjje = cost * tempfactor;
break;
case "C":
mycls._clxje = cost * tempfactor;
break;
case "D":
mycls._djsl = weight * tempfactor;
mycls._djje = cost * tempfactor;
break;
case "E":
mycls._sjf = cost * tempfactor;
break;
case "F":
mycls._ysf = cost * tempfactor;
break;
case "G":
mycls._zgsl = weight * tempfactor;
mycls._zgje = cost * tempfactor;
break;
case "J":
mycls._wjgf = cost * tempfactor;
break;
case "M":
mycls._mhje = cost * tempfactor;
break;
case "P":
mycls._ptje = cost * tempfactor;
break;
case "R":
mycls._rclf = cost * tempfactor;
break;
case "S":
mycls._sysl = weight * tempfactor;
mycls._syje = cost * tempfactor;;
break;
case "T":
mycls._ztsl = weight * tempfactor;
mycls._ztje = cost * tempfactor;
break;
case "V":
mycls._xsptj = cost * tempfactor;
break;
case "W":
mycls._wgje = cost * tempfactor;
break;
case "X":
mycls._zxfy = cost * tempfactor;
break;
case "Y":
mycls._yssl = weight * tempfactor;
mycls._ysje = cost * tempfactor;
break;
case "Z":
mycls._bzj = cost * tempfactor;
break;
}
}
}
dr.Close();
sql = @"select isnull(sum(燃料动力),0),isnull(sum(工时), 0),isnull(sum(折合工时), 0),
isnull(sum(薪酬), 0),isnull(sum(制造费用), 0) from(
select 工号, 燃料动力, 工时, 折合工时, 薪酬, 制造费用, 部门 from 费用分配表 where 工号 = '{0}' and year(时间) = {1} and month(时间) = {2} and ID in (select ID from 费用分配转出表)) t";
sql = string.Format(sql, workno, mydate.Year, mydate.Month);
dr = SqlHelper.ExecuteDataReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
mycls._rldl = decimal.Parse(dr.GetValue(0).ToString()) * tempfactor;
mycls._gs = decimal.Parse(dr.GetValue(1).ToString()) * tempfactor;
mycls._zhgs = decimal.Parse(dr.GetValue(2).ToString()) * tempfactor;
mycls._gzfl = decimal.Parse(dr.GetValue(3).ToString()) * tempfactor;
mycls._zzfy = decimal.Parse(dr.GetValue(4).ToString()) * tempfactor;
}
}
dr.Close();
return(mycls);
}
private void frm_单个工号转出_Load(object sender, EventArgs e)
{
checkBox1.Checked = true;
txt_factor.set_title("比例系数：");
txt_factor.set_type(2);
txt_ztsl.set_title("铸铁数量：");
txt_ztsl.set_type(2);
txt_ztje.set_title("铸铁金额：");
txt_ztje.set_type(2);
txt_blje.set_title("备件金额：");
txt_blje.set_type(2);
txt_bzje.set_title("标准件：");
txt_bzje.set_type(2);
txt_djje.set_title("锻件金额");
txt_djje.set_type(2);
txt_djsl.set_title("锻件数量");
txt_djsl.set_type(2);
txt_mhje.set_title("铆焊金额");
txt_mhje.set_type(2);
txt_ptje.set_title("配套金额");
txt_ptje.set_type(2);
txt_clxje.set_title("齿轮配套");
txt_clxje.set_type(2);
txt_syje.set_title("水压金额");
txt_syje.set_type(2);
txt_sysl.set_title("水压数量");
txt_sysl.set_type(2);
txt_wgje.set_title("外购金额");
txt_wgje.set_type(2);
txt_ysje.set_title("有色金额");
txt_ysje.set_type(2);
txt_yssl.set_title("有色数量");
txt_yssl.set_type(2);
txt_zgje.set_title("铸钢金额");
txt_zgje.set_type(2);
txt_zgsl.set_title("铸钢数量");
txt_zgsl.set_type(2);
txt_sjf.set_title("设计费");
txt_sjf.set_type(2);
txt_ysf.set_title("运输费");
txt_ysf.set_type(2);
txt_xsptj.set_title("销售配套件");
txt_xsptj.set_type(2);
txt_rldl.set_title("燃料动力");
txt_rldl.set_type(2);
txt_gzfl.set_title("工资福利");
txt_gzfl.set_type(2);
txt_gs.set_title("工时");
txt_gs.set_type(2);
txt_zhgs.set_title("折合工时");
txt_zhgs.set_type(2);
txt_zzfy.set_title("制造费用");
txt_zzfy.set_type(2);
txt_zxfy.set_title("专项费用");
txt_zxfy.set_type(2);
txt_wjgf.set_title("外加工费");
txt_wjgf.set_type(2);
txt_rclf.set_title("热处理费");
txt_rclf.set_type(2);
txt_bzf.set_title("包装费");
txt_bzf.set_type(2);
label3.Text = workno;
Text = " 完工工号转出 部门：" + deptname;
转出类DAL dal = new 转出类DAL();
if (addflag)
{
mycls = dal.getOutInfoByWorkno(workno, mydate, deptcode);
button1.Text = "转出";
}
else
{
mycls = dal.getUpdateInfoByWorkno(workno, mydate, deptcode);
button1.Text = "修改";
}
groupBox3.Enabled = false;
set_txtbox(mycls);
set_txt_enabled(false);
saveflag = false;
}
