private void button1_Click(object sender, EventArgs e) { if (comboBox2.Text.Equals("")) { MessageBox.Show("请选择品质等级!"); return; } else if (comboBox1.Text.Equals("")) { MessageBox.Show("请选择颜色!"); return; } else if (comboBox3.Text.Equals("")) { MessageBox.Show("请选择效率!"); return; } else if (comboBox4.Text.Equals("")) { MessageBox.Show("请选择线别 !"); return; } ApplicationClass lbl = new ApplicationClass(); lbl.Documents.Open(@"C:\Users\Administrator\Desktop\CellPrint\JCP-0001.Lab", false);// 调用设计好的label文件 Document doc = lbl.ActiveDocument; string _data = System.DateTime.Now.ToString("yyyy-MM-dd"); //1.自增1 2.日期3.最大值 //和客户端电脑日期做对比,如果有就取最大值 ,反之插入对应数据 最大值从001开始 string _PackageNo = ""; DataSet ds = DbHelperAccess.Query("select Maxids from PackagePrint where Dates='" + _data + "'"); try { if (ds.Tables[0].Rows.Count > 0) { string _len = ""; switch (ds.Tables[0].Rows[0][0].ToString().Length) { case 1: _len = "000"; _PackageNo = "C" + Convert.ToDateTime(_data).ToString("yyMMdd") + this.comboBox4.Text.Trim() + _len + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1); //update //插入SQl语句 string _update = "update PackagePrint set Maxids=" + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1).ToString() + " where Dates= '" + _data + "'"; DbHelperAccess.ExecuteSql(_update); break; case 2: _len = "00"; _PackageNo = "C" + Convert.ToDateTime(_data).ToString("yyMMdd") + this.comboBox4.Text.Trim() + _len + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1); //update //插入SQl语句 string _update1 = "update PackagePrint set Maxids=" + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1).ToString() + " where Dates= '" + _data + "'"; DbHelperAccess.ExecuteSql(_update1); break; case 3: _len = "0"; _PackageNo = "C" + Convert.ToDateTime(_data).ToString("yyMMdd") + this.comboBox4.Text.Trim() + _len + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1); //update //插入SQl语句 string _update2 = "update PackagePrint set Maxids=" + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1).ToString() + " where Dates= '" + _data + "'"; DbHelperAccess.ExecuteSql(_update2); break; default: _len = ""; _PackageNo = "C" + Convert.ToDateTime(_data).ToString("yyMMdd") + this.comboBox4.Text.Trim() + _len + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1); //update //插入SQl语句 string _update3 = "update PackagePrint set Maxids=" + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1).ToString() + " where Dates= '" + _data + "'"; DbHelperAccess.ExecuteSql(_update3); break; } } else { _PackageNo = "C" + Convert.ToDateTime(_data).ToString("yyMMdd") + this.comboBox4.Text.Trim() + "0001"; string _NO = "insert into PackagePrint(Dates,Maxids) values ('" + _data + "','0001')";//插入SQl语句 DbHelperAccess.ExecuteSql(_NO); } doc.Variables.FormVariables.Item("PackageNo").Value = _PackageNo; //给参数传值Package号 //doc.Variables.FormVariables.Item("Line").Value = this.comboBox4.Text.Trim();//给参数传值线别 doc.Variables.FormVariables.Item("Grade").Value = this.comboBox2.Text.Trim(); //给参数传值等级 doc.Variables.FormVariables.Item("Eff").Value = this.comboBox3.Text.Trim(); //给参数传值效率档 doc.Variables.FormVariables.Item("Color").Value = this.comboBox1.Text.Trim(); //给参数传值颜色 doc.Variables.FormVariables.Item("QTY").Value = this.textBox2.Text.Trim(); //给参数传值数量 //doc.PrintDocument(1); //打印 //数据插入的SQL语句 string _in = "insert into PackageRecord(PackageNo,Grade,Eff,Color,QTY) values ('" + this.textBox1.Text.Trim() + "','" + this.comboBox2.Text.Trim() + "','" + this.comboBox3.Text.Trim() + "','" + this.comboBox1.Text.Trim() + "','" + this.textBox2.Text.Trim() + "');";//插入SQl语句 DbHelperAccess.ExecuteSql(_in); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { lbl.Quit(); //退出 } }
private void button1_Click(object sender, EventArgs e) { if (comboBox2.Text.Equals("")) { MessageBox.Show("请选择品质等级!"); return; } else if (comboBox1.Text.Equals("")) { MessageBox.Show("请选择颜色!"); return; } else if (comboBox3.Text.Equals("")) { MessageBox.Show("请选择效率!"); return; } else if (comboBox4.Text.Equals("")) { MessageBox.Show("请选择线别 !"); return; } ApplicationClass lbl = new ApplicationClass(); string str = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase; string strTemplate = str + "\\" + "JCP-0001.Lab"; lbl.Documents.Open(strTemplate, false);// 调用设计好的label文件 Document doc = lbl.ActiveDocument; string _data = (System.DateTime.Now.AddHours(-8)).ToString("yyyy-MM-dd"); //string s = System.DateTime.Now.ToString(); //1.自增1 2.日期3.最大值 //和客户端电脑日期做对比,如果有就取最大值 ,反之插入对应数据 最大值从001开始 string _PackageNo = ""; DataSet ds = DbHelperAccess.Query("select Maxids from PackagePrint where Dates='" + _data + "'"); try { if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string strMaxId = ds.Tables[0].Rows[0][0].ToString(); int nMaxId = 0; if (string.IsNullOrEmpty(strMaxId) == false) { nMaxId = int.Parse(strMaxId); } nMaxId = nMaxId + 1; strMaxId = nMaxId.ToString(); strMaxId = "000" + strMaxId; int nLength = strMaxId.Length; int nStart = nLength - 4; strMaxId = strMaxId.Substring(nStart, 4); _PackageNo = "C" + Convert.ToDateTime(_data).ToString("yyMMdd") + this.comboBox4.Text.Trim() + strMaxId; string _update = "update PackagePrint set Maxids=" + nMaxId + " where Dates= '" + _data + "'"; DbHelperAccess.ExecuteSql(_update); /* * string _len = ""; * switch (ds.Tables[0].Rows[0][0].ToString().Length) * { * * case 1: * _len = "000"; * _PackageNo = "C" + Convert.ToDateTime(_data).ToString("yyMMdd") +this.comboBox4.Text.Trim() + _len + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1); * //update * //插入SQl语句d * string _update = "update PackagePrint set Maxids=" + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1).ToString() + " where Dates= '" + _data + "'"; * DbHelperAccess.ExecuteSql(_update); * break; * case 2: * _len = "00"; * _PackageNo = "C" + Convert.ToDateTime(_data).ToString("yyMMdd") + this.comboBox4.Text.Trim() + _len + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1); * //update * //插入SQl语句 * string _update1 = "update PackagePrint set Maxids=" + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1).ToString() + " where Dates= '" + _data + "'"; * DbHelperAccess.ExecuteSql(_update1); * break; * case 3: * _len = "0"; * _PackageNo = "C" + Convert.ToDateTime(_data).ToString("yyMMdd") + this.comboBox4.Text.Trim() + _len + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1); * //update * //插入SQl语句 * string _update2 = "update PackagePrint set Maxids=" + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1).ToString() + " where Dates= '" + _data + "'"; * DbHelperAccess.ExecuteSql(_update2); * break; * default: * _len = ""; * _PackageNo = "C" + Convert.ToDateTime(_data).ToString("yyMMdd") + this.comboBox4.Text.Trim() + _len + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1); * //update * //插入SQl语句 * string _update3 = "update PackagePrint set Maxids=" + (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1).ToString() + " where Dates= '" + _data + "'"; * DbHelperAccess.ExecuteSql(_update3); * break; * * }*/ } else { _PackageNo = "C" + Convert.ToDateTime(_data).ToString("yyMMdd") + this.comboBox4.Text.Trim() + "0001"; string _NO = "insert into PackagePrint(Dates,Maxids) values ('" + _data + "','1')";//插入SQl语句 DbHelperAccess.ExecuteSql(_NO); } //分类编号 string _PartNo = ""; string c = ""; if (this.comboBox1.Text.Trim() == "正蓝") { c = "B"; } else if (this.comboBox1.Text.Trim() == "深蓝") { c = "D"; } else if (this.comboBox1.Text.Trim() == "浅蓝") { c = "L"; } string _e = ""; if (this.comboBox3.Text.Trim() == "17.2") { _e = "172"; } else if (this.comboBox3.Text.Trim() == "17.4") { _e = "174"; } else if (this.comboBox3.Text.Trim() == "17.6") { _e = "176"; } else if (this.comboBox3.Text.Trim() == "17.7") { _e = "177"; } else if (this.comboBox3.Text.Trim() == "17.8") { _e = "178"; } else if (this.comboBox3.Text.Trim() == "17.9") { _e = "179"; } else if (this.comboBox3.Text.Trim() == "18.0") { _e = "180"; } else if (this.comboBox3.Text.Trim() == "18.1") { _e = "181"; } else if (this.comboBox3.Text.Trim() == "18.2") { _e = "182"; } else if (this.comboBox3.Text.Trim() == "18.3") { _e = "183"; } _PartNo = "P" + this.comboBox2.Text.Trim() + c + _e; doc.Variables.FormVariables.Item("PackageNo").Value = _PackageNo; //给参数传值Package号 doc.Variables.FormVariables.Item("PartNo").Value = _PartNo; //给参数传值分类编号 doc.Variables.FormVariables.Item("Grade").Value = this.comboBox2.Text.Trim(); //给参数传值等级 doc.Variables.FormVariables.Item("Eff").Value = this.comboBox3.Text.Trim(); //给参数传值效率档 doc.Variables.FormVariables.Item("Color").Value = this.comboBox1.Text.Trim(); //给参数传值颜色 doc.Variables.FormVariables.Item("QTY").Value = this.textBox2.Text.Trim(); //给参数传值数量 doc.PrintDocument(1); //打印 //数据插入的SQL语句 string _in = "insert into PackageRecord(PackageNo,Grade,Eff,Color,QTY) values ('" + this.textBox1.Text.Trim() + "','" + this.comboBox2.Text.Trim() + "','" + this.comboBox3.Text.Trim() + "','" + this.comboBox1.Text.Trim() + "','" + this.textBox2.Text.Trim() + "')";//插入SQl语句 DbHelperAccess.ExecuteSql(_in); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { lbl.Quit(); //退出 } }