private void fill( )
{
调整费用分配表DAL dal = new 调整费用分配表DAL();
费用分配表DAL dal1 = new 费用分配表DAL();
grd_data.set_date(dal.getDateByDept(mydate.Value, deptcode));
grd_data.set_hide(0);
cmb_gonghao.DataSource = dal1.getWorkNoPerMonth(mydate.Value, deptcode);
cmb_gonghao.DisplayMember = "工号";
cmb_gonghao.DisplayMember = "工号";
}
private void button1_Click(object sender, EventArgs e)
{
if (grd_data.get_row_number() > 1)
{
if (MessageBox.Show("这个月已有 费用分配 数据， 确定要重做吗 ？ ", " 警 告 ", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
费用分配表DAL dal = new 费用分配表DAL();
dal.计算费用分配(mydate.Value, deptcode);
fill(mydate.Value, deptcode);
}
private void btn_calc_Click(object sender, EventArgs e)
{
原始凭证 mod = new 原始凭证();
原始凭证DAL dal = new 原始凭证DAL();
if (txt_blje.get_value() != "0.00")
{
mycls._bjje = decimal.Parse(txt_blje.get_value());
}
if (txt_bzf.get_value() != "0.00")
{
mycls._bzf = decimal.Parse(txt_bzf.get_value());
}
if (txt_bzje.get_value() != "0.00")
{
mycls._bzj = decimal.Parse(txt_bzje.get_value());
}
if (txt_clxje.get_value() != "0.00")
{
mycls._clxje = decimal.Parse(txt_clxje.get_value());
}
if (txt_djje.get_value() != "0.00")
{
mycls._djje = decimal.Parse(txt_djje.get_value());
}
if (txt_mhje.get_value() != "0.00")
{
mycls._mhje = decimal.Parse(txt_mhje.get_value());
}
if (txt_ptje.get_value() != "0.00")
{
mycls._ptje = decimal.Parse(txt_ptje.get_value());
}
if (txt_rclf.get_value() != "0.00")
{
mycls._rclf = decimal.Parse(txt_rclf.get_value());
}
if (txt_sjf.get_value() != "0.00")
{
mycls._sjf = decimal.Parse(txt_sjf.get_value());
}
if (txt_syje.get_value() != "0.00")
{
mycls._syje = decimal.Parse(txt_syje.get_value());
}
if (txt_wgje.get_value() != "0.00")
{
mycls._wgje = decimal.Parse(txt_wgje.get_value());;
}
if (txt_wjgf.get_value() != "0.00")
{
mycls._wjgf = decimal.Parse(txt_wjgf.get_value());
}
if (txt_xsptj.get_value() != "0.00")
{
mycls._xsptj = decimal.Parse(txt_xsptj.get_value());
}
if (txt_ysf.get_value() != "0.00")
{
mycls._ysf = decimal.Parse(txt_ysf.get_value());
}
if (txt_ysje.get_value() != "0.00")
{
mycls._ysje = decimal.Parse(txt_ysje.get_value());
}
if (txt_zgje.get_value() != "0.00")
{
mycls._zgje = decimal.Parse(txt_zgje.get_value());
}
if (txt_ztje.get_value() != "0.00")
{
mycls._ztje = decimal.Parse(txt_ztje.get_value());
}
if (txt_zxfy.get_value() != "0.00")
{
mycls._zxfy = decimal.Parse(txt_zxfy.get_value());
}
费用分配表 mod1 = new 费用分配表();
费用分配表DAL dal1 = new 费用分配表DAL();
if (txt_zzfy.get_value() != "0.00")
{
mycls._rldl = decimal.Parse(txt_rldl.get_value());
mycls._gs = mod1.工时;
mycls._zhgs = mod1.折合工时;
mycls._gzfl = decimal.Parse(txt_gzfl.get_value());
mycls._zzfy = decimal.Parse(txt_zzfy.get_value());
}
decimal ycl = mycls._ztje + mycls._ysje + mycls._zgje + mycls._syje + mycls._djje + mycls._bjje + mycls._mhje + mycls._wgje +
mycls._bzj + mycls._ptje + mycls._clxje + mycls._xsptj;
decimal addfy = mycls._rldl + mycls._gzfl + mycls._zzfy + mycls._zxfy + mycls._rclf + mycls._bzf + mycls._sjf + mycls._ysf + mycls._wjgf;
label1.Text = "总金额：" + (ycl + addfy) + " 其中： 原材料：" + ycl + " 其它：" + addfy;
}
private void set_data(string workno, DateTime mydate, int deptcode)
{
原始凭证 mod = new 原始凭证();
原始凭证DAL dal = new 原始凭证DAL();
decimal summoney;
summoney = 0;
if (txt_blje.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "B";
mod.重量 = 0;
mod.金额 = decimal.Parse(txt_blje.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._bjje = decimal.Parse(txt_blje.get_value());
}
if (txt_bzf.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "A";
mod.重量 = 0;
mod.金额 = decimal.Parse(txt_bzf.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._bzf = decimal.Parse(txt_bzf.get_value());
}
if (txt_bzje.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "Z";
mod.重量 = 0;
mod.金额 = decimal.Parse(txt_bzje.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._bzj = mod.金额;
}
if (txt_clxje.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "C"; // 齿轮箱
mod.重量 = 0;
mod.金额 = decimal.Parse(txt_clxje.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._clxje = mod.金额;
}
if (txt_djje.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "D"; // 铸锻件
mod.重量 = decimal.Parse(txt_djsl.get_value());
mod.金额 = decimal.Parse(txt_djje.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._djje = mod.金额;
}
if (txt_mhje.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
////if (mod.单位 == 23)
mod.材质 = "H";
////else
//mod.材质 = "M";
mod.重量 = 0;
mod.金额 = decimal.Parse(txt_mhje.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._mhje = mod.金额;;
}
if (txt_ptje.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "P";
mod.重量 = 0;
mod.金额 = decimal.Parse(txt_ptje.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._ptje = mod.金额;
}
if (txt_rclf.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "R";
mod.重量 = 0;
mod.金额 = decimal.Parse(txt_rclf.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._rclf = mod.金额;
}
if (txt_sjf.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "E";
mod.重量 = 0;
mod.金额 = decimal.Parse(txt_sjf.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._sjf = mod.金额;
}
if (txt_syje.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "S";
mod.重量 = decimal.Parse(txt_sysl.get_value());
mod.金额 = decimal.Parse(txt_syje.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._syje = mod.金额;
}
if (txt_wgje.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "W";
mod.重量 = 0;
mod.金额 = decimal.Parse(txt_wgje.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._wgje = mod.金额;
}
if (txt_wjgf.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "J";
mod.重量 = 0;
mod.金额 = decimal.Parse(txt_wjgf.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._wjgf = mod.金额;
}
if (txt_xsptj.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "V";
mod.重量 = 0;
mod.金额 = decimal.Parse(txt_xsptj.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._xsptj = mod.金额;
}
if (txt_ysf.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "F";
mod.重量 = 0;
mod.金额 = decimal.Parse(txt_ysf.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._ysf = mod.金额;
}
if (txt_ysje.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "Y";
mod.重量 = decimal.Parse(txt_yssl.get_value());
mod.金额 = decimal.Parse(txt_ysje.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._ysje = mod.金额;
}
if (txt_zgje.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "G";
mod.重量 = decimal.Parse(txt_zgsl.get_value());
mod.金额 = decimal.Parse(txt_zgje.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._zgje = mod.金额;
}
if (txt_ztje.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "T";
mod.重量 = decimal.Parse(txt_ztsl.get_value());
mod.金额 = decimal.Parse(txt_ztje.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._ztje = mod.金额;
}
if (txt_zxfy.get_value() != "0.00")
{
mod.Id = Guid.NewGuid();
mod.日期 = mydate;
mod.凭证号 = "";
mod.单位 = (short)deptcode;
mod.工作令号 = workno;
mod.材质 = "X";
mod.重量 = 0;
mod.金额 = decimal.Parse(txt_zxfy.get_value());
dal.Add(mod);
dal.add原始凭证转出(mod.Id.ToString());
mycls._zxfy = mod.金额;
}
费用分配表 mod1 = new 费用分配表();
费用分配表DAL dal1 = new 费用分配表DAL();
if (txt_zzfy.get_value() != "0.00")
{
mod1.ID = Guid.NewGuid();
mod1.制造费用 = decimal.Parse(txt_zzfy.get_value());
mod1.工号 = workno;
mod1.工时 = decimal.Parse(txt_gs.get_value());
mod1.折合工时 = decimal.Parse(txt_zhgs.get_value());
mod1.时间 = mydate;
mod1.燃料动力 = decimal.Parse(txt_rldl.get_value());
mod1.薪酬 = decimal.Parse(txt_gzfl.get_value());
mod1.部门 = (short)deptcode;
dal1.Add(mod1);
mycls._rldl = mod1.燃料动力;
mycls._gs = mod1.工时;
mycls._zhgs = mod1.折合工时;
mycls._gzfl = mod1.薪酬;
mycls._zzfy = mod1.制造费用;
dal1.set费用分配转出(mod1.ID.ToString());
}
decimal ycl = mycls._ztje + mycls._ysje + mycls._zgje + mycls._syje + mycls._djje + mycls._bjje + mycls._mhje + mycls._wgje +
mycls._bzj + mycls._ptje + mycls._clxje + mycls._xsptj;
decimal addfy = mycls._rldl + mycls._gzfl + mycls._zzfy + mycls._zxfy + mycls._rclf + mycls._bzf + mycls._sjf + mycls._ysf + mycls._wjgf;
summoney = ycl + addfy;
成品库房DAL dal2 = new 成品库房DAL();
dal2.insert成品库房表(workno, mydate, summoney);
}
private void button1_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wk;
Microsoft.Office.Interop.Excel.Worksheet mysheet;
int temprow;
List <string> mygonghaolist = new List <string>();
Range myrng;
object[] myobj;
System.Data.DataTable mytb = new System.Data.DataTable();
if (app == null)
{
MessageBox.Show("Excel 没有正常打开。 ");
return;
}
app.DisplayAlerts = false;
AppSettingsReader myread = new AppSettingsReader();
string filedir;
try
{
filedir = myread.GetValue("directory", Type.GetType("System.String")).ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
app.Quit();
return;
}
wk = app.Workbooks.Open(filedir + "本厂成本结算模板.xls");
//wk = app.Workbooks.Open(filedir + "成本结算模板.xls");
if (wk == null)
{
MessageBox.Show("模板文件没找到！");
return;
}
try
{
// 原材料
原始凭证DAL dal1 = new 原始凭证DAL();
SqlDataReader dr = dal1.get本厂原始凭证报表(mydate.Value, deptcode);
myobj = new object[18];
//SqlDataReader dr = dal1.get原始凭证报表(mydate.Value);
//myobj = new object[20];
mysheet = wk.Worksheets["材料表"];
if (dr.HasRows)
{
temprow = 3;
while (dr.Read())
{
dr.GetValues(myobj);
myrng = mysheet.Range[mysheet.Cells[temprow, 1], mysheet.Cells[temprow, 18]];
myrng.NumberFormatLocal = "0.00";
myrng.Value2 = myobj;
temprow++;
}
}
dr.Close();
费用分配表DAL dal2 = new 费用分配表DAL();
dr = dal2.getInfoPerMonthBydeptcodeReader(mydate.Value, deptcode);
myobj = new object[7];
mysheet = wk.Worksheets["费用分配表"];
if (dr.HasRows)
{
temprow = 4;
while (dr.Read())
{
dr.GetValues(myobj);
myrng = mysheet.Range[mysheet.Cells[temprow, 1], mysheet.Cells[temprow, 7]];
myrng.NumberFormatLocal = "0.00";
myrng.Value2 = myobj;
temprow++;
}
}
dr.Close();
在制品DAL dal3 = new 在制品DAL();
dr = dal3.导出本厂在制品卡片(mydate.Value, deptcode);
//dr = dal3.导出在制品卡片(mydate.Value);
myobj = new object[15];
mysheet = wk.Worksheets["在制品卡片"];
if (dr.HasRows)
{
temprow = 3;
while (dr.Read())
{
dr.GetValues(myobj);
myrng = mysheet.Range[mysheet.Cells[temprow, 1], mysheet.Cells[temprow, 15]];
myrng.NumberFormatLocal = "0.00";
myrng.Value2 = myobj;
temprow++;
}
}
dr.Close();
dr = dal3.导出本厂新版在制品卡片(mydate.Value, deptcode);
//dr = dal3.导出新版在制品卡片(mydate.Value, deptcode);
myobj = new object[6];
mysheet = wk.Worksheets["在制品卡片 (新版)"];
if (dr.HasRows)
{
temprow = 4;
while (dr.Read())
{
dr.GetValues(myobj);
myrng = mysheet.Range[mysheet.Cells[temprow, 1], mysheet.Cells[temprow, 6]];
myrng.NumberFormatLocal = "0.00";
myrng.Value2 = myobj;
temprow++;
}
}
dr.Close();
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string myfilename = saveFileDialog1.FileName;
wk.SaveAs(myfilename);
}
wk.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
app.Quit();
}
}
private void fill(DateTime mydate, int mydepart)
{
费用分配表DAL dal = new 费用分配表DAL();
grd_data.set_date(dal.getInfoPerMonthBydeptcode(mydate, mydepart));
}
