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(); //退出
}
}