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; }