private void btn_del_Click(object sender, EventArgs e)
{
if (grd.get_selectrow_index() == -1)
{
MessageBox.Show("请选择一条记录！");
return;
}
tempdate = grd.get_value(2).ToString();
if (tempdate.IndexOf("转出") > 0)
{
MessageBox.Show("转出记录不能修改！");
return;
}
if (MessageBox.Show("你真的要删除这条记录吗？", "警 告", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
_id = grd.get_value(0).ToString();
dal.成品库房DAL dal = new 成品库房DAL();
dal.del成品库房表ById(_id);
fill(txt_workno.get_value());
}
}
// 从 grid 中得到 数据， EDIT 模式时使用
private void getGridData()
{
string tempdate;
//成品库房.id = grd.get_value(0).ToString();
成品库房.工作令号 = grd.get_value(0).ToString();
tempdate = grd.get_value(1).ToString();
成品库房.日期 = new DateTime(int.Parse(tempdate.Substring(0, 4)), int.Parse(tempdate.Substring(7, 2)), int.Parse(tempdate.Substring(11, 2)));
成品库房.金额 = decimal.Parse(grd.get_value(2).ToString());
成品库房.ty = decimal.Parse(grd.get_value(3).ToString());
成品库房.zdh = decimal.Parse(grd.get_value(4).ToString());
成品库房.sj = decimal.Parse(grd.get_value(5).ToString());
成品库房.ys = decimal.Parse(grd.get_value(6).ToString());
成品库房.az = decimal.Parse(grd.get_value(7).ToString());
成品库房.qt = decimal.Parse(grd.get_value(8).ToString());
成品库房.xsjy = decimal.Parse(grd.get_value(9).ToString());
成品库房.gjjy = decimal.Parse(grd.get_value(10).ToString());
dal.成品库房DAL dal = new 成品库房DAL();
dateTimePicker1.Value = dal.getDateById(成品库房.id);
成品库房.日期 = dateTimePicker1.Value;
txt_gh.set_value(成品库房.工作令号);
txt_je.set_value(成品库房.金额.ToString());
txt_ty.set_value(成品库房.ty.ToString());
txt_zdh.set_value(成品库房.zdh.ToString());
txt_sj.set_value(成品库房.sj.ToString());
txt_ys.set_value(成品库房.ys.ToString());
txt_az.set_value(成品库房.az.ToString());
txt_qt.set_value(成品库房.qt.ToString());
txt_xsjy.set_value(成品库房.xsjy.ToString());
txt_gjjy.set_value(成品库房.gjjy.ToString());
}
private void btn_save_Click(object sender, EventArgs e)
{
//DateTime outdate = mydate.Value;
//string gh = txt_workno1.get_value();
//decimal cost = decimal.Parse(txt_je.get_value());
get_txt(成品库房);
Guid id = Guid.NewGuid();
成品库房DAL dal = new 成品库房DAL();
if (addflag)
{
成品库房.id = Guid.NewGuid().ToString();
dal.insert成品库房表_转出(成品库房);
}
else
{
成品库房.id = Guid.NewGuid().ToString();
dal.update成品库房表_转出(成品库房);
}
fill(txt_workno.get_value(), chk_type.Checked);
txt_je.set_value("");
txt_workno1.set_value("");
groupBox1.Enabled = false;
btn_out.Enabled = true;
btn_edit.Enabled = true;
chk_type.Enabled = true;
btn_search.Enabled = true;
btn_del.Enabled = true;
}
private void btn_save_Click(object sender, EventArgs e)
{
if (txt_workno.get_value() == "")
{
MessageBox.Show("工号不能为空！");
return;
}
if (!decimal.TryParse(txt_je.get_value().ToString(), out _je))
{
MessageBox.Show("金额错误！");
return;
}
set成品库房();
dal.成品库房DAL dal = new 成品库房DAL();
if (addflag)
{
成品库房.id = Guid.NewGuid().ToString();
dal.insert成品库房表(成品库房);
}
else
{
dal.update成品库房表(new Guid(成品库房.id), 成品库房.金额);
}
MessageBox.Show("已保存！");
fill(txt_workno.get_value());
}
private void fill()
{
DataTable tb = new 成品库房DAL().getSumCost(mydate.Value);
DataRow newrow;
_mytable.Rows.Clear();
foreach (DataRow myrow in tb.Rows)
{
newrow = _mytable.NewRow();
newrow[0] = false;
newrow[1] = myrow[0];
newrow[2] = myrow[1];
newrow[3] = myrow[2];
newrow[4] = myrow[3];
newrow[5] = myrow[4];
newrow[6] = myrow[5];
newrow[7] = myrow[6];
newrow[8] = myrow[7];
newrow[9] = myrow[8];
newrow[10] = myrow[9];
_mytable.Rows.Add(newrow);
}
mygrid.set_date(_mytable);
mygrid.set_col_editable(0, true);
}
private void btn_edit_Click(object sender, EventArgs e)
{
int index;
DateTime tmpdate;
string workno;
string tempstr;
index = grd.get_selectrow_index();
if (index == -1)
{
MessageBox.Show("请选择一条记录 ！");
return;
}
tempstr = grd.get_value(index, 1).ToString();
if (tempstr.IndexOf("转出") < 0)
{
MessageBox.Show(" 只能对‘转出项’ 进行修改 ！ ");
return;
}
btn_out.Enabled = false;
btn_edit.Enabled = false;
chk_type.Enabled = false;
btn_search.Enabled = false;
btn_del.Enabled = false;
addflag = false;
groupBox1.Enabled = true;
workno = grd.get_value(index, 0).ToString().Trim();
tmpdate = new DateTime(int.Parse(tempstr.Substring(0, 4)), int.Parse(tempstr.Substring(5, 2)), 15);
成品库房DAL dal = new 成品库房DAL();
成品库房 = dal.getInfoByWorkno(workno, tmpdate);
set_txt(成品库房);
//workno = grd.get_value(index, 1).ToString();
//txt_workno1.set_value(workno);
//myid = Guid.Parse(grd.get_value(index, 0).ToString());
//txt_je.set_value(grd.get_value(index, 3).ToString());
}
private void btn_del_Click(object sender, EventArgs e)
{
string workno;
DateTime tmpdate;
int rowindex;
rowindex = grd.get_selectrow_index();
if (rowindex == -1)
{
MessageBox.Show(" 请选择一条转出记录 ！");
return;
}
string value = grd.get_value(rowindex, 1).ToString();
if (value.IndexOf("转出") < 0)
{
MessageBox.Show(" 请选择一条转出记录 ！");
return;
}
if (MessageBox.Show("你真的要删除这个记录吗？", "警 告", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
成品库房DAL dal = new 成品库房DAL();
workno = grd.get_value(rowindex, 0).ToString().Trim();
tmpdate = new DateTime(int.Parse(value.Substring(0, 4)), int.Parse(value.Substring(5, 2)), 15);
dal.del成品库房表_转出(workno, tmpdate);
//id = grd.get_value(rowindex, 0).ToString();
//销售成本结算DAL dal = new 销售成本结算DAL();
//dal.removedate(id);
fill(txt_workno.get_value(), chk_type.Checked);
}
private void btn_out_Click(object sender, EventArgs e)
{
int index;
//decimal cost;
string workno;
index = grd.get_selectrow_index();
if (index == -1)
{
MessageBox.Show("请选择一条记录 ！");
return;
}
btn_out.Enabled = false;
btn_edit.Enabled = false;
chk_type.Enabled = false;
btn_search.Enabled = false;
btn_del.Enabled = false;
addflag = true;
groupBox1.Enabled = true;
workno = grd.get_value(index, 0).ToString();
txt_workno1.set_value(workno);
//cost = dal.getCostbyWorkno(workno)*(-1);
//txt_je.set_value( cost.ToString());
成品库房DAL dal = new 成品库房DAL();
成品库房 = dal.getCostByWorkno(workno);
成品库房.日期 = mydate.Value;
set_txt_out(成品库房);
}
// 批量转出
private void btn_export_Click(object sender, EventArgs e)
{
int rowcount = mygrid.get_row_number();
decimal mycost;
成品库房DAL dal = new 成品库房DAL();
成品库房表 mod = new 成品库房表();
//foreach ( DataGridViewRow myrow in mygri)
for (int i = 0; i < rowcount; i++)
{
if (bool.Parse(mygrid.get_value(i, 0).ToString()))
{
mod = dal.getCostByWorkno(mygrid.get_value(i, 1).ToString());
mod.id = Guid.NewGuid().ToString();
mod.日期 = mydate.Value;
mod.金额 *= (-1);
mod.ty *= (-1);
mod.zdh *= (-1);
mod.sj *= (-1);
mod.ys *= (-1);
mod.az *= (-1);
mod.qt *= (-1);
mod.xsjy *= (-1);
mod.gjjy *= (-1);
dal.insert成品库房表_转出(mod);
}
}
MessageBox.Show("转出完成！");
fill();
btn_export.Enabled = false;
}
private void btn_export_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;
Range myrng;
object[] myobj;
System.Data.DataTable mytb = new System.Data.DataTable();
int temprow;
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");
if (wk == null)
{
MessageBox.Show("模板文件没找到！");
return;
}
try
{
//销售成本结算DAL dal1 = new 销售成本结算DAL();
成品库房DAL dal1 = new 成品库房DAL();
DateTime tempdate = mydate.Value;
//SqlDataReader dr = dal1.get库房明细报表( tempdate );
SqlDataReader dr = dal1.get成品库房();
myobj = new object[13];
mysheet = wk.Worksheets["库房明细报表"];
if (dr.HasRows)
{
temprow = 3;
while (dr.Read())
{
dr.GetValues(myobj);
myrng = mysheet.Range[mysheet.Cells[temprow, 1], mysheet.Cells[temprow, 13]];
//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 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)
{
if (txt_filename.get_value() == "")
{
MessageBox.Show("文件名不能为空 ！ ");
return;
}
DateTime mydate = import_date.Value;
成品库房DAL dal = new 成品库房DAL();
if (dal.getInfoByDate(mydate).Rows.Count > 0)
{
if (MessageBox.Show("选择的月份已有数据， 真的要继续导入吗 ？ ", "警 告", MessageBoxButtons.YesNo) != DialogResult.Yes)
{
return;
}
}
string filename = txt_filename.get_value();
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filename + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
OleDbDataReader dr;
OleDbCommand myCommand = new OleDbCommand();
strExcel = @"select rtrim(工号), 金额 from [库存信息$]";
myCommand.Connection = conn;
myCommand.CommandText = strExcel;
dr = myCommand.ExecuteReader();
库房信息 mycls;
List <库房信息> mylist = new List <库房信息>();
if (dr.HasRows)
{
while (dr.Read())
{
mycls = new 库房信息();
mycls.workno = dr.GetString(0);
mycls.income = decimal.Parse(dr.GetValue(1).ToString());
mycls.mydate = import_date.Value;
mylist.Add(mycls);
}
}
dr.Close();
工号表DAL ghdal = new 工号表DAL();
bool wrongflag = false;
string wrongworkno = "";
foreach (库房信息 mycls1 in mylist)
{
if (!ghdal.IsIn工号表(mycls1.workno))
{
//MessageBox.Show("工号 ：" + mycls1.工号 + " 不存在 ！");
wrongflag = true;
wrongworkno += mycls1.workno + "\r\n";
}
}
if (wrongflag)
{
MessageBox.Show(wrongworkno, "错误工号");
System.IO.FileStream fs = new System.IO.FileStream("E:/错误工号.TXT", System.IO.FileMode.OpenOrCreate);
byte[] data = System.Text.Encoding.Default.GetBytes(wrongworkno);
fs.Write(data, 0, data.Length);
fs.Close();
return;
}
成品库房DAL dal1 = new 成品库房DAL();
foreach (库房信息 mycls1 in mylist)
{
//DataGridViewRow myrow = new DataGridViewRow();
//myrow.Cells[0].Value = mycls1.workno;
//myrow.Cells[1].Value = mycls1.mydate;
//myrow.Cells[2].Value = mycls1.income;
dal1.insert成品库房表(mycls1.workno, mycls1.mydate, mycls1.income * (-1));
}
}
