/// <summary>
/// 包装
/// </summary>
/// <param name="bhd"></param>
private void BaoZhuangBind(tsuhan_sg_tx bhd)
{
#region 包装
bhd.BZ_sbbh1 = this.tb19.Text;
bhd.BZ_sbbh2 = this.tb20.Text;
bhd.BZ_sbbh3 = this.tb21.Text;
bhd.BZ_sbbh4 = this.tb22.Text;
if (this.tbsjsl6.Text == "")
{
this.tbsjsl6.Text = "0";
}
bhd.BZ_sjsl = Convert.ToInt32(this.tbsjsl6.Text);
if (this.tbxcsl6.Text == "")
{
this.tbxcsl6.Text = "0";
}
bhd.BZ_xcsl = Convert.ToInt32(this.tbxcsl6.Text);
if (this.dtpxctime4.Text == "")
{
this.dtpxctime4.Text =DateTime.Now.ToString("yyyy-MM-dd");
}
bhd.BZ_xctime = Convert.ToDateTime(this.dtpxctime4.Text);
bhd.BZ_czy1 = this.tbcz19.Text;
bhd.BZ_czy2 = this.tbcz20.Text;
bhd.BZ_czy3 = this.tbcz21.Text;
bhd.BZ_czy4 = this.tbcz22.Text;
bhd.BZ_czyname1 = this.tbname19.Text;
bhd.BZ_czyname2 = this.tbname20.Text;
bhd.BZ_czyname3 = this.tbname21.Text;
bhd.BZ_czyname4 = this.tbname22.Text;
bhd.BZ_lry = this.tblr7.Text;
bhd.BZ_lryname = this.tblrname7.Text;
if (this.tbyy42.Text == "")
{
this.tbyy42.Text = "0";
}
bhd.bzng1 = Convert.ToInt32(this.tbyy42.Text);
bhd.bzngoth = this.rtbyy43.Text;
if (this.tbyy43sl.Text == "")
{
this.tbyy43sl.Text = "0";
}
bhd.bzngothnum = Convert.ToInt32(this.tbyy43sl.Text);
if (this.tbbhgsl4.Text == "")
{
this.tbbhgsl4.Text = "0";
}
bhd.BZ_bhgallsl = Convert.ToInt32(this.tbbhgsl4.Text);
#endregion
}
private void tblry_MouseUp(object sender, MouseEventArgs e)
{
tsuhan_sg_tx bhd = new tsuhan_sg_tx();
//var name = Convert.ToInt32(gh);
tsuhan_scgl_yh yh = yhbll.GetModel(gh);
if (this.tabControl1.SelectedTab == tabPage1)
{
#region 备料
bhd.bl_lry = this.tblry.Text;
bool result5;
result5 = yhbll.Exist(this.tblry.Text);
if (this.tblry.Text == "")
{
this.tblry.Text = "0";
}
else if (result5 != true)
{
//rg.ShowDialog();
this.tblrName.Text = "";
return;
}
else
{
var yh5 = yhbll.GetModel(this.tblry.Text);
this.tblrName.Text = yh5.姓名;
bhd.bl_lry = this.tblrName.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage2)
{
#region LD耦合焊接
bhd.LD_lry = this.tblr1.Text;
bool result5;
result5 = yhbll.Exist(this.tblr1.Text);
if (this.tblr1.Text == "")
{
this.tblr1.Text = "0";
}
else if (result5 != true)
{
this.tblrname1.Text = "";
return;
}
else
{
var yh5 = yhbll.GetModel(this.tblr1.Text);
this.tblrname1.Text = yh5.姓名;
bhd.LD_lryname = this.tblrname1.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage3)
{
#region PT耦合固化
bhd.PT_lry = this.tblr2.Text;
bool result5;
result5 = yhbll.Exist(this.tblr2.Text);
if (this.tblr2.Text == "")
{
this.tblr2.Text = "0";
}
else if (result5 != true)
{
//rg.ShowDialog();
this.tblrname2.Text = "";
return;
}
else
{
var yh5 = yhbll.GetModel(this.tblr2.Text);
this.tblrname2.Text = yh5.姓名;
bhd.PT_lryname = this.tblrname2.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage4)
{
#region 温循前
bhd.WXQ_lry = this.tblr3.Text;
bool result2;
result2 = yhbll.Exist(this.tblr3.Text);
if (this.tblr3.Text == "")
{
this.tblr3.Text = "0";
}
else if (result2 != true)
{
//rg.ShowDialog();
this.tblrname3.Text = "";
return;
}
else
{
var yh1 = yhbll.GetModel(this.tblr3.Text);
this.tblrname3.Text = yh1.姓名;
bhd.WXQ_lryname = this.tblrname3.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage5)
{
#region 温循后
bhd.WX_Hlry = this.tblr4.Text;
bool result2;
result2 = yhbll.Exist(this.tblr4.Text);
if (this.tblr4.Text == "")
{
this.tblr4.Text = "0";
}
else if (result2 != true)
{
//rg.ShowDialog();
this.tblrname4.Text = "";
return;
}
else
{
var yh1 = yhbll.GetModel(this.tblr4.Text);
this.tblrname4.Text = yh1.姓名;
bhd.WXH_czyname = this.tblrname4.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage6)
{
#region 测试
bhd.CS_lry = this.tblr5.Text;
bool result5;
result5 = yhbll.Exist(this.tblr5.Text);
if (this.tblr5.Text == "")
{
this.tblr5.Text = "0";
}
else if (result5 != true)
{
//rg.ShowDialog();
this.tblrname5.Text = "";
return;
}
else
{
var yh4 = yhbll.GetModel(this.tblr5.Text);
this.tblrname5.Text = yh4.姓名;
bhd.CS_czyname4 = this.tblrname5.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage7)
{
#region 清洗
bhd.QX_lry = this.tblr6.Text;
bool result5;
result5 = yhbll.Exist(this.tblr6.Text);
if (this.tblr6.Text == "")
{
this.tblr6.Text = "0";
}
else if (result5 != true)
{
//rg.ShowDialog();
this.tblrname6.Text = "";
return;
}
else
{
var yh4 = yhbll.GetModel(this.tblr6.Text);
this.tblrname6.Text = yh4.姓名;
bhd.QX_lryname = this.tblrname6.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage8)
{
#region 包装
bhd.BZ_lry = this.tblr7.Text;
bool result5;
result5 = yhbll.Exist(this.tblr7.Text);
if (this.tblr7.Text == "")
{
this.tblr7.Text = "0";
}
else if (result5 != true)
{
//rg.ShowDialog();
this.tblrname7.Text = "";
return;
}
else
{
var yh4 = yhbll.GetModel(this.tblr7.Text);
this.tblrname7.Text = yh4.姓名;
bhd.BZ_lryname = this.tblrname7.Text;
}
#endregion
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdate_Click(object sender, EventArgs e)
{
//时间正则表达式
string reg = @"^((((1[6-9]|[2-9]\d)\d{2})-(0?[13578]|1[02])-(0?[1-9]|[12]\d|3[01]))|(((1[6-9]|[2-9]\d)\d{2})-(0?[13456789]|1[012])-(0?[1-9]|[12]\d|30))|(((1[6-9]|[2-9]\d)\d{2})-0?2-(0?[1-9]|1\d|2[0-8]))|(((1[6-9]|[2-9]\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))-0?2-29-))$";
string regs =@"^(((((1[6-9]|[2-9]\d)\d{2})-(0?[13578]|1[02])-(0?[1-9]|[12]\d|3[01]))|(((1[6-9]|[2-9]\d)\d{2})-(0?[13456789]|1[012])-(0?[1-9]|[12]\d|30))|(((1[6-9]|[2-9]\d)\d{2})-0?2-(0?[1-9]|1\d|2[0-8]))|(((1[6-9]|[2-9]\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))-0?2-29-)) (20|21|22|23|[0-1]?\d):[0-5]?\d:[0-5]?\d)$";
var name =Convert.ToInt32(gh);
tsuhan_scgl_yh yh = yhbll.GetModel(gh);
var sgdh1 = this.tbSGDXH.Text + this.tbDXH1.Text;
var str1 = sgdh1.Substring(sgdh1.Length - 1, 1);
#region 判断不合格数量是否正确
//if (yh.机构 == "全部")
//{
#region 备料
if (this.tbyy10Sl.Text == "")
{
this.tbyy10Sl.Text = "0";
}
if (this.tbyy9.Text == "")
{
this.tbyy9.Text = "0";
}
if (this.tbyy8.Text == "")
{
this.tbyy8.Text = "0";
}
if (this.tbyy7.Text == "")
{
this.tbyy7.Text = "0";
}
if (this.tbyy6.Text == "")
{
this.tbyy6.Text = "0";
}
if (this.tbyy5.Text == "")
{
this.tbyy5.Text = "0";
}
if (this.tbyy4.Text == "")
{
this.tbyy4.Text = "0";
}
if (this.tbyy3.Text == "")
{
this.tbyy3.Text = "0";
}
if (this.tbyy2.Text == "")
{
this.tbyy2.Text = "0";
}
if (this.tbyy1.Text == "")
{
this.tbyy1.Text = "0";
}
if (this.tbbhgsl.Text == "")
{
this.tbbhgsl.Text = "0";
}
var allnum = int.Parse(this.tbyy1.Text) + int.Parse(this.tbyy2.Text) + int.Parse(this.tbyy3.Text) + int.Parse(this.tbyy4.Text) + int.Parse(this.tbyy5.Text) + int.Parse(this.tbyy6.Text) + int.Parse(this.tbyy7.Text) + int.Parse(this.tbyy8.Text) + int.Parse(this.tbyy9.Text) + int.Parse(this.tbyy10Sl.Text);
if (this.tbbhgsl.Text != Convert.ToString(allnum))
{
MessageBox.Show("备料不合格总数错误", "提示");
return;
}
#endregion
#region LD耦合焊接
if (this.tbyy20sl.Text == "")
{
this.tbyy20sl.Text = "0";
}
if (this.tbyy19.Text == "")
{
this.tbyy19.Text = "0";
}
if (this.tbyy18.Text == "")
{
this.tbyy18.Text = "0";
}
if (this.tbyy17.Text == "")
{
this.tbyy17.Text = "0";
}
if (this.tbyy16.Text == "")
{
this.tbyy16.Text = "0";
}
if (this.tbyy15.Text == "")
{
this.tbyy15.Text = "0";
}
if (this.tbyy14.Text == "")
{
this.tbyy14.Text = "0";
}
if (this.tbyy13.Text == "")
{
this.tbyy13.Text = "0";
}
if (this.tbyy12.Text == "")
{
this.tbyy12.Text = "0";
}
if (this.tbyy11.Text == "")
{
this.tbyy11.Text = "0";
}
if (this.tbjzsl1.Text == "")
{
this.tbjzsl1.Text = "0";
}
if (this.tbbhksl1.Text == "")
{
this.tbbhksl1.Text = "0";
}
var allnum1 = int.Parse(this.tbyy11.Text) + int.Parse(this.tbyy12.Text) + int.Parse(this.tbyy13.Text) + int.Parse(this.tbyy14.Text) + int.Parse(this.tbyy15.Text) + int.Parse(this.tbyy16.Text) + int.Parse(this.tbyy17.Text) + int.Parse(this.tbyy18.Text) + int.Parse(this.tbyy19.Text) + int.Parse(this.tbyy20sl.Text);
var num = int.Parse(this.tbbhksl1.Text) + int.Parse(this.tbjzsl1.Text);
var all = num + int.Parse(this.tbxcsl1.Text);
if (Convert.ToString(num) != Convert.ToString(allnum1))
{
MessageBox.Show("LD耦合焊接不合格总数错误", "提示");
return;
}
else if (Convert.ToString(all) != this.tbsjsl1.Text)
{
MessageBox.Show("下传数量与上接数量不符", "提示");
return;
}
#endregion
#region PT耦合固化
if (this.tbyy30sl.Text == "")
{
this.tbyy30sl.Text = "0";
}
if (this.tbyy29.Text == "")
{
this.tbyy29.Text = "0";
}
if (this.tbyy28.Text == "")
{
this.tbyy28.Text = "0";
}
if (this.tbyy27.Text == "")
{
this.tbyy27.Text = "0";
}
if (this.tbyy26.Text == "")
{
this.tbyy26.Text = "0";
}
if (this.tbyy25.Text == "")
{
this.tbyy25.Text = "0";
}
if (this.tbyy24.Text == "")
{
this.tbyy24.Text = "0";
}
if (this.tbyy23.Text == "")
{
this.tbyy23.Text = "0";
}
if (this.tbyy22.Text == "")
{
this.tbyy22.Text = "0";
}
if (this.tbyy21.Text == "")
{
this.tbyy21.Text = "0";
}
if (this.textBox100.Text == "")
{
this.textBox100.Text = "0";
}
var allnum2 = int.Parse(this.tbyy21.Text) + int.Parse(this.tbyy22.Text) + int.Parse(this.tbyy23.Text) + int.Parse(this.tbyy24.Text) + int.Parse(this.tbyy25.Text) + int.Parse(this.tbyy26.Text) + int.Parse(this.tbyy27.Text) + int.Parse(this.tbyy28.Text) + int.Parse(this.tbyy29.Text) + int.Parse(this.tbyy30sl.Text);
var all2 = allnum2 + int.Parse(this.tbxcsl2.Text);
if (this.textBox100.Text != Convert.ToString(allnum2))
{
MessageBox.Show("PT耦合固化不合格总数错误", "提示");
return;
}
else if (Convert.ToString(all2) != this.tbsjsl2.Text)
{
MessageBox.Show("数量与上接数量不符", "提示");
return;
}
#endregion
#region 测试
if (this.tbyy39sl.Text == "")
{
this.tbyy39sl.Text = "0";
}
if (this.tbyy38.Text == "")
{
this.tbyy38.Text = "0";
}
if (this.tbyy37.Text == "")
{
this.tbyy37.Text = "0";
}
if (this.tbyy36.Text == "")
{
this.tbyy36.Text = "0";
}
if (this.tbyy35.Text == "")
{
this.tbyy35.Text = "0";
}
if (this.tbyy34.Text == "")
{
this.tbyy34.Text = "0";
}
if (this.tbyy33.Text == "")
{
this.tbyy33.Text = "0";
}
if (this.tbyy32.Text == "")
{
this.tbyy32.Text = "0";
}
if (this.tbyy31.Text == "")
{
this.tbyy31.Text = "0";
}
if (this.tbbhgsl2.Text == "")
{
this.tbbhgsl2.Text = "0";
}
var allnum3 = int.Parse(this.tbyy31.Text) + int.Parse(this.tbyy32.Text) + int.Parse(this.tbyy33.Text) + int.Parse(this.tbyy34.Text) + int.Parse(this.tbyy35.Text) + int.Parse(this.tbyy36.Text) + int.Parse(this.tbyy37.Text) + int.Parse(this.tbyy38.Text) + int.Parse(this.tbyy39sl.Text);
var all3 = allnum3 + int.Parse(tbxcsl4.Text);
if (this.tbbhgsl2.Text != Convert.ToString(allnum3))
{
MessageBox.Show("测试不合格总数错误", "提示");
return;
}
else if (Convert.ToString(all3) != this.tbsjsl4.Text)
{
MessageBox.Show("数量与上接数量不符", "提示");
return;
}
#endregion
#region 清洗
if (this.tbyy40.Text == "")
{
this.tbyy40.Text = "0";
}
if (this.tbyy41sl.Text == "")
{
this.tbyy41sl.Text = "0";
}
if (this.tbbhgsl3.Text == "")
{
this.tbbhgsl3.Text = "0";
}
var allnum4 = int.Parse(this.tbyy40.Text) + int.Parse(this.tbyy41sl.Text);
var all4 = allnum4 + int.Parse(this.tbxcsl5.Text);
if (this.tbbhgsl3.Text != Convert.ToString(allnum4))
{
MessageBox.Show("清洗不合格总数错误", "提示");
return;
}
else if (Convert.ToString(all4) != this.tbsjsl5.Text)
{
MessageBox.Show("数量与上接数量不符", "提示");
return;
}
#endregion
#region 包装
if (this.tbyy42.Text == "")
{
this.tbyy42.Text = "0";
}
if (this.tbyy43sl.Text == "")
{
this.tbyy43sl.Text = "0";
}
if (this.tbbhgsl4.Text == "")
{
this.tbbhgsl4.Text = "0";
}
var allnum5 = int.Parse(this.tbyy42.Text) + int.Parse(this.tbyy43sl.Text);
var all5 = allnum5 + int.Parse(this.tbxcsl6.Text);
if (this.tbbhgsl4.Text != Convert.ToString(allnum5))
{
MessageBox.Show("包装不合格总数错误", "提示");
return;
}
else if (Convert.ToString(all5) != this.tbsjsl6.Text)
{
MessageBox.Show("数量与上接数量不符", "提示");
return;
}
#endregion
#region
// }
// else if (yh.机构 == "备料")
// {
// #region
// //if (this.tbyy10Sl.Text == "")
// //{
// // this.tbyy10Sl.Text = "0";
// //}
// //if (this.tbyy9.Text == "")
// //{
// // this.tbyy9.Text = "0";
// //}
// //if (this.tbyy8.Text == "")
// //{
// // this.tbyy8.Text = "0";
// //}
// //if (this.tbyy7.Text == "")
// //{
// // this.tbyy7.Text = "0";
// //}
// //if (this.tbyy6.Text == "")
// //{
// // this.tbyy6.Text = "0";
// //}
// //if (this.tbyy5.Text == "")
// //{
// // this.tbyy5.Text = "0";
// //}
// //if (this.tbyy4.Text == "")
// //{
// // this.tbyy4.Text = "0";
// //}
// //if (this.tbyy3.Text == "")
// //{
// // this.tbyy3.Text = "0";
// //}
// //if (this.tbyy2.Text == "")
// //{
// // this.tbyy2.Text = "0";
// //}
// //if (this.tbyy1.Text == "")
// //{
// // this.tbyy1.Text = "0";
// //}
// //if (this.tbbhgsl.Text == "")
// //{
// // this.tbbhgsl.Text = "0";
// //}
// //var allnum = int.Parse(this.tbyy1.Text) + int.Parse(this.tbyy2.Text) + int.Parse(this.tbyy3.Text) + int.Parse(this.tbyy4.Text) + int.Parse(this.tbyy5.Text) + int.Parse(this.tbyy6.Text) + int.Parse(this.tbyy7.Text) + int.Parse(this.tbyy8.Text) + int.Parse(this.tbyy9.Text) + int.Parse(this.tbyy10Sl.Text);
// //if (this.tbbhgsl.Text != Convert.ToString(allnum))
// //{
// // MessageBox.Show("不合格总数错误", "提示");
// // return;
// //}
// #endregion
// }
// else if (yh.机构 == "LD耦合焊接")
// {
// #region
// if (this.tbyy20sl.Text == "")
// {
// this.tbyy20sl.Text = "0";
// }
// if (this.tbyy19.Text == "")
// {
// this.tbyy19.Text = "0";
// }
// if (this.tbyy18.Text == "")
// {
// this.tbyy18.Text = "0";
// }
// if (this.tbyy17.Text == "")
// {
// this.tbyy17.Text = "0";
// }
// if (this.tbyy16.Text == "")
// {
// this.tbyy16.Text = "0";
// }
// if (this.tbyy15.Text == "")
// {
// this.tbyy15.Text = "0";
// }
// if (this.tbyy14.Text == "")
// {
// this.tbyy14.Text = "0";
// }
// if (this.tbyy13.Text == "")
// {
// this.tbyy13.Text = "0";
// }
// if (this.tbyy12.Text == "")
// {
// this.tbyy12.Text = "0";
// }
// if (this.tbyy11.Text == "")
// {
// this.tbyy11.Text = "0";
// }
// if (this.tbjzsl1.Text == "")
// {
// this.tbjzsl1.Text = "0";
// }
// if (this.tbbhksl1.Text == "")
// {
// this.tbbhksl1.Text = "0";
// }
// var allnum1 = int.Parse(this.tbyy11.Text) + int.Parse(this.tbyy12.Text) + int.Parse(this.tbyy13.Text) + int.Parse(this.tbyy14.Text) + int.Parse(this.tbyy15.Text) + int.Parse(this.tbyy16.Text) + int.Parse(this.tbyy17.Text) + int.Parse(this.tbyy18.Text) + int.Parse(this.tbyy19.Text) + int.Parse(this.tbyy20sl.Text);
// var num = int.Parse(this.tbbhksl1.Text) + int.Parse(this.tbjzsl1.Text);
// if (this.tbxcsl1.Text == "")
// {
// this.tbxcsl1.Text = "0";
// }
// var all = num + int.Parse(this.tbxcsl1.Text);
// if (Convert.ToString(num) != Convert.ToString(allnum1))
// {
// MessageBox.Show("不合格总数错误", "提示");
// return;
// }
// else if (Convert.ToString(all) != this.tbsjsl1.Text)
// {
// MessageBox.Show("数量与上接数量不符", "提示");
// return;
// }
// #endregion
// }
// else if (yh.机构 == "PT耦合固化")
// {
// #region PT耦合固化
// if (this.tbyy30sl.Text == "")
// {
// this.tbyy30sl.Text = "0";
// }
// if (this.tbyy29.Text == "")
// {
// this.tbyy29.Text = "0";
// }
// if (this.tbyy28.Text == "")
// {
// this.tbyy28.Text = "0";
// }
// if (this.tbyy27.Text == "")
// {
// this.tbyy27.Text = "0";
// }
// if (this.tbyy26.Text == "")
// {
// this.tbyy26.Text = "0";
// }
// if (this.tbyy25.Text == "")
// {
// this.tbyy25.Text = "0";
// }
// if (this.tbyy24.Text == "")
// {
// this.tbyy24.Text = "0";
// }
// if (this.tbyy23.Text == "")
// {
// this.tbyy23.Text = "0";
// }
// if (this.tbyy22.Text == "")
// {
// this.tbyy22.Text = "0";
// }
// if (this.tbyy21.Text == "")
// {
// this.tbyy21.Text = "0";
// }
// if (this.textBox100.Text == "")
// {
// this.textBox100.Text = "0";
// }
// var allnum2 = int.Parse(this.tbyy21.Text) + int.Parse(this.tbyy22.Text) + int.Parse(this.tbyy23.Text) + int.Parse(this.tbyy24.Text) + int.Parse(this.tbyy25.Text) + int.Parse(this.tbyy26.Text) + int.Parse(this.tbyy27.Text) + int.Parse(this.tbyy28.Text) + int.Parse(this.tbyy29.Text) + int.Parse(this.tbyy30sl.Text);
// if (this.tbxcsl2.Text == "")
// {
// this.tbxcsl2.Text = "0";
// }
// var all = allnum2 + int.Parse(this.tbxcsl2.Text);
// if (this.textBox100.Text != Convert.ToString(allnum2))
// {
// MessageBox.Show("不合格总数错误", "提示");
// return;
// }
// else if (Convert.ToString(all) != this.tbsjsl2.Text)
// {
// MessageBox.Show("数量与上接数量不符", "提示");
// return;
// }
// #endregion
// }
// else if (yh.机构 == "测试")
// {
// #region 测试
// if (this.tbyy39sl.Text == "")
// {
// this.tbyy39sl.Text = "0";
// }
// if (this.tbyy38.Text == "")
// {
// this.tbyy38.Text = "0";
// }
// if (this.tbyy37.Text == "")
// {
// this.tbyy37.Text = "0";
// }
// if (this.tbyy36.Text == "")
// {
// this.tbyy36.Text = "0";
// }
// if (this.tbyy35.Text == "")
// {
// this.tbyy35.Text = "0";
// }
// if (this.tbyy34.Text == "")
// {
// this.tbyy34.Text = "0";
// }
// if (this.tbyy33.Text == "")
// {
// this.tbyy33.Text = "0";
// }
// if (this.tbyy32.Text == "")
// {
// this.tbyy32.Text = "0";
// }
// if (this.tbyy31.Text == "")
// {
// this.tbyy31.Text = "0";
// }
// if (this.tbbhgsl2.Text == "")
// {
// this.tbbhgsl2.Text = "0";
// }
// var allnum3 = int.Parse(this.tbyy31.Text) + int.Parse(this.tbyy32.Text) + int.Parse(this.tbyy33.Text) + int.Parse(this.tbyy34.Text) + int.Parse(this.tbyy35.Text) + int.Parse(this.tbyy36.Text) + int.Parse(this.tbyy37.Text) + int.Parse(this.tbyy38.Text) + int.Parse(this.tbyy39sl.Text);
// if (tbxcsl4.Text == "")
// {
// tbxcsl4.Text = "0";
// }
// var all = int.Parse(this.tbbhgsl2.Text) + int.Parse(tbxcsl4.Text);
// if (this.tbbhgsl2.Text != Convert.ToString(allnum3))
// {
// MessageBox.Show("不合格总数错误", "提示");
// return;
// }
// else if (Convert.ToString(all) != this.tbsjsl4.Text)
// {
// MessageBox.Show("数量与上接数量不符", "提示");
// return;
// }
// #endregion
// }
// else if (yh.机构 == "清洗")
// {
// #region 清洗
// if (this.tbyy40.Text == "")
// {
// this.tbyy40.Text = "0";
// }
// if (this.tbyy41sl.Text == "")
// {
// this.tbyy41sl.Text = "0";
// }
// if (this.tbbhgsl3.Text == "")
// {
// this.tbbhgsl3.Text = "0";
// }
// var allnum4 = int.Parse(this.tbyy40.Text) + int.Parse(this.tbyy41sl.Text);
// if (this.tbxcsl5.Text == "")
// {
// this.tbxcsl5.Text = "0";
// }
// var all = allnum4 + int.Parse(this.tbxcsl5.Text);
// if (this.tbbhgsl3.Text != Convert.ToString(allnum4))
// {
// MessageBox.Show("不合格总数错误", "提示");
// return;
// }
// else if (Convert.ToString(all) != this.tbsjsl5.Text)
// {
// MessageBox.Show("数量与上接数量不符", "提示");
// return;
// }
// #endregion
// }
// else if (yh.机构 == "包装")
// {
// #region 包装
// if (this.tbyy42.Text == "")
// {
// this.tbyy42.Text = "0";
// }
// if (this.tbyy43sl.Text == "")
// {
// this.tbyy43sl.Text = "0";
// }
// if (this.tbbhgsl4.Text == "")
// {
// this.tbbhgsl4.Text = "0";
// }
// var allnum5 = int.Parse(this.tbyy42.Text) + int.Parse(this.tbyy43sl.Text);
// if (this.tbxcsl6.Text == "")
// {
// this.tbxcsl6.Text = "";
// }
// var all = allnum5 + int.Parse(this.tbxcsl6.Text);
// if (this.tbbhgsl4.Text != Convert.ToString(allnum5))
// {
// MessageBox.Show("不合格总数错误", "提示");
// return;
// }
// else if (Convert.ToString(all) != this.tbsjsl6.Text)
// {
// MessageBox.Show("下传数量与上接数量不符", "提示");
// return;
// }
// #endregion
// }
#endregion
//}
#endregion
DialogResult dr = MessageBox.Show("确定要修改吗？？？","提示",MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
var sgd = this.tbSGDXH.Text;
if (sgd != "")
{
tsuhan_sg_tx bhd = new tsuhan_sg_tx();
tsuhan_sg_bhd bh = new tsuhan_sg_bhd();
var sgdh = this.tbSGDXH.Text + this.tbDXH1.Text;
var str = sgdh.Substring(sgdh.Length - 1, 1);
bhd.随工单号 =sgdh ;
var tx = txbll.QueryByXuhao(sgdh);
bhd.id = tx.id;
//if (str == "R")
//{
#region 判断时间格式
//if (yh.机构 == "全部")
//{
var time = this.dtpxcTime.Text;
Match m1 = Regex.Match(dtpxcTime.Text, reg);
Match m2 = Regex.Match(dtp1.Text, reg);
Match m3 = Regex.Match(dtptime2.Text, reg);
Match m4 = Regex.Match(dtpfrtime1.Text, regs);
Match m5 = Regex.Match(dtpqcTime1.Text, regs);
Match m6 = Regex.Match(dtpxtime3.Text, reg);
Match m7 = Regex.Match(dtpxctime3.Text, reg);
Match m8 = Regex.Match(dtpxctime4.Text, reg);
if (m1.Success == false)
{
MessageBox.Show("备料时间格式输入错误.如[2015-5-5]", "提示");
return;
}
else if (m2.Success == false)
{
MessageBox.Show("LD耦合焊接时间格式输入错误.如[2015-5-5]", "提示");
return;
}
else if (m3.Success == false)
{
MessageBox.Show("PT耦合固化时间格式输入错误.如[2015-5-5]", "提示");
return;
}
else if (m4.Success == false)
{
MessageBox.Show("温循前时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
return;
}
else if (m5.Success == false)
{
MessageBox.Show("温循后时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
return;
}
else if (m6.Success == false)
{
MessageBox.Show("测试时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
return;
}
else if (m7.Success == false)
{
MessageBox.Show("清洗时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
return;
}
else if (m8.Success == false)
{
MessageBox.Show("包装时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
return;
}
else
{
BeiLiaoBind(bhd);
LDHanJieBind(bhd);
PTGuHuaBind(bhd);
WenXunQianBind(bhd);
WenXunHouBind(bhd);
CeShiBind(bhd);
QingXiBind(bhd);
BaoZhuangBind(bhd);
}
//}
//else if (yh.机构 == "备料")
//{
// if (tx.bl_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtpxcTime.Text;
// Match m = Regex.Match(dtpxcTime.Text, reg);
// if (m.Success == false)
// {
// MessageBox.Show("备料时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// }
// }
//}
//else if (yh.机构 == "LD耦合焊接")
//{
// if (tx.LD_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtp1.Text;
// Match m = Regex.Match(dtp1.Text, reg);
// if (m.Success == false)
// {
// MessageBox.Show("LD耦合焊接时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// //if (this.tbsjsl1.Text != Convert.ToString(tx.bl_xcsl))
// //{
// // MessageBox.Show("LD耦合焊接上接数量与备料下传数量不符", "提示");
// // return;
// //}
// }
// }
//}
//else if (yh.机构 == "PT耦合固化")
//{
// if (tx.PT_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtptime2.Text;
// Match m = Regex.Match(dtptime2.Text, reg);
// if (m.Success == false)
// {
// MessageBox.Show("PT耦合固化时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// PTGuHuaBind(bhd);
// //if (this.tbsjsl2.Text != Convert.ToString(tx.LD_xcsl))
// //{
// // MessageBox.Show("PT耦合固化上接数量与LD耦合焊接下传数量不符", "提示");
// // return;
// //}
// }
// }
//}
//else if (yh.机构 == "温循前")
//{
// if (tx.WXQ_frsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtpfrtime1.Text;
// Match m = Regex.Match(dtpfrtime1.Text, regs);
// if (m.Success == false)
// {
// MessageBox.Show("温循前时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// PTGuHuaBind(bhd);
// WenXunQianBind(bhd);
// //if (this.tbsjsl3.Text != Convert.ToString(tx.PT_xcsl))
// //{
// // MessageBox.Show("温循前上接数量与PT耦合固化下传数量不符", "提示");
// // return;
// //}
// }
// }
//}
//else if (yh.机构 == "温循后")
//{
// if (tx.WXH_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtpqcTime1.Text;
// Match m = Regex.Match(dtpqcTime1.Text, regs);
// if (m.Success == false)
// {
// MessageBox.Show("温循后时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// PTGuHuaBind(bhd);
// WenXunQianBind(bhd);
// WenXunHouBind(bhd);
// //if (this.tbqcsl1.Text != Convert.ToString(tx.WXQ_frsl))
// //{
// // MessageBox.Show("温循后上接数量与温循前放入数量不符", "提示");
// // return;
// //}
// }
// }
//}
//else if (yh.机构 == "测试")
//{
// if (tx.CS_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtpxtime3.Text;
// Match m = Regex.Match(dtpxtime3.Text, reg);
// if (m.Success == false)
// {
// MessageBox.Show("测试时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// PTGuHuaBind(bhd);
// WenXunQianBind(bhd);
// WenXunHouBind(bhd);
// CeShiBind(bhd);
// //if (this.tbsjsl4.Text != Convert.ToString(tx.WXH_qcsl))
// //{
// // MessageBox.Show("测试上接数量与温循后下传数量不符", "提示");
// // return;
// //}
// }
// }
//}
//else if (yh.机构 == "清洗")
//{
// if (tx.QX_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtpxctime3.Text;
// Match m = Regex.Match(dtpxctime3.Text, reg);
// if (m.Success == false)
// {
// MessageBox.Show("清洗时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// PTGuHuaBind(bhd);
// WenXunQianBind(bhd);
// WenXunHouBind(bhd);
// CeShiBind(bhd);
// QingXiBind(bhd);
// //if (this.tbsjsl5.Text != Convert.ToString(tx.CS_xcsl))
// //{
// // MessageBox.Show("清洗上接数量与测试下传数量不符", "提示");
// // return;
// //}
// }
// }
//}
//else if (yh.机构 == "包装")
//{
// if (tx.BZ_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtpxctime4.Text;
// Match m = Regex.Match(dtpxctime4.Text, reg);
// if (m.Success == false)
// {
// MessageBox.Show("包装时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// PTGuHuaBind(bhd);
// WenXunQianBind(bhd);
// WenXunHouBind(bhd);
// CeShiBind(bhd);
// QingXiBind(bhd);
// BaoZhuangBind(bhd);
// //if (this.tbsjsl6.Text != Convert.ToString(tx.QX_xcsl))
// //{
// // MessageBox.Show("包装上接数量与清洗下传数量不符", "提示");
// // return;
// //}
// }
//}
//}
#endregion
#region
//}
//else
//{
// #region 判断时间格式
// if (yh.机构 == "全部")
// {
// var time = this.dtpxcTime.Text;
// Match m1 = Regex.Match(dtpxcTime.Text, reg);
// Match m2 = Regex.Match(dtp1.Text, reg);
// Match m3 = Regex.Match(dtptime2.Text, reg);
// Match m4 = Regex.Match(dtpfrtime1.Text, regs);
// Match m5 = Regex.Match(dtpqcTime1.Text, regs);
// Match m6 = Regex.Match(dtpxtime3.Text, reg);
// Match m7 = Regex.Match(dtpxctime3.Text, reg);
// Match m8 = Regex.Match(dtpxctime4.Text, reg);
// if (m1.Success == false)
// {
// MessageBox.Show("备料时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else if (m2.Success == false)
// {
// MessageBox.Show("LD耦合焊接时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else if (m3.Success == false)
// {
// MessageBox.Show("PT耦合固化时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else if (m4.Success == false)
// {
// MessageBox.Show("温循前时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
// return;
// }
// else if (m5.Success == false)
// {
// MessageBox.Show("温循后时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
// return;
// }
// else if (m6.Success == false)
// {
// MessageBox.Show("测试时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
// return;
// }
// else if (m7.Success == false)
// {
// MessageBox.Show("清洗时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
// return;
// }
// else if (m8.Success == false)
// {
// MessageBox.Show("包装时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// PTGuHuaBind(bhd);
// WenXunQianBind(bhd);
// WenXunHouBind(bhd);
// CeShiBind(bhd);
// QingXiBind(bhd);
// BaoZhuangBind(bhd);
// }
// }
// else if (yh.机构 == "备料")
// {
// if (tx.bl_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtpxcTime.Text;
// Match m = Regex.Match(dtpxcTime.Text, reg);
// if (m.Success == false)
// {
// MessageBox.Show("备料时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// }
// }
// }
// else if (yh.机构 == "LD耦合焊接")
// {
// if (tx.LD_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtp1.Text;
// Match m = Regex.Match(dtp1.Text, reg);
// if (m.Success == false)
// {
// MessageBox.Show("LD耦合焊接时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// if (this.tbsjsl1.Text != Convert.ToString(tx.bl_xcsl))
// {
// MessageBox.Show("LD耦合焊接上接数量与备料下传数量不符", "提示");
// return;
// }
// }
// }
// }
// else if (yh.机构 == "PT耦合固化")
// {
// if (tx.PT_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtptime2.Text;
// Match m = Regex.Match(dtptime2.Text, reg);
// if (m.Success == false)
// {
// MessageBox.Show("PT耦合固化时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// PTGuHuaBind(bhd);
// if (this.tbsjsl2.Text != Convert.ToString(tx.LD_xcsl))
// {
// MessageBox.Show("PT耦合固化上接数量与LD耦合焊接下传数量不符", "提示");
// return;
// }
// }
// }
// }
// else if (yh.机构 == "温循前")
// {
// if (tx.WXQ_frsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtpfrtime1.Text;
// Match m = Regex.Match(dtpfrtime1.Text, regs);
// if (m.Success == false)
// {
// MessageBox.Show("温循前时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// PTGuHuaBind(bhd);
// WenXunQianBind(bhd);
// if (this.tbsjsl3.Text != Convert.ToString(tx.PT_xcsl))
// {
// MessageBox.Show("温循前上接数量与PT耦合固化下传数量不符", "提示");
// return;
// }
// }
// }
// }
// else if (yh.机构 == "温循后")
// {
// if (tx.WXH_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtpqcTime1.Text;
// Match m = Regex.Match(dtpqcTime1.Text, regs);
// if (m.Success == false)
// {
// MessageBox.Show("温循后时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// PTGuHuaBind(bhd);
// WenXunQianBind(bhd);
// WenXunHouBind(bhd);
// if (this.tbqcsl1.Text != Convert.ToString(tx.WXQ_frsl))
// {
// MessageBox.Show("温循后上接数量与温循前放入数量不符", "提示");
// return;
// }
// }
// }
// }
// else if (yh.机构 == "测试")
// {
// if (tx.CS_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtpxtime3.Text;
// Match m = Regex.Match(dtpxtime3.Text, reg);
// if (m.Success == false)
// {
// MessageBox.Show("测试时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// PTGuHuaBind(bhd);
// WenXunQianBind(bhd);
// WenXunHouBind(bhd);
// CeShiBind(bhd);
// if (this.tbsjsl4.Text != Convert.ToString(tx.WXH_qcsl))
// {
// MessageBox.Show("测试上接数量与温循后下传数量不符", "提示");
// return;
// }
// }
// }
// }
// else if (yh.机构 == "清洗")
// {
// if (tx.QX_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtpxctime3.Text;
// Match m = Regex.Match(dtpxctime3.Text, reg);
// if (m.Success == false)
// {
// MessageBox.Show("清洗时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// PTGuHuaBind(bhd);
// WenXunQianBind(bhd);
// WenXunHouBind(bhd);
// CeShiBind(bhd);
// QingXiBind(bhd);
// if (this.tbsjsl5.Text != Convert.ToString(tx.CS_xcsl))
// {
// MessageBox.Show("清洗上接数量与测试下传数量不符", "提示");
// return;
// }
// }
// }
// }
// else if (yh.机构 == "包装")
// {
// if (tx.BZ_xcsl != null)
// {
// MessageBox.Show("此单你已经提交过了,不能再修改", "提示");
// return;
// }
// else
// {
// var time = this.dtpxctime4.Text;
// Match m = Regex.Match(dtpxctime4.Text, reg);
// if (m.Success == false)
// {
// MessageBox.Show("包装时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// LDHanJieBind(bhd);
// PTGuHuaBind(bhd);
// WenXunQianBind(bhd);
// WenXunHouBind(bhd);
// CeShiBind(bhd);
// QingXiBind(bhd);
// BaoZhuangBind(bhd);
// if (this.tbsjsl6.Text != Convert.ToString(tx.QX_xcsl))
// {
// MessageBox.Show("包装上接数量与清洗下传数量不符", "提示");
// return;
// }
// }
// }
// }
// #endregion
//}
#endregion
bhd.lsh1 = this.tbLSH1.Text;
bhd.lsh2 = this.tbLSH2.Text;
bhd.lsh3 = this.tbLSH3.Text;
bhd.case1 = this.tbCASE1.Text;
bhd.case2 = this.tbCASE2.Text;
bhd.case3 = this.tbCASE3.Text;
bhd.ld1 = this.tbLDP1.Text;
bhd.ld2 = this.tbLDP2.Text;
bhd.ld3 = this.tbLDP3.Text;
bhd.pd1 = this.tbPDP1.Text;
bhd.pd2 = this.tbPDP2.Text;
bhd.pd3 = this.tbPDP3.Text;
bhd.ldj1 = this.tbLDN1.Text;
bhd.ldj2 = this.tbLDN2.Text;
bhd.ldj3 = this.tbLDN3.Text;
if (this.tbJC1.Text=="")
{
this.tbJC1.Text = "0";
}
bhd.jc1 = Convert.ToDecimal(this.tbJC1.Text);
if (this.tbJC2.Text == "")
{
this.tbJC2.Text = "0";
}
bhd.jc2 = Convert.ToDecimal(this.tbJC2.Text);
if (this.tbJC3.Text == "")
{
this.tbJC3.Text = "0";
}
bhd.jc3 = Convert.ToDecimal(this.tbJC3.Text);
bhd.oxl1 = this.tbAXL1.Text;
bhd.oxl2 = this.tbAXL2.Text;
bhd.oxl3 = this.tbAXL3.Text;
bhd.ldxp_xinpianjj = this.tbjj.Text;
bhd.ldxp_jianyanry = this.tbjyry.Text;
bhd.ldxp_jianyansb = this.tbjysb.Text;
bhd.备注 = this.rtbremark.Text;
bhd.LD_xh = this.textBox34.Text;
bhd.LD_name = this.textBox35.Text;
bhd.LD_sjdh = this.textBox36.Text;
bhd.PT_xh = this.textBox39.Text;
bhd.PT_name = this.textBox38.Text;
bhd.PT_sjdh = this.textBox37.Text;
bhd.KT_xh = this.textBox42.Text;
bhd.KT_name = this.textBox41.Text;
bhd.KT_sjdh = this.textBox40.Text;
bhd.NBP_xh0 = this.textBox45.Text;
bhd.NBP_name0 = this.textBox44.Text;
bhd.NBP_sjdh0 = this.textBox43.Text;
bhd.NBP_xh45 = this.textBox51.Text;
bhd.NBP_name45 = this.textBox50.Text;
bhd.NBP_sjdh45 = this.textBox49.Text;
bhd.JK_xh = this.textBox48.Text;
bhd.JK_name = this.textBox47.Text;
bhd.JK_sjdh = this.textBox46.Text;
// bool result3 = bhdbll.Add(bh);
bool result = false;
//bool result1 = false;
result= txbll.Update(bhd);
//result1 = bhdbll.Update(bh);
if (result == true)
{
MessageBox.Show("修改成功！", "提示");
this.btnUpdate.Enabled = false;
}
else
{
MessageBox.Show("修改失败！", "提示");
}
}
}
}
private void tbczy4_MouseUp(object sender, MouseEventArgs e)
{
tsuhan_sg_tx bhd = new tsuhan_sg_tx();
var name =Convert.ToInt32(gh);
tsuhan_scgl_yh yh = yhbll.GetModel(gh);
//if (yh.机构 == "全部")
//{
if (this.tabControl1.SelectedTab == tabPage1)
{
#region 备料
bhd.bl_czy4 = this.tbczy4.Text;
bool result4;
var t = this.tbczy4.Text;
result4 = yhbll.Exist(t);
if (this.tbczy4.Text == "")
{
this.tbczy4.Text = "0";
}
else if (result4 != true)
{
//rg.ShowDialog();
this.tbczName4.Text = "";
return;
}
else
{
var yh4 = yhbll.GetModel(this.tbczy4.Text);
this.tbczName4.Text = yh4.姓名;
bhd.bl_czyname4 = this.tbczName4.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage2)
{
#region LD耦合焊接
bhd.LD_czy4 = this.tbcz4.Text;
bool result4;
result4 = yhbll.Exist(this.tbcz4.Text);
if (this.tbcz4.Text == "")
{
this.tbcz4.Text = "0";
}
else if (result4 != true)
{
//rg.ShowDialog();
this.tbname4.Text = "";
return;
}
else
{
var yh4 = yhbll.GetModel(this.tbcz4.Text);
this.tbname4.Text = yh4.姓名;
bhd.LD_czyname3 = this.tbname3.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage3)
{
#region PT耦合固化
bhd.PT_czy4 = this.tbcz8.Text;
bool result4;
result4 = yhbll.Exist(this.tbcz8.Text);
if (this.tbcz8.Text == "")
{
this.tbcz8.Text = "0";
}
else if (result4 != true)
{
//rg.ShowDialog();
this.tbname8.Text = "";
return;
}
else
{
var yh4 = yhbll.GetModel(this.tbcz8.Text);
this.tbname8.Text = yh4.姓名;
bhd.PT_czyname4 = this.tbname8.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage6)
{
#region 测试
bhd.CS_czy4 = this.tbcz14.Text;
bool result4;
result4 = yhbll.Exist(this.tbcz14.Text);
if (this.tbcz14.Text == "")
{
this.tbcz14.Text = "0";
}
else if (result4 != true)
{
//rg.ShowDialog();
this.tbname14.Text = "";
return;
}
else
{
var yh4 = yhbll.GetModel(this.tbcz14.Text);
this.tbname14.Text = yh4.姓名;
bhd.CS_czyname4 = this.tbname14.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage7)
{
#region 清洗
bhd.QX_czy4 = this.tbcz18.Text;
bool result4;
result4 = yhbll.Exist(this.tbcz18.Text);
if (this.tbcz18.Text == "")
{
this.tbcz18.Text = "0";
}
else if (result4 != true)
{
//rg.ShowDialog();
this.tbname18.Text = "";
return;
}
else
{
var yh4 = yhbll.GetModel(this.tbcz18.Text);
this.tbname18.Text = yh4.姓名;
bhd.QX_czyname4 = this.tbname18.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage8)
{
#region 包装
bhd.BZ_czy4 = this.tbcz22.Text;
bool result4;
result4 = yhbll.Exist(this.tbcz22.Text);
if (this.tbcz22.Text == "")
{
this.tbcz22.Text = "0";
}
else if (result4 != true)
{
//rg.ShowDialog();
this.tbname22.Text = "";
return;
}
else
{
var yh4 = yhbll.GetModel(this.tbcz22.Text);
this.tbname22.Text = yh4.姓名;
bhd.BZ_czyname4 = this.tbname22.Text;
}
#endregion
}
//}
//if (yh.机构 == "备料")
//{
// #region 备料
// bhd.bl_czy4 = this.tbczy4.Text;
// bool result4;
// result4 = yhbll.Exist(this.tbczy4.Text);
// if (this.tbczy4.Text == "")
// {
// this.tbczy4.Text = "0";
// }
// else if (result4 != true)
// {
// rg.ShowDialog();
// this.tbczName4.Text = "";
// return;
// }
// else
// {
// var yh4 = yhbll.GetModel(this.tbczy4.Text);
// this.tbczName4.Text = yh4.姓名;
// bhd.bl_czyname4 = this.tbczName4.Text;
// }
// #endregion
//}
//else if (yh.机构 == "LD耦合焊接")
//{
// #region LD耦合焊接
// bhd.LD_czy4 = this.tbcz4.Text;
// bool result4;
// result4 = yhbll.Exist(this.tbcz4.Text);
// if (this.tbcz4.Text == "")
// {
// this.tbcz4.Text = "0";
// }
// else if (result4 != true)
// {
// rg.ShowDialog();
// this.tbname4.Text = "";
// return;
// }
// else
// {
// var yh4 = yhbll.GetModel(this.tbcz4.Text);
// this.tbname4.Text = yh4.姓名;
// bhd.LD_czyname4 = this.tbname4.Text;
// }
// #endregion
//}
//else if (yh.机构 == "PT耦合固化")
//{
// #region PT耦合固化
// bhd.PT_czy4 = this.tbcz8.Text;
// bool result4;
// result4 = yhbll.Exist(this.tbcz8.Text);
// if (this.tbcz8.Text == "")
// {
// this.tbcz8.Text = "0";
// }
// else if (result4 != true)
// {
// rg.ShowDialog();
// this.tbname8.Text = "";
// return;
// }
// else
// {
// var yh4 = yhbll.GetModel(this.tbcz8.Text);
// this.tbname8.Text = yh4.姓名;
// bhd.PT_czyname4 = this.tbname8.Text;
// }
// #endregion
//}
//else if (yh.机构 == "测试")
//{
// #region 测试
// bhd.CS_czy4 = this.tbcz14.Text;
// bool result4;
// result4 = yhbll.Exist(this.tbcz14.Text);
// if (this.tbcz14.Text == "")
// {
// this.tbcz14.Text = "0";
// }
// else if (result4 != true)
// {
// rg.ShowDialog();
// this.tbname14.Text = "";
// return;
// }
// else
// {
// var yh4 = yhbll.GetModel(this.tbcz14.Text);
// this.tbname14.Text = yh4.姓名;
// bhd.CS_czyname4 = this.tbname14.Text;
// }
// #endregion
//}
//else if (yh.机构 == "清洗")
//{
// #region 清洗
// bhd.QX_czy4 = this.tbcz18.Text;
// bool result4;
// result4 = yhbll.Exist(this.tbcz18.Text);
// if (this.tbcz18.Text == "")
// {
// this.tbcz18.Text = "0";
// }
// else if (result4 != true)
// {
// rg.ShowDialog();
// this.tbname18.Text = "";
// return;
// }
// else
// {
// var yh4 = yhbll.GetModel(this.tbcz18.Text);
// this.tbname18.Text = yh4.姓名;
// bhd.QX_czyname4 = this.tbname18.Text;
// }
// #endregion
//}
//else if (yh.机构 == "包装")
//{
// #region 包装
// bhd.BZ_czy4 = this.tbcz22.Text;
// bool result4;
// result4 = yhbll.Exist(this.tbcz22.Text);
// if (this.tbcz22.Text == "")
// {
// this.tbcz22.Text = "0";
// }
// else if (result4 != true)
// {
// rg.ShowDialog();
// this.tbname22.Text = "";
// return;
// }
// else
// {
// var yh4 = yhbll.GetModel(this.tbcz22.Text);
// this.tbname22.Text = yh4.姓名;
// bhd.BZ_czyname4 = this.tbname22.Text;
// }
// #endregion
//}
}
/// <summary>
/// 新增随工单
/// </summary>
/// <param name="bhd"></param>
/// <returns></returns>
public bool Add(tsuhan_sg_tx model)
{
return dal.Add(model);
}
private void tbczy1_MouseUp(object sender, MouseEventArgs e)
{
tsuhan_sg_tx bhd = new tsuhan_sg_tx();
//var name = Convert.ToInt32(gh);
tsuhan_scgl_yh yh = yhbll.GetModel(gh);
if (this.tabControl1.SelectedTab == tabPage1)
{
#region 备料
bhd.bl_czy1 = this.tbczy1.Text;
bool result1;
result1 = yhbll.Exist(this.tbczy1.Text);
if (this.tbczy1.Text == "")
{
this.tbczy1.Text = "0";
}
else if (result1 != true)
{
rg.ShowDialog();
this.tbczName1.Text = "";
return;
}
else
{
var yh1 = yhbll.GetModel(this.tbczy1.Text);
this.tbczName1.Text = yh1.姓名;
bhd.bl_czyname1 = this.tbczName1.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage2)
{
#region LD耦合焊接
bhd.LD_czy1 = this.tbcz1.Text;
bool result1;
result1 = yhbll.Exist(this.tbcz1.Text);
if (this.tbcz1.Text == "")
{
this.tbcz1.Text = "0";
}
else if (result1 != true)
{
rg.ShowDialog();
this.tbname1.Text = "";
return;
}
else
{
var yh1 = yhbll.GetModel(this.tbcz1.Text);
this.tbname1.Text = yh1.姓名;
bhd.LD_czyname1 = this.tbname1.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage3)
{
#region PT耦合固化
bhd.PT_czy1 = this.tbcz5.Text;
bool result1;
result1 = yhbll.Exist(this.tbcz5.Text);
if (this.tbcz5.Text == "")
{
this.tbcz5.Text = "0";
}
else if (result1 != true)
{
rg.ShowDialog();
this.tbname5.Text = "";
return;
}
else
{
var yh1 = yhbll.GetModel(this.tbcz5.Text);
this.tbname5.Text = yh1.姓名;
bhd.PT_czyname1 = this.tbname5.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage4)
{
#region 温循前
bhd.WXQ_czy = this.tbcz9.Text;
bool result1;
result1 = yhbll.Exist(this.tbcz9.Text);
if (this.tbcz9.Text == "")
{
this.tbcz9.Text = "0";
}
else if (result1 != true)
{
rg.ShowDialog();
this.tbname9.Text = "";
return;
}
else
{
var yh1 = yhbll.GetModel(this.tbcz9.Text);
this.tbname9.Text = yh1.姓名;
bhd.WXQ_czyname = this.tbname9.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage5)
{
#region 温循后
bhd.WXH_czy = this.tbcz10.Text;
bool result1;
result1 = yhbll.Exist(this.tbcz10.Text);
if (this.tbcz10.Text == "")
{
this.tbcz10.Text = "0";
}
else if (result1 != true)
{
rg.ShowDialog();
this.tbname10.Text = "";
return;
}
else
{
var yh1 = yhbll.GetModel(this.tbcz10.Text);
this.tbname10.Text = yh1.姓名;
bhd.WXH_czyname = this.tbname10.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage6)
{
#region 测试
bhd.CS_czy1 = this.tbcz11.Text;
bool result1;
result1 = yhbll.Exist(this.tbcz11.Text);
if (this.tbcz11.Text == "")
{
this.tbcz11.Text = "0";
}
else if (result1 != true)
{
rg.ShowDialog();
this.tbname11.Text = "";
return;
}
else
{
var yh1 = yhbll.GetModel(this.tbcz11.Text);
this.tbname11.Text = yh1.姓名;
bhd.CS_czyname1 = this.tbname11.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage7)
{
#region 清洗
bhd.QX_czy1 = this.tbcz15.Text;
bool result1;
result1 = yhbll.Exist(this.tbcz15.Text);
if (this.tbcz15.Text == "")
{
this.tbcz15.Text = "0";
}
else if (result1 != true)
{
rg.ShowDialog();
this.tbname15.Text = "";
return;
}
else
{
var yh1 = yhbll.GetModel(this.tbcz15.Text);
this.tbname15.Text = yh1.姓名;
bhd.QX_czyname1 = this.tbname15.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage8)
{
#region 包装
bhd.BZ_czy1 = this.tbcz19.Text;
bool result1;
result1 = yhbll.Exist(this.tbcz19.Text);
if (this.tbcz19.Text == "")
{
this.tbcz19.Text = "0";
}
else if (result1 != true)
{
rg.ShowDialog();
this.tbname19.Text = "";
return;
}
else
{
var yh1 = yhbll.GetModel(this.tbcz19.Text);
this.tbname19.Text = yh1.姓名;
bhd.BZ_czyname1 = this.tbname19.Text;
}
#endregion
}
#region
//if (yh.机构 == "全部")
//{
// if (this.tabControl1.SelectedTab == tabPage1)
// {
// #region 备料
// bhd.bl_czy1 = this.tbczy1.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbczy1.Text);
// if (this.tbczy1.Text == "")
// {
// this.tbczy1.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbczName1.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbczy1.Text);
// this.tbczName1.Text = yh1.姓名;
// bhd.bl_czyname1 = this.tbczName1.Text;
// }
// #endregion
// #region 备料
// bhd.bl_czy2 = this.tbczy2.Text;
// bool result2;
// result2 = yhbll.Exist(this.tbczy2.Text);
// if (this.tbczy2.Text == "")
// {
// this.tbczy2.Text = "0";
// }
// else if (result2 != true)
// {
// //rg.ShowDialog();
// this.tbczName2.Text = "";
// return;
// }
// else
// {
// var yh2 = yhbll.GetModel(this.tbczy2.Text);
// this.tbczName2.Text = yh2.姓名;
// bhd.bl_czyname2 = this.tbczName2.Text;
// }
// #endregion
// #region 备料
// bhd.bl_czy3 = this.tbczy3.Text;
// bool result3;
// result3 = yhbll.Exist(this.tbczy3.Text);
// if (this.tbczy3.Text == "")
// {
// this.tbczy3.Text = "0";
// }
// else if (result3 != true)
// {
// //rg.ShowDialog();
// this.tbczName3.Text = "";
// return;
// }
// else
// {
// var yh3 = yhbll.GetModel(this.tbczy3.Text);
// this.tbczName3.Text = yh3.姓名;
// bhd.bl_czyname3 = this.tbczName3.Text;
// }
// #endregion
// #region 备料
// bhd.bl_czy4 = this.tbczy4.Text;
// bool result4;
// result4 = yhbll.Exist(this.tbczy4.Text);
// if (this.tbczy4.Text == "")
// {
// this.tbczy4.Text = "0";
// }
// else if (result4 != true)
// {
// //rg.ShowDialog();
// this.tbczName4.Text = "";
// return;
// }
// else
// {
// var yh4 = yhbll.GetModel(this.tbczy4.Text);
// this.tbczName4.Text = yh4.姓名;
// bhd.bl_czyname4 = this.tbczName4.Text;
// }
// #endregion
// }
// else if (this.tabControl1.SelectedTab == tabPage2)
// {
// #region LD耦合焊接
// bhd.LD_czy1 = this.tbcz1.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz1.Text);
// if (this.tbcz1.Text == "")
// {
// this.tbcz1.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname1.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz1.Text);
// this.tbname1.Text = yh1.姓名;
// bhd.LD_czyname1 = this.tbname1.Text;
// }
// #endregion
// #region LD耦合焊接
// bhd.LD_czy2 = this.tbcz2.Text;
// bool result2;
// result2 = yhbll.Exist(this.tbcz2.Text);
// if (this.tbcz2.Text == "")
// {
// this.tbcz2.Text = "0";
// }
// else if (result2 != true)
// {
// this.tbname2.Text = "";
// return;
// }
// else
// {
// var yh2 = yhbll.GetModel(this.tbcz2.Text);
// this.tbname2.Text = yh2.姓名;
// bhd.LD_czyname1 = this.tbname1.Text;
// }
// #endregion
// #region LD耦合焊接
// bhd.LD_czy3 = this.tbcz3.Text;
// bool result3;
// result3 = yhbll.Exist(this.tbcz3.Text);
// if (this.tbcz3.Text == "")
// {
// this.tbcz3.Text = "0";
// }
// else if (result3 != true)
// {
// //rg.ShowDialog();
// this.tbname3.Text = "";
// return;
// }
// else
// {
// var yh3 = yhbll.GetModel(this.tbcz3.Text);
// this.tbname3.Text = yh3.姓名;
// bhd.LD_czyname2 = this.tbname2.Text;
// }
// #endregion
// #region LD耦合焊接
// bhd.LD_czy4 = this.tbcz4.Text;
// bool result4;
// result4 = yhbll.Exist(this.tbcz4.Text);
// if (this.tbcz4.Text == "")
// {
// this.tbcz4.Text = "0";
// }
// else if (result4 != true)
// {
// //rg.ShowDialog();
// this.tbname4.Text = "";
// return;
// }
// else
// {
// var yh4 = yhbll.GetModel(this.tbcz4.Text);
// this.tbname4.Text = yh4.姓名;
// bhd.LD_czyname3 = this.tbname3.Text;
// }
// #endregion
// }
// else if (this.tabControl1.SelectedTab == tabPage3)
// {
// #region PT耦合固化
// bhd.PT_czy1 = this.tbcz5.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz5.Text);
// if (this.tbcz5.Text == "")
// {
// this.tbcz5.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname5.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz5.Text);
// this.tbname5.Text = yh1.姓名;
// bhd.PT_czyname1 = this.tbname5.Text;
// }
// #endregion
// #region PT耦合固化
// bhd.PT_czy2 = this.tbcz6.Text;
// bool result2;
// result2 = yhbll.Exist(this.tbcz6.Text);
// if (this.tbcz6.Text == "")
// {
// this.tbcz6.Text = "0";
// }
// else if (result2 != true)
// {
// //rg.ShowDialog();
// this.tbname6.Text = "";
// return;
// }
// else
// {
// var yh2 = yhbll.GetModel(this.tbcz6.Text);
// this.tbname6.Text = yh2.姓名;
// bhd.PT_czyname2 = this.tbname6.Text;
// }
// #endregion
// #region PT耦合固化
// bhd.PT_czy3 = this.tbcz7.Text;
// bool result3;
// result3 = yhbll.Exist(this.tbcz7.Text);
// if (this.tbcz7.Text == "")
// {
// this.tbcz7.Text = "0";
// }
// else if (result3 != true)
// {
// //rg.ShowDialog();
// this.tbname7.Text = "";
// return;
// }
// else
// {
// var yh3 = yhbll.GetModel(this.tbcz7.Text);
// this.tbname7.Text = yh3.姓名;
// bhd.PT_czyname3 = this.tbname7.Text;
// }
// #endregion
// #region PT耦合固化
// bhd.PT_czy4 = this.tbcz8.Text;
// bool result4;
// result4 = yhbll.Exist(this.tbcz8.Text);
// if (this.tbcz8.Text == "")
// {
// this.tbcz8.Text = "0";
// }
// else if (result4 != true)
// {
// //rg.ShowDialog();
// this.tbname8.Text = "";
// return;
// }
// else
// {
// var yh4 = yhbll.GetModel(this.tbcz8.Text);
// this.tbname8.Text = yh4.姓名;
// bhd.PT_czyname4 = this.tbname8.Text;
// }
// #endregion
// }
// else if (this.tabControl1.SelectedTab == tabPage4)
// {
// #region 温循前
// bhd.WXQ_czy = this.tbcz9.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz9.Text);
// if (this.tbcz9.Text == "")
// {
// this.tbcz9.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname9.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz9.Text);
// this.tbname9.Text = yh1.姓名;
// bhd.WXQ_czyname = this.tbname9.Text;
// }
// #endregion
// }
// else if (this.tabControl1.SelectedTab == tabPage5)
// {
// #region 温循后
// bhd.WXH_czy = this.tbcz10.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz10.Text);
// if (this.tbcz10.Text == "")
// {
// this.tbcz10.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname10.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz10.Text);
// this.tbname10.Text = yh1.姓名;
// bhd.WXH_czyname = this.tbname10.Text;
// }
// #endregion
// }
// else if (this.tabControl1.SelectedTab == tabPage6)
// {
// #region 测试
// bhd.CS_czy1 = this.tbcz11.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz11.Text);
// if (this.tbcz11.Text == "")
// {
// this.tbcz11.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname11.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz11.Text);
// this.tbname11.Text = yh1.姓名;
// bhd.CS_czyname1 = this.tbname11.Text;
// }
// #endregion
// #region 测试
// bhd.CS_czy2 = this.tbcz12.Text;
// bool result2;
// result2 = yhbll.Exist(this.tbcz12.Text);
// if (this.tbcz12.Text == "")
// {
// this.tbcz12.Text = "0";
// }
// else if (result2 != true)
// {
// //rg.ShowDialog();
// this.tbname12.Text = "";
// return;
// }
// else
// {
// var yh2 = yhbll.GetModel(this.tbcz12.Text);
// this.tbname12.Text = yh2.姓名;
// bhd.CS_czyname2 = this.tbname12.Text;
// }
// #endregion
// #region 测试
// bhd.CS_czy3 = this.tbcz13.Text;
// bool result3;
// result3 = yhbll.Exist(this.tbcz13.Text);
// if (this.tbcz13.Text == "")
// {
// this.tbcz13.Text = "0";
// }
// else if (result3 != true)
// {
// //rg.ShowDialog();
// this.tbname13.Text = "";
// return;
// }
// else
// {
// var yh3 = yhbll.GetModel(this.tbcz13.Text);
// this.tbname13.Text = yh3.姓名;
// bhd.CS_czyname3 = this.tbname13.Text;
// }
// #endregion
// #region 测试
// bhd.CS_czy4 = this.tbcz14.Text;
// bool result4;
// result4 = yhbll.Exist(this.tbcz14.Text);
// if (this.tbcz14.Text == "")
// {
// this.tbcz14.Text = "0";
// }
// else if (result4 != true)
// {
// //rg.ShowDialog();
// this.tbname14.Text = "";
// return;
// }
// else
// {
// var yh4 = yhbll.GetModel(this.tbcz14.Text);
// this.tbname14.Text = yh4.姓名;
// bhd.CS_czyname4 = this.tbname14.Text;
// }
// #endregion
// }
// else if (this.tabControl1.SelectedTab == tabPage7)
// {
// #region 清洗
// bhd.QX_czy1 = this.tbcz15.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz15.Text);
// if (this.tbcz15.Text == "")
// {
// this.tbcz15.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname15.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz15.Text);
// this.tbname15.Text = yh1.姓名;
// bhd.QX_czyname1 = this.tbname15.Text;
// }
// #endregion
// #region 清洗
// bhd.QX_czy2 = this.tbcz16.Text;
// bool result2;
// result2 = yhbll.Exist(this.tbcz16.Text);
// if (this.tbcz16.Text == "")
// {
// this.tbcz16.Text = "0";
// }
// else if (result2 != true)
// {
// //rg.ShowDialog();
// this.tbname16.Text = "";
// return;
// }
// else
// {
// var yh2 = yhbll.GetModel(this.tbcz16.Text);
// this.tbname16.Text = yh2.姓名;
// bhd.QX_czyname2 = this.tbname16.Text;
// }
// #endregion
// #region 清洗
// bhd.QX_czy3 = this.tbcz17.Text;
// bool result3;
// result3 = yhbll.Exist(this.tbcz17.Text);
// if (this.tbcz17.Text == "")
// {
// this.tbcz17.Text = "0";
// }
// else if (result3 != true)
// {
// //rg.ShowDialog();
// this.tbname17.Text = "";
// return;
// }
// else
// {
// var yh3 = yhbll.GetModel(this.tbcz17.Text);
// this.tbname17.Text = yh3.姓名;
// bhd.QX_czyname3 = this.tbname17.Text;
// }
// #endregion
// #region 清洗
// bhd.QX_czy4 = this.tbcz18.Text;
// bool result4;
// result4 = yhbll.Exist(this.tbcz18.Text);
// if (this.tbcz18.Text == "")
// {
// this.tbcz18.Text = "0";
// }
// else if (result4 != true)
// {
// //rg.ShowDialog();
// this.tbname18.Text = "";
// return;
// }
// else
// {
// var yh4 = yhbll.GetModel(this.tbcz18.Text);
// this.tbname18.Text = yh4.姓名;
// bhd.QX_czyname4 = this.tbname18.Text;
// }
// #endregion
// }
// else if (this.tabControl1.SelectedTab == tabPage8)
// {
// #region 包装
// bhd.BZ_czy1 = this.tbcz19.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz19.Text);
// if (this.tbcz19.Text == "")
// {
// this.tbcz19.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname19.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz19.Text);
// this.tbname19.Text = yh1.姓名;
// bhd.BZ_czyname1 = this.tbname19.Text;
// }
// #endregion
// #region 包装
// bhd.BZ_czy2 = this.tbcz20.Text;
// bool result2;
// result2 = yhbll.Exist(this.tbcz20.Text);
// if (this.tbcz20.Text == "")
// {
// this.tbcz20.Text = "0";
// }
// else if (result2 != true)
// {
// //rg.ShowDialog();
// this.tbname20.Text = "";
// return;
// }
// else
// {
// var yh2 = yhbll.GetModel(this.tbcz20.Text);
// this.tbname20.Text = yh2.姓名;
// bhd.BZ_czyname2 = this.tbname20.Text;
// }
// #endregion
// #region 包装
// bhd.BZ_czy3 = this.tbcz21.Text;
// bool result3;
// result3 = yhbll.Exist(this.tbcz21.Text);
// if (this.tbcz21.Text == "")
// {
// this.tbcz21.Text = "0";
// }
// else if (result3 != true)
// {
// //rg.ShowDialog();
// this.tbname21.Text = "";
// return;
// }
// else
// {
// var yh3 = yhbll.GetModel(this.tbcz21.Text);
// this.tbname21.Text = yh3.姓名;
// bhd.BZ_czyname3 = this.tbname21.Text;
// }
// #endregion
// #region 包装
// bhd.BZ_czy4 = this.tbcz22.Text;
// bool result4;
// result4 = yhbll.Exist(this.tbcz22.Text);
// if (this.tbcz22.Text == "")
// {
// this.tbcz22.Text = "0";
// }
// else if (result4 != true)
// {
// //rg.ShowDialog();
// this.tbname22.Text = "";
// return;
// }
// else
// {
// var yh4 = yhbll.GetModel(this.tbcz22.Text);
// this.tbname22.Text = yh4.姓名;
// bhd.BZ_czyname4 = this.tbname22.Text;
// }
// #endregion
// }
//}
//if (yh.机构 == "备料")
//{
// #region 备料
// bhd.bl_czy1 = this.tbczy1.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbczy1.Text);
// if (this.tbczy1.Text == "")
// {
// this.tbczy1.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbczName1.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbczy1.Text);
// this.tbczName1.Text = yh1.姓名;
// bhd.bl_czyname1 = this.tbczName1.Text;
// }
// #endregion
//}
//else if (yh.机构 == "LD耦合焊接")
//{
// #region LD耦合焊接
// bhd.LD_czy1 = this.tbcz1.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz1.Text);
// if (this.tbcz1.Text == "")
// {
// this.tbcz1.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname1.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz1.Text);
// this.tbname1.Text = yh1.姓名;
// bhd.LD_czyname1 = this.tbname1.Text;
// }
// #endregion
//}
//else if (yh.机构 == "PT耦合固化")
//{
// #region PT耦合固化
// bhd.PT_czy1 = this.tbcz5.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz5.Text);
// if (this.tbcz5.Text == "")
// {
// this.tbcz5.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname5.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz5.Text);
// this.tbname5.Text = yh1.姓名;
// bhd.PT_czyname1 = this.tbname5.Text;
// }
// #endregion
//}
//else if (yh.机构 == "温循前")
//{
// #region 温循前
// bhd.WXQ_czy = this.tbcz9.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz9.Text);
// if (this.tbcz9.Text == "")
// {
// this.tbcz9.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname9.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz9.Text);
// this.tbname9.Text = yh1.姓名;
// bhd.WXQ_czyname = this.tbname9.Text;
// }
// #endregion
//}
//else if (yh.机构 == "温循后")
//{
// #region 温循后
// bhd.WXH_czy = this.tbcz10.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz10.Text);
// if (this.tbcz10.Text == "")
// {
// this.tbcz10.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname10.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz10.Text);
// this.tbname10.Text = yh1.姓名;
// bhd.WXH_czyname = this.tbname10.Text;
// }
// #endregion
//}
//else if (yh.机构 == "测试")
//{
// #region 测试
// bhd.CS_czy1 = this.tbcz11.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz11.Text);
// if (this.tbcz11.Text == "")
// {
// this.tbcz11.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname11.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz11.Text);
// this.tbname11.Text = yh1.姓名;
// bhd.CS_czyname1 = this.tbname11.Text;
// }
// #endregion
//}
//else if (yh.机构 == "清洗")
//{
// #region 清洗
// bhd.QX_czy1 = this.tbcz15.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz15.Text);
// if (this.tbcz15.Text == "")
// {
// this.tbcz15.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname15.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz15.Text);
// this.tbname15.Text = yh1.姓名;
// bhd.QX_czyname1 = this.tbname15.Text;
// }
// #endregion
//}
//else if (yh.机构 == "包装")
//{
// #region 包装
// bhd.BZ_czy1 = this.tbcz19.Text;
// bool result1;
// result1 = yhbll.Exist(this.tbcz19.Text);
// if (this.tbcz19.Text == "")
// {
// this.tbcz19.Text = "0";
// }
// else if (result1 != true)
// {
// rg.ShowDialog();
// this.tbname19.Text = "";
// return;
// }
// else
// {
// var yh1 = yhbll.GetModel(this.tbcz19.Text);
// this.tbname19.Text = yh1.姓名;
// bhd.BZ_czyname1 = this.tbname19.Text;
// }
// #endregion
//}
#endregion
}
/// <summary>
/// LD耦合焊接
/// </summary>
/// <param name="bhd"></param>
private void LDHanJieBind(tsuhan_sg_tx bhd)
{
#region LD耦合焊接
bhd.LD_sbbh1 = this.tb1.Text;
bhd.LD_sbbh2 = this.tb2.Text;
bhd.LD_sbbh3 = this.tb3.Text;
bhd.LD_sbbh4 = this.tb4.Text;
if (this.tbsjsl1.Text == "")
{
this.tbsjsl1.Text = "0";
}
bhd.LD_sjsl = Convert.ToInt32(this.tbsjsl1.Text);
if (this.tbxcsl1.Text == "")
{
this.tbxcsl1.Text = "0";
}
bhd.LD_xcsl = Convert.ToInt32(this.tbxcsl1.Text);
if (this.dtp1.Text == "" || this.dtp1.Text == string.Empty)
{
this.dtp1.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
bhd.LD_xctime = Convert.ToDateTime(this.dtp1.Text);
bhd.LD_czy1 = this.tbcz1.Text;
bhd.LD_czy2 = this.tbcz2.Text;
bhd.LD_czy3 = this.tbcz3.Text;
bhd.LD_czy4 = this.tbcz4.Text;
bhd.LD_czyname1 = this.tbname1.Text;
bhd.LD_czyname2 = this.tbname2.Text;
bhd.LD_czyname3 = this.tbname3.Text;
bhd.LD_czyname4 = this.tbname4.Text;
bhd.LD_lry = this.tblr1.Text;
bhd.LD_lryname = this.tblrname1.Text;
if (this.tbyy11.Text == "")
{
this.tbyy11.Text = "0";
}
bhd.ldng1 = Convert.ToInt32(this.tbyy11.Text);
if (this.tbyy12.Text == "")
{
this.tbyy12.Text = "0";
}
bhd.ldng2 = Convert.ToInt32(this.tbyy12.Text);
if (this.tbyy13.Text == "")
{
this.tbyy13.Text = "0";
}
bhd.ldng3 = Convert.ToInt32(this.tbyy13.Text);
if (this.tbyy14.Text == "")
{
this.tbyy14.Text = "0";
}
bhd.ldng4 = Convert.ToInt32(this.tbyy14.Text);
if (this.tbyy15.Text == "")
{
this.tbyy15.Text = "0";
}
bhd.ldng5 = Convert.ToInt32(this.tbyy15.Text);
if (this.tbyy16.Text == "")
{
this.tbyy16.Text = "0";
}
bhd.ldng6 = Convert.ToInt32(this.tbyy16.Text);
if (this.tbyy17.Text == "")
{
this.tbyy17.Text = "0";
}
bhd.ldng7 = Convert.ToInt32(this.tbyy17.Text);
if (this.tbyy18.Text == "")
{
this.tbyy18.Text = "0";
}
bhd.ldng8 = Convert.ToInt32(this.tbyy18.Text);
if (this.tbyy19.Text == "")
{
this.tbyy19.Text = "0";
}
bhd.ldng9 = Convert.ToInt32(this.tbyy19.Text);
bhd.ldngoth = this.tbyy20.Text;
if (this.tbyy20sl.Text == "")
{
this.tbyy20sl.Text = "0";
}
bhd.ldngothnum = Convert.ToInt32(this.tbyy20sl.Text);
if (this.tbbhksl1.Text=="")
{
this.tbbhksl1.Text = "0";
}
bhd.LD_bhgallsl = Convert.ToInt32(this.tbbhksl1.Text);
if (this.tbjzsl1.Text == "")
{
this.tbjzsl1.Text = "0";
}
bhd.LD_jzsl = Convert.ToInt32(this.tbjzsl1.Text);
#endregion
}
/// <summary>
/// 新增随工单
/// </summary>
/// <param name="bhd"></param>
/// <returns></returns>
public bool Add(tsuhan_sg_tx model)
{
return(dal.Add(model));
}
/// <summary>
/// 备料
/// </summary>
/// <param name="bhd"></param>
private void BeiLiaoBind(tsuhan_sg_tx bhd)
{
#region 备料
bhd.bl_sbbh1 = this.tbsbbh1.Text;
bhd.bl_sbbh2 = this.tbsbbh2.Text;
bhd.bl_sbbh3 = this.tbsbbh3.Text;
bhd.bl_sbbh4 = this.tbsbbh4.Text;
if (this.tbxcsl.Text=="")
{
this.tbxcsl.Text = "0";
}
bhd.bl_xcsl = Convert.ToInt32(this.tbxcsl.Text);
if (this.tbbhgsl.Text == "")
{
this.tbbhgsl.Text = "0";
}
bhd.bl_bhgallsl = Convert.ToInt32(this.tbbhgsl.Text);
if (this.dtpxcTime.Text == "" || this.dtpxcTime.Text == string.Empty)
{
this.dtpxcTime.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
bhd.bl_xctime = Convert.ToDateTime(this.dtpxcTime.Text);
bhd.bl_czy1 = this.tbczy1.Text;
bhd.bl_czy2 = this.tbczy2.Text;
bhd.bl_czy3 = this.tbczy3.Text;
//bhd.bl_czy4 = this.tbczy4.Text;
//var yh1 = yhbll.GetModel(this.tbczy1.Text);
//var yh2 = yhbll.GetModel(this.tbczy2.Text);
//var yh3 = yhbll.GetModel(this.tbczy3.Text);
//var yh4 = yhbll.GetModel(this.tbczy4.Text);
//this.tbczName1.Text = yh1.姓名;
//this.tbczName2.Text = yh2.姓名;
//this.tbczName3.Text = yh3.姓名;
//this.tbczName4.Text = yh4.姓名;
bhd.bl_czyname1 = this.tbczName1.Text;
bhd.bl_czyname2 = this.tbczName2.Text;
bhd.bl_czyname3 = this.tbczName3.Text;
bhd.bl_czyname4 = this.tbczName4.Text;
bhd.bl_lry = this.tblry.Text;
bhd.bl_lryname = this.tblrName.Text;
if (this.tbyy1.Text=="")
{
this.tbyy1.Text = "0";
}
bhd.blng1 = Convert.ToInt32(this.tbyy1.Text);
if (this.tbyy2.Text == "")
{
this.tbyy2.Text = "0";
}
bhd.blng2 = Convert.ToInt32(this.tbyy2.Text);
if (this.tbyy3.Text == "")
{
this.tbyy3.Text = "0";
}
bhd.blng3 = Convert.ToInt32(this.tbyy3.Text);
if (this.tbyy4.Text == "")
{
this.tbyy4.Text = "0";
}
bhd.blng4 = Convert.ToInt32(this.tbyy4.Text);
if (this.tbyy5.Text == "")
{
this.tbyy5.Text = "0";
}
bhd.blng5 = Convert.ToInt32(this.tbyy5.Text);
if (this.tbyy6.Text == "")
{
this.tbyy6.Text = "0";
}
bhd.blng6 = Convert.ToInt32(this.tbyy6.Text);
if (this.tbyy7.Text == "")
{
this.tbyy7.Text = "0";
}
bhd.blng7 = Convert.ToInt32(this.tbyy7.Text);
if (this.tbyy8.Text == "")
{
this.tbyy8.Text = "0";
}
bhd.blng8 = Convert.ToInt32(this.tbyy8.Text);
if (this.tbyy9.Text == "")
{
this.tbyy9.Text = "0";
}
bhd.blng9 = Convert.ToInt32(this.tbyy9.Text);
bhd.blngoth = this.tbyy10.Text;
if (this.tbyy10Sl.Text == "")
{
this.tbyy10Sl.Text = "0";
}
bhd.blngothnum = Convert.ToInt32(this.tbyy10Sl.Text);
#endregion
}
/// <summary>
/// 测试
/// </summary>
/// <param name="bhd"></param>
private void CeShiBind(tsuhan_sg_tx bhd)
{
#region 测试
bhd.CS_sbbh1 = this.tb11.Text;
bhd.CS_sbbh2 = this.tb12.Text;
bhd.CS_sbbh3 = this.tb13.Text;
bhd.CS_sbbh4 = this.tb14.Text;
if (this.tbsjsl4.Text == "")
{
this.tbsjsl4.Text = "0";
}
bhd.CS_sjsl = Convert.ToInt32(this.tbsjsl4.Text);
if (this.tbxcsl4.Text == "")
{
this.tbxcsl4.Text = "0";
}
bhd.CS_xcsl = Convert.ToInt32(this.tbxcsl4.Text);
if (this.dtpxtime3.Text == "")
{
this.dtpxtime3.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
bhd.CS_xctime = Convert.ToDateTime(this.dtpxtime3.Text);
bhd.CS_czy1 = this.tbcz11.Text;
bhd.CS_czy2 = this.tbcz12.Text;
bhd.CS_czy3 = this.tbcz13.Text;
bhd.CS_czy4 = this.tbcz14.Text;
bhd.CS_czyname1 = this.tbname11.Text;
bhd.CS_czyname2 = this.tbname12.Text;
bhd.CS_czyname3 = this.tbname13.Text;
bhd.CS_czyname4 = this.tbname14.Text;
bhd.CS_lry = this.tblr5.Text;
bhd.CS_lryname = this.tblrname5.Text;
if (this.tbyy31.Text == "")
{
this.tbyy31.Text = "0";
}
bhd.csng1 = Convert.ToInt32(this.tbyy31.Text);
if (this.tbyy32.Text == "")
{
this.tbyy32.Text = "0";
}
bhd.csng2 = Convert.ToInt32(this.tbyy32.Text);
if (this.tbyy33.Text == "")
{
this.tbyy33.Text = "0";
}
bhd.csng3 = Convert.ToInt32(this.tbyy33.Text);
if (this.tbyy34.Text == "")
{
this.tbyy34.Text = "0";
}
bhd.csng4 = Convert.ToInt32(this.tbyy34.Text);
if (this.tbyy35.Text == "")
{
this.tbyy35.Text = "0";
}
bhd.csng5 = Convert.ToInt32(this.tbyy35.Text);
if (this.tbyy36.Text == "")
{
this.tbyy36.Text = "0";
}
bhd.csng6 = Convert.ToInt32(this.tbyy36.Text);
if (this.tbyy37.Text == "")
{
this.tbyy37.Text = "0";
}
bhd.csng7 = Convert.ToInt32(this.tbyy37.Text);
if (this.tbyy38.Text == "")
{
this.tbyy38.Text = "0";
}
bhd.csng8 = Convert.ToInt32(this.tbyy38.Text);
bhd.csngoth = this.rtbyy39.Text;
if (this.tbyy39sl.Text == "")
{
this.tbyy39sl.Text = "0";
}
bhd.csngothnum = Convert.ToInt32(this.tbyy39sl.Text);
if (this.tbbhgsl2.Text == "")
{
this.tbbhgsl2.Text = "0";
}
bhd.CS_bhgallsl = Convert.ToInt32(this.tbbhgsl2.Text);
#endregion
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
//时间正则表达式
string reg = @"^((((1[6-9]|[2-9]\d)\d{2})-(0?[13578]|1[02])-(0?[1-9]|[12]\d|3[01]))|(((1[6-9]|[2-9]\d)\d{2})-(0?[13456789]|1[012])-(0?[1-9]|[12]\d|30))|(((1[6-9]|[2-9]\d)\d{2})-0?2-(0?[1-9]|1\d|2[0-8]))|(((1[6-9]|[2-9]\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))-0?2-29-))$";
string regs = @"^(((((1[6-9]|[2-9]\d)\d{2})-(0?[13578]|1[02])-(0?[1-9]|[12]\d|3[01]))|(((1[6-9]|[2-9]\d)\d{2})-(0?[13456789]|1[012])-(0?[1-9]|[12]\d|30))|(((1[6-9]|[2-9]\d)\d{2})-0?2-(0?[1-9]|1\d|2[0-8]))|(((1[6-9]|[2-9]\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))-0?2-29-)) (20|21|22|23|[0-1]?\d):[0-5]?\d:[0-5]?\d)$";
var name =Convert.ToInt32(gh);
tsuhan_scgl_yh yh = yhbll.GetModel(gh);
tsuhan_sg_tx bhd = new tsuhan_sg_tx();
var sgdxh = this.tbSGDXH.Text + this.tbDXH1.Text;
bhd.随工单号 = sgdxh;
#region 判断不合格数量是否正确
//if (yh.机构 == "备料")
//{
if (this.tbyy10Sl.Text == "")
{
this.tbyy10Sl.Text = "0";
}
if (this.tbyy9.Text == "")
{
this.tbyy9.Text = "0";
}
if (this.tbyy8.Text == "")
{
this.tbyy8.Text = "0";
}
if (this.tbyy7.Text == "")
{
this.tbyy7.Text = "0";
}
if (this.tbyy6.Text == "")
{
this.tbyy6.Text = "0";
}
if (this.tbyy5.Text == "")
{
this.tbyy5.Text = "0";
}
if (this.tbyy4.Text == "")
{
this.tbyy4.Text = "0";
}
if (this.tbyy3.Text == "")
{
this.tbyy3.Text = "0";
}
if (this.tbyy2.Text == "")
{
this.tbyy2.Text = "0";
}
if (this.tbyy1.Text == "")
{
this.tbyy1.Text = "0";
}
if (this.tbbhgsl.Text == "")
{
this.tbbhgsl.Text = "0";
}
var allnum = int.Parse(this.tbyy1.Text) + int.Parse(this.tbyy2.Text) + int.Parse(this.tbyy3.Text) + int.Parse(this.tbyy4.Text) + int.Parse(this.tbyy5.Text) + int.Parse(this.tbyy6.Text) + int.Parse(this.tbyy7.Text) + int.Parse(this.tbyy8.Text) + int.Parse(this.tbyy9.Text) + int.Parse(this.tbyy10Sl.Text);
if (this.tbbhgsl.Text != Convert.ToString(allnum))
{
MessageBox.Show("不合格总数错误", "提示");
return;
}
//}
//else if (yh.机构 == "LD耦合焊接")
//{
if (this.tbyy20sl.Text == "")
{
this.tbyy20sl.Text = "0";
}
if (this.tbyy19.Text == "")
{
this.tbyy19.Text = "0";
}
if (this.tbyy18.Text == "")
{
this.tbyy18.Text = "0";
}
if (this.tbyy17.Text == "")
{
this.tbyy17.Text = "0";
}
if (this.tbyy16.Text == "")
{
this.tbyy16.Text = "0";
}
if (this.tbyy15.Text == "")
{
this.tbyy15.Text = "0";
}
if (this.tbyy14.Text == "")
{
this.tbyy14.Text = "0";
}
if (this.tbyy13.Text == "")
{
this.tbyy13.Text = "0";
}
if (this.tbyy12.Text == "")
{
this.tbyy12.Text = "0";
}
if (this.tbyy11.Text == "")
{
this.tbyy11.Text = "0";
}
if (this.tbjzsl1.Text == "")
{
this.tbjzsl1.Text = "0";
}
if (this.tbbhksl1.Text == "")
{
this.tbbhksl1.Text = "0";
}
var allnum1 = int.Parse(this.tbyy11.Text) + int.Parse(this.tbyy12.Text) + int.Parse(this.tbyy13.Text) + int.Parse(this.tbyy14.Text) + int.Parse(this.tbyy15.Text) + int.Parse(this.tbyy16.Text) + int.Parse(this.tbyy17.Text) + int.Parse(this.tbyy18.Text) + int.Parse(this.tbyy19.Text) + int.Parse(this.tbyy20sl.Text);
var num = int.Parse(this.tbbhksl1.Text) + int.Parse(this.tbjzsl1.Text);
var all = num + int.Parse(this.tbxcsl1.Text);
if (Convert.ToString(num) != Convert.ToString(allnum1))
{
MessageBox.Show("不合格总数错误", "提示");
return;
}
else if (Convert.ToString(all) != this.tbsjsl1.Text)
{
MessageBox.Show("数量与上接数量不符", "提示");
return;
}
//}
//else if (yh.机构 == "PT耦合固化")
//{
if (this.tbyy30sl.Text == "")
{
this.tbyy30sl.Text = "0";
}
if (this.tbyy29.Text == "")
{
this.tbyy29.Text = "0";
}
if (this.tbyy28.Text == "")
{
this.tbyy28.Text = "0";
}
if (this.tbyy27.Text == "")
{
this.tbyy27.Text = "0";
}
if (this.tbyy26.Text == "")
{
this.tbyy26.Text = "0";
}
if (this.tbyy25.Text == "")
{
this.tbyy25.Text = "0";
}
if (this.tbyy24.Text == "")
{
this.tbyy24.Text = "0";
}
if (this.tbyy23.Text == "")
{
this.tbyy23.Text = "0";
}
if (this.tbyy22.Text == "")
{
this.tbyy22.Text = "0";
}
if (this.tbyy21.Text == "")
{
this.tbyy21.Text = "0";
}
if (this.textBox100.Text == "")
{
this.textBox100.Text = "0";
}
var allnum2 = int.Parse(this.tbyy21.Text) + int.Parse(this.tbyy22.Text) + int.Parse(this.tbyy23.Text) + int.Parse(this.tbyy24.Text) + int.Parse(this.tbyy25.Text) + int.Parse(this.tbyy26.Text) + int.Parse(this.tbyy27.Text) + int.Parse(this.tbyy28.Text) + int.Parse(this.tbyy29.Text) + int.Parse(this.tbyy30sl.Text);
var all1 = int.Parse(this.textBox100.Text) + int.Parse(this.tbxcsl2.Text);
if (this.textBox100.Text != Convert.ToString(allnum2))
{
MessageBox.Show("不合格总数错误", "提示");
return;
}
else if (Convert.ToString(all1) != this.tbsjsl2.Text)
{
MessageBox.Show("数量与上接数量不符", "提示");
return;
}
//}
//else if (yh.机构 == "测试")
//{
if (this.tbyy39sl.Text == "")
{
this.tbyy39sl.Text = "0";
}
if (this.tbyy38.Text == "")
{
this.tbyy38.Text = "0";
}
if (this.tbyy37.Text == "")
{
this.tbyy37.Text = "0";
}
if (this.tbyy36.Text == "")
{
this.tbyy36.Text = "0";
}
if (this.tbyy35.Text == "")
{
this.tbyy35.Text = "0";
}
if (this.tbyy34.Text == "")
{
this.tbyy34.Text = "0";
}
if (this.tbyy33.Text == "")
{
this.tbyy33.Text = "0";
}
if (this.tbyy32.Text == "")
{
this.tbyy32.Text = "0";
}
if (this.tbyy31.Text == "")
{
this.tbyy31.Text = "0";
}
if (this.tbbhgsl2.Text == "")
{
this.tbbhgsl2.Text = "0";
}
var allnum3 = int.Parse(this.tbyy31.Text) + int.Parse(this.tbyy32.Text) + int.Parse(this.tbyy33.Text) + int.Parse(this.tbyy34.Text) + int.Parse(this.tbyy35.Text) + int.Parse(this.tbyy36.Text) + int.Parse(this.tbyy37.Text) + int.Parse(this.tbyy38.Text) + int.Parse(this.tbyy39sl.Text);
var all2 = int.Parse(this.tbbhgsl2.Text) + int.Parse(tbxcsl4.Text);
if (this.tbbhgsl2.Text != Convert.ToString(allnum3))
{
MessageBox.Show("不合格总数错误", "提示");
return;
}
else if (Convert.ToString(all2) != this.tbsjsl4.Text)
{
MessageBox.Show("数量与上接数量不符", "提示");
return;
}
//}
//else if (yh.机构 == "清洗")
//{
if (this.tbyy40.Text == "")
{
this.tbyy40.Text = "0";
}
if (this.tbyy41sl.Text == "")
{
this.tbyy41sl.Text = "0";
}
if (this.tbbhgsl3.Text == "")
{
this.tbbhgsl3.Text = "0";
}
var allnum4 = int.Parse(this.tbyy40.Text) + int.Parse(this.tbyy41sl.Text);
var all3 = int.Parse(this.tbbhgsl3.Text) + int.Parse(this.tbxcsl5.Text);
if (this.tbbhgsl3.Text != Convert.ToString(allnum4))
{
MessageBox.Show("不合格总数错误", "提示");
return;
}
else if (Convert.ToString(all3) != this.tbsjsl5.Text)
{
MessageBox.Show("数量与上接数量不符", "提示");
return;
}
//}
//else if (yh.机构 == "包装")
//{
if (this.tbyy42.Text == "")
{
this.tbyy42.Text = "0";
}
if (this.tbyy43sl.Text == "")
{
this.tbyy43sl.Text = "0";
}
if (this.tbbhgsl4.Text == "")
{
this.tbbhgsl4.Text = "0";
}
var allnum5 = int.Parse(this.tbyy42.Text) + int.Parse(this.tbyy43sl.Text);
var all4 =int.Parse(this.tbbhgsl4.Text)+ int.Parse(this.tbxcsl6.Text);
if (this.tbbhgsl4.Text != Convert.ToString(allnum5))
{
MessageBox.Show("不合格总数错误", "提示");
return;
}
else if (Convert.ToString(all4) != this.tbsjsl6.Text)
{
MessageBox.Show("数量与上接数量不符", "提示");
return;
}
//}
#endregion
#region
//if (yh.机构 == "全部")
//{
var time = this.dtpxcTime.Text;
Match m1 = Regex.Match(dtpxcTime.Text, reg);
Match m2 = Regex.Match(dtp1.Text, reg);
Match m3 = Regex.Match(dtptime2.Text, reg);
Match m4 = Regex.Match(dtpfrtime1.Text, regs);
Match m5 = Regex.Match(dtpqcTime1.Text, regs);
Match m6 = Regex.Match(dtpxtime3.Text, reg);
Match m7 = Regex.Match(dtpxctime3.Text, reg);
Match m8 = Regex.Match(dtpxctime4.Text, reg);
if (m1.Success == false)
{
MessageBox.Show("备料时间格式输入错误.如[2015-5-5]", "提示");
return;
}
else if (m2.Success == false)
{
MessageBox.Show("LD耦合焊接时间格式输入错误.如[2015-5-5]", "提示");
return;
}
else if (m3.Success == false)
{
MessageBox.Show("PT耦合固化时间格式输入错误.如[2015-5-5]", "提示");
return;
}
else if (m4.Success == false)
{
MessageBox.Show("温循前时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
return;
}
else if (m5.Success == false)
{
MessageBox.Show("温循后时间格式输入错误.如[2015-5-5 00:00:00]", "提示");
return;
}
else if (m6.Success == false)
{
MessageBox.Show("测试时间格式输入错误.如[2015-5-5]", "提示");
return;
}
else if (m7.Success == false)
{
MessageBox.Show("清洗时间格式输入错误.如[2015-5-5]", "提示");
return;
}
else if (m8.Success == false)
{
MessageBox.Show("包装时间格式输入错误.如[2015-5-5]", "提示");
return;
}
else
{
BeiLiaoBind(bhd);
LDHanJieBind(bhd);
PTGuHuaBind(bhd);
WenXunQianBind(bhd);
WenXunHouBind(bhd);
CeShiBind(bhd);
QingXiBind(bhd);
BaoZhuangBind(bhd);
}
//}
//else if (yh.机构 == "备料")
//{
// var time = this.dtpxcTime.Text;
// Match m = Regex.Match(dtpxcTime.Text, reg);
// if (m.Success == false)
// {
// MessageBox.Show("备料时间格式输入错误.如[2015-5-5]", "提示");
// return;
// }
// else
// {
// BeiLiaoBind(bhd);
// }
//}
#endregion
bhd.lsh1 = this.tbLSH1.Text;
bhd.lsh2 = this.tbLSH2.Text;
bhd.lsh3 = this.tbLSH3.Text;
bhd.case1 = this.tbCASE1.Text;
bhd.case2 = this.tbCASE2.Text;
bhd.case3 = this.tbCASE3.Text;
bhd.ld1 = this.tbLDP1.Text;
bhd.ld2 = this.tbLDP2.Text;
bhd.ld3 = this.tbLDP3.Text;
bhd.pd1 = this.tbPDP1.Text;
bhd.pd2 = this.tbPDP2.Text;
bhd.pd3 = this.tbPDP3.Text;
bhd.ldj1 = this.tbLDN1.Text;
bhd.ldj2 = this.tbLDN2.Text;
bhd.ldj3 = this.tbLDN3.Text;
if (this.tbJC1.Text == "")
{
this.tbJC1.Text = "0";
}
if (this.tbJC2.Text == "")
{
this.tbJC2.Text = "0";
}
if (this.tbJC3.Text == "")
{
this.tbJC3.Text = "0";
}
bhd.jc1 = Convert.ToDecimal(this.tbJC1.Text);
bhd.jc2 = Convert.ToDecimal(this.tbJC2.Text);
bhd.jc3 = Convert.ToDecimal(this.tbJC3.Text);
bhd.oxl1 = this.tbAXL1.Text;
bhd.oxl2 = this.tbAXL2.Text;
bhd.oxl3 = this.tbAXL3.Text;
bhd.ldxp_xinpianjj = this.tbjj.Text;
bhd.ldxp_jianyanry = this.tbjyry.Text;
bhd.ldxp_jianyansb = this.tbjysb.Text;
bhd.备注 = this.rtbremark.Text;
bhd.LD_xh = this.textBox34.Text;
bhd.LD_name = this.textBox35.Text;
bhd.LD_sjdh = this.textBox36.Text;
bhd.PT_xh = this.textBox39.Text;
bhd.PT_name = this.textBox38.Text;
bhd.PT_sjdh = this.textBox37.Text;
bhd.KT_xh = this.textBox42.Text;
bhd.KT_name = this.textBox41.Text;
bhd.KT_sjdh = this.textBox40.Text;
bhd.NBP_xh0 = this.textBox45.Text;
bhd.NBP_name0 = this.textBox44.Text;
bhd.NBP_sjdh0 = this.textBox43.Text;
bhd.NBP_xh45 = this.textBox51.Text;
bhd.NBP_name45 = this.textBox50.Text;
bhd.NBP_sjdh45 = this.textBox49.Text;
bhd.JK_xh = this.textBox48.Text;
bhd.JK_name = this.textBox47.Text;
bhd.JK_sjdh = this.textBox46.Text;
bool result2 = false;
result2 = txbll.Add(bhd);
if (result2 == true)
{
MessageBox.Show("添加数据成功", "提示");
this.btnSend.Enabled = false;
this.btnSend.BackColor = Color.LightGray;
this.btnOk.Enabled = false;
this.btnOk.BackColor = Color.LightGray;
}
else
{
MessageBox.Show("添加数据失败", "提示");
}
}
private void tbczy3_MouseUp(object sender, MouseEventArgs e)
{
tsuhan_sg_tx bhd = new tsuhan_sg_tx();
string name = frmOne.txtUserName.Text;
tsuhan_scgl_yh yh = yhbll.GetModel(name);
//if (yh.工序名称 == "全部")
//{
if (this.tabControl1.SelectedTab == tabPage1)
{
#region 备料
bhd.bl_czy3 = this.tbczy3.Text;
bool result3;
result3 = yhbll.Exist(this.tbczy3.Text);
if (this.tbczy3.Text == "")
{
this.tbczy3.Text = "0";
}
else if (result3 != true)
{
//rg.ShowDialog();
this.tbczName3.Text = "";
return;
}
else
{
var yh3 = yhbll.GetModel(this.tbczy3.Text);
this.tbczName3.Text = yh3.姓名;
bhd.bl_czyname3 = this.tbczName3.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage2)
{
#region LD耦合焊接
bhd.LD_czy3 = this.tbcz3.Text;
bool result3;
result3 = yhbll.Exist(this.tbcz3.Text);
if (this.tbcz3.Text == "")
{
this.tbcz3.Text = "0";
}
else if (result3 != true)
{
//rg.ShowDialog();
this.tbname3.Text = "";
return;
}
else
{
var yh3 = yhbll.GetModel(this.tbcz3.Text);
this.tbname3.Text = yh3.姓名;
bhd.LD_czyname2 = this.tbname2.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage3)
{
#region PT耦合固化
bhd.PT_czy3 = this.tbcz7.Text;
bool result3;
result3 = yhbll.Exist(this.tbcz7.Text);
if (this.tbcz7.Text == "")
{
this.tbcz7.Text = "0";
}
else if (result3 != true)
{
//rg.ShowDialog();
this.tbname7.Text = "";
return;
}
else
{
var yh3 = yhbll.GetModel(this.tbcz7.Text);
this.tbname7.Text = yh3.姓名;
bhd.PT_czyname3 = this.tbname7.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage6)
{
#region 测试
bhd.CS_czy3 = this.tbcz13.Text;
bool result3;
result3 = yhbll.Exist(this.tbcz13.Text);
if (this.tbcz13.Text == "")
{
this.tbcz13.Text = "0";
}
else if (result3 != true)
{
//rg.ShowDialog();
this.tbname13.Text = "";
return;
}
else
{
var yh3 = yhbll.GetModel(this.tbcz13.Text);
this.tbname13.Text = yh3.姓名;
bhd.CS_czyname3 = this.tbname13.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage7)
{
#region 清洗
bhd.QX_czy3 = this.tbcz17.Text;
bool result3;
result3 = yhbll.Exist(this.tbcz17.Text);
if (this.tbcz17.Text == "")
{
this.tbcz17.Text = "0";
}
else if (result3 != true)
{
//rg.ShowDialog();
this.tbname17.Text = "";
return;
}
else
{
var yh3 = yhbll.GetModel(this.tbcz17.Text);
this.tbname17.Text = yh3.姓名;
bhd.QX_czyname3 = this.tbname17.Text;
}
#endregion
}
else if (this.tabControl1.SelectedTab == tabPage8)
{
#region 包装
bhd.BZ_czy2 = this.tbcz21.Text;
bool result2;
result2 = yhbll.Exist(this.tbcz21.Text);
if (this.tbcz21.Text == "")
{
this.tbcz21.Text = "0";
}
else if (result2 != true)
{
//rg.ShowDialog();
this.tbname21.Text = "";
return;
}
else
{
var yh2 = yhbll.GetModel(this.tbcz21.Text);
this.tbname21.Text = yh2.姓名;
bhd.BZ_czyname2 = this.tbname21.Text;
}
#endregion
}
//}
//if (yh.工序名称 == "备料")
//{
// #region 备料
// bhd.bl_czy3 = this.tbczy3.Text;
// bool result3;
// result3 = yhbll.Exist(this.tbczy3.Text);
// if (this.tbczy3.Text == "")
// {
// this.tbczy3.Text = "0";
// }
// else if (result3 != true)
// {
// rg.ShowDialog();
// this.tbczName3.Text = "";
// return;
// }
// else
// {
// var yh3 = yhbll.GetModel(this.tbczy3.Text);
// this.tbczName3.Text = yh3.姓名;
// bhd.bl_czyname3 = this.tbczName3.Text;
// }
// #endregion
//}
//else if (yh.工序名称 == "LD耦合焊接")
//{
// #region LD耦合焊接
// bhd.LD_czy3 = this.tbcz3.Text;
// bool result3;
// result3 = yhbll.Exist(this.tbcz3.Text);
// if (this.tbcz3.Text == "")
// {
// this.tbcz3.Text = "0";
// }
// else if (result3 != true)
// {
// rg.ShowDialog();
// this.tbname3.Text = "";
// return;
// }
// else
// {
// var yh3 = yhbll.GetModel(this.tbcz3.Text);
// this.tbname3.Text = yh3.姓名;
// bhd.LD_czyname3 = this.tbname3.Text;
// }
// #endregion
//}
//else if (yh.工序名称 == "PT耦合固化")
//{
// #region PT耦合固化
// bhd.PT_czy3 = this.tbcz7.Text;
// bool result3;
// result3 = yhbll.Exist(this.tbcz7.Text);
// if (this.tbcz7.Text == "")
// {
// this.tbcz7.Text = "0";
// }
// else if (result3 != true)
// {
// rg.ShowDialog();
// this.tbname7.Text = "";
// return;
// }
// else
// {
// var yh3 = yhbll.GetModel(this.tbcz7.Text);
// this.tbname7.Text = yh3.姓名;
// bhd.PT_czyname3 = this.tbname7.Text;
// }
// #endregion
//}
//else if (yh.工序名称 == "测试")
//{
// #region 测试
// bhd.CS_czy3 = this.tbcz13.Text;
// bool result3;
// result3 = yhbll.Exist(this.tbcz13.Text);
// if (this.tbcz13.Text == "")
// {
// this.tbcz13.Text = "0";
// }
// else if (result3 != true)
// {
// rg.ShowDialog();
// this.tbname13.Text = "";
// return;
// }
// else
// {
// var yh3 = yhbll.GetModel(this.tbcz13.Text);
// this.tbname13.Text = yh3.姓名;
// bhd.CS_czyname3 = this.tbname13.Text;
// }
// #endregion
//}
//else if (yh.工序名称 == "清洗")
//{
// #region 清洗
// bhd.QX_czy3 = this.tbcz17.Text;
// bool result3;
// result3 = yhbll.Exist(this.tbcz17.Text);
// if (this.tbcz17.Text == "")
// {
// this.tbcz17.Text = "0";
// }
// else if (result3 != true)
// {
// rg.ShowDialog();
// this.tbname17.Text = "";
// return;
// }
// else
// {
// var yh3 = yhbll.GetModel(this.tbcz17.Text);
// this.tbname17.Text = yh3.姓名;
// bhd.QX_czyname3 = this.tbname17.Text;
// }
// #endregion
//}
//else if (yh.工序名称 == "包装")
//{
// #region 包装
// bhd.BZ_czy3 = this.tbcz21.Text;
// bool result3;
// result3 = yhbll.Exist(this.tbcz21.Text);
// if (this.tbcz21.Text == "")
// {
// this.tbcz21.Text = "0";
// }
// else if (result3 != true)
// {
// rg.ShowDialog();
// this.tbname21.Text = "";
// return;
// }
// else
// {
// var yh3 = yhbll.GetModel(this.tbcz21.Text);
// this.tbname21.Text = yh3.姓名;
// bhd.BZ_czyname3 = this.tbname21.Text;
// }
// #endregion
//}
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="bhd"></param>
/// <returns></returns>
public bool Update(tsuhan_sg_tx bhd)
{
return dal.Update(bhd);
}
/// <summary>
/// 温循后
/// </summary>
/// <param name="bhd"></param>
private void WenXunHouBind(tsuhan_sg_tx bhd)
{
#region 温循后
bhd.WXH_sbbh = this.tb10.Text;
if (this.tbqcsl1.Text == "")
{
this.tbqcsl1.Text = "0";
}
bhd.WXH_qcsl = Convert.ToInt32(this.tbqcsl1.Text);
if (this.tbxcsl3.Text == "")
{
this.tbxcsl3.Text = "0";
}
bhd.WXH_xcsl = Convert.ToInt32(this.tbxcsl3.Text);
if (this.dtpqcTime1.Text == "")
{
this.dtpqcTime1.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
}
bhd.WXH_xctime = Convert.ToDateTime(this.dtpqcTime1.Text);
bhd.WXH_wxsc = this.tbwxsc.Text;
bhd.WXH_czy = this.tbcz10.Text;
bhd.WXH_czyname = this.tbname10.Text;
bhd.WX_Hlry = this.tblr4.Text;
bhd.WXH_lryname = this.tblrname4.Text;
bhd.WXH_remark = this.rtbremark3.Text;
#endregion
}
/// <summary>
/// PT耦合固化
/// </summary>
/// <param name="bhd"></param>
private void PTGuHuaBind(tsuhan_sg_tx bhd)
{
#region PT耦合固化
bhd.PT_sbbh1 = this.tb5.Text;
bhd.PT_sbbh2 = this.tb6.Text;
bhd.PT_sbbh3 = this.tb7.Text;
bhd.PT_sbbh4 = this.tb8.Text;
if (this.tbsjsl2.Text == "")
{
this.tbsjsl2.Text = "0";
}
bhd.PT_sjsl = Convert.ToInt32(this.tbsjsl2.Text);
if (this.tbxcsl2.Text == "")
{
this.tbxcsl2.Text = "0";
}
bhd.PT_xcsl = Convert.ToInt32(this.tbxcsl2.Text);
if (this.dtptime2.Text == "")
{
this.dtptime2.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
bhd.PT_xctime = Convert.ToDateTime(this.dtptime2.Text);
bhd.PT_czy1 = this.tbcz5.Text;
bhd.PT_czy2 = this.tbcz6.Text;
bhd.PT_czy3 = this.tbcz7.Text;
bhd.PT_czy4 = this.tbcz8.Text;
bhd.PT_czyname1 = this.tbname5.Text;
bhd.PT_czyname2 = this.tbname6.Text;
bhd.PT_czyname3 = this.tbname7.Text;
bhd.PT_czyname4 = this.tbname8.Text;
bhd.PT_lry = this.tblr2.Text;
bhd.PT_lryname = this.tblrname2.Text;
if (this.tbyy21.Text == "")
{
this.tbyy21.Text = "0";
}
bhd.ptng1 = Convert.ToInt32(this.tbyy21.Text);
if (this.tbyy22.Text == "")
{
this.tbyy22.Text = "0";
}
bhd.ptng2 = Convert.ToInt32(this.tbyy22.Text);
if (this.tbyy23.Text == "")
{
this.tbyy23.Text = "0";
}
bhd.ptng3 = Convert.ToInt32(this.tbyy23.Text);
if (this.tbyy24.Text == "")
{
this.tbyy24.Text = "0";
}
bhd.ptng4 = Convert.ToInt32(this.tbyy24.Text);
if (this.tbyy25.Text == "")
{
this.tbyy25.Text = "0";
}
bhd.ptng5 = Convert.ToInt32(this.tbyy25.Text);
if (this.tbyy26.Text == "")
{
this.tbyy26.Text = "0";
}
bhd.ptng6 = Convert.ToInt32(this.tbyy26.Text);
if (this.tbyy27.Text == "")
{
this.tbyy27.Text = "0";
}
bhd.ptng7 = Convert.ToInt32(this.tbyy27.Text);
if (this.tbyy28.Text == "")
{
this.tbyy28.Text = "0";
}
bhd.ptng8 = Convert.ToInt32(this.tbyy28.Text);
if (this.tbyy29.Text == "")
{
this.tbyy29.Text = "0";
}
bhd.ptng9 = Convert.ToInt32(this.tbyy29.Text);
bhd.ptngoth = this.tbyy30.Text;
if (this.tbyy30sl.Text == "")
{
this.tbyy30sl.Text = "0";
}
bhd.ptngothnum = Convert.ToInt32(this.tbyy30sl.Text);
if (this.textBox100.Text == "")
{
this.textBox100.Text = "0";
}
bhd.PT_bhgallsl = Convert.ToInt32(this.textBox100.Text);
#endregion
}
/// <summary>
/// 温循前
/// </summary>
/// <param name="bhd"></param>
private void WenXunQianBind(tsuhan_sg_tx bhd)
{
#region 温循前
bhd.WXQ_sbbh = this.tb9.Text;
if (this.tbsjsl3.Text == "")
{
this.tbsjsl3.Text = "0";
}
bhd.WXQ_sjsl = Convert.ToInt32(this.tbsjsl3.Text);
if (this.tbfrsl1.Text == "")
{
this.tbfrsl1.Text = "0";
}
bhd.WXQ_frsl = Convert.ToInt32(this.tbfrsl1.Text);
if (this.dtpfrtime1.Text == "" || this.dtpfrtime1.Text == string.Empty)
{
this.dtpfrtime1.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
}
bhd.WXQ_xctime = Convert.ToDateTime(this.dtpfrtime1.Text);
bhd.WXQ_czy = this.tbcz9.Text;
bhd.WXQ_czyname = this.tbname9.Text;
bhd.WXQ_lry = this.tblr3.Text;
bhd.WXQ_lryname = this.tblrname3.Text;
bhd.WXQ_remark = this.rtbremark2.Text;
#endregion
}
/// <summary>
/// 清洗
/// </summary>
/// <param name="bhd"></param>
private void QingXiBind(tsuhan_sg_tx bhd)
{
#region 清洗
bhd.QX_sbbh1 = this.tb15.Text;
bhd.QX_sbbh2 = this.tb16.Text;
bhd.QX_sbbh3 = this.tb17.Text;
bhd.QX_sbbh4 = this.tb18.Text;
if (this.tbsjsl5.Text == "")
{
this.tbsjsl5.Text = "0";
}
bhd.QX_sjsl = Convert.ToInt32(this.tbsjsl5.Text);
if (this.tbxcsl5.Text == "")
{
this.tbxcsl5.Text = "0";
}
bhd.QX_xcsl = Convert.ToInt32(this.tbxcsl5.Text);
if (this.dtpxctime3.Text == "")
{
this.dtpxctime3.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
bhd.QX_xctime = Convert.ToDateTime(this.dtpxctime3.Text);
bhd.QX_czy1 = this.tbcz15.Text;
bhd.QX_czy2 = this.tbcz16.Text;
bhd.QX_czy3 = this.tbcz17.Text;
bhd.QX_czy4 = this.tbcz18.Text;
bhd.QX_czyname1 = this.tbname15.Text;
bhd.QX_czyname2 = this.tbname16.Text;
bhd.QX_czyname3 = this.tbname17.Text;
bhd.QX_czyname4 = this.tbname18.Text;
bhd.QX_lry = this.tblr6.Text;
bhd.QX_lryname = this.tblrname6.Text;
if (this.tbyy40.Text == "")
{
this.tbyy40.Text = "0";
}
bhd.qxng1 = Convert.ToInt32(this.tbyy40.Text);
bhd.qxngoth = this.rtbyy41.Text;
if (this.tbyy41sl.Text == "")
{
this.tbyy41sl.Text = "0";
}
bhd.qxngothnum = Convert.ToInt32(this.tbyy41sl.Text);
if (this.tbbhgsl3.Text == "")
{
this.tbbhgsl3.Text = "0";
}
bhd.QX_bhgallsl = Convert.ToInt32(this.tbbhgsl3.Text);
#endregion
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="bhd"></param>
/// <returns></returns>
public bool Update(tsuhan_sg_tx bhd)
{
return(dal.Update(bhd));
}
/// <summary>
/// 新增随工单
/// </summary>
/// <param name="bhd"></param>
/// <returns></returns>
public bool Add(tsuhan_sg_tx model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tsuhan_sg_tx(");
strSql.Append("随工单号,备料,bl_sbbh1,bl_sbbh2,bl_sbbh3,bl_sbbh4,bl_xcsl,bl_xctime,bl_czy1,bl_czy2,bl_czy3,bl_czy4,bl_czyname1,bl_czyname2,bl_czyname3,bl_czyname4,bl_lry,bl_lryname,bl_bhgallsl,blng1,blng2,blng3,blng4,blng5,blng6,blng7,blng8,blng9,blngoth,blngothnum,LD焊接,LD_sbbh1,LD_sbbh2,LD_sbbh3,LD_sbbh4,LD_sjsl,LD_xcsl,LD_xctime,LD_czy1,LD_czy2,LD_czy3,LD_czy4,LD_czyname1,LD_czyname2,LD_czyname3,LD_czyname4,LD_lry,LD_lryname,LD_bhgallsl,LD_jzsl,ldng1,ldng2,ldng3,ldng4,ldng5,ldng6,ldng7,ldng8,ldng9,ldngoth,ldngothnum,PT耦合固化,PT_sbbh1,PT_sbbh2,PT_sbbh3,PT_sbbh4,PT_sjsl,PT_xcsl,PT_xctime,PT_czy1,PT_czy2,PT_czy3,PT_czy4,PT_czyname1,PT_czyname2,PT_czyname3,PT_czyname4,PT_lry,PT_lryname,PT_bhgallsl,PT_bhgyy,ptng1,ptng2,ptng3,ptng4,ptng5,ptng6,ptng7,ptng8,ptng9,ptngoth,ptngothnum,温循前,WXQ_sbbh,WXQ_sjsl,WXQ_frsl,WXQ_xctime,WXQ_czy,WXQ_czyname,WXQ_lry,WXQ_lryname,WXQ_remark,温循后,WXH_sbbh,WXH_qcsl,WXH_xcsl,WXH_wxsc,WXH_xctime,WXH_czy,WXH_czyname,WX_Hlry,WXH_lryname,WXH_remark,测试,CS_sbbh1,CS_sbbh2,CS_sbbh3,CS_sbbh4,CS_sjsl,CS_xcsl,CS_xctime,CS_czy1,CS_czy2,CS_czy3,CS_czy4,CS_czyname1,CS_czyname2,CS_czyname3,CS_czyname4,CS_lry,CS_lryname,CS_bhgallsl,csng1,csng2,csng3,csng4,csng5,csng6,csng7,csng8,csng9,csngoth,csngothnum,清洗,QX_sbbh1,QX_sbbh2,QX_sbbh3,QX_sbbh4,QX_sjsl,QX_xcsl,QX_xctime,QX_czy1,QX_czy2,QX_czy3,QX_czy4,QX_czyname1,QX_czyname2,QX_czyname3,QX_czyname4,QX_lry,QX_lryname,QX_bhgallsl,qxng1,qxngoth,qxngothnum,包装,BZ_sbbh1,BZ_sbbh2,BZ_sbbh3,BZ_sbbh4,BZ_sjsl,BZ_xcsl,BZ_xctime,BZ_czy1,BZ_czy2,BZ_czy3,BZ_czy4,BZ_czyname1,BZ_czyname2,BZ_czyname3,BZ_czyname4,BZ_lry,BZ_lryname,BZ_bhgallsl,bzng1,bzngoth,bzngothnum,gcsj_liushuih,lsh1,lsh2,lsh3,gcsj_CASE,case1,case2,case3,gcsj_LDjia,ld1,ld2,ld3,gcsj_PDjia,pd1,pd2,pd3,gcsj_LDjian,ldj1,ldj2,ldj3,gcsj_jicha,jc1,jc2,jc3,gcsj_yatou,yt1,yt2,yt3,gcsj_oxianliang,oxl1,oxl2,oxl3,ldxp_xinpianjj,ldxp_jianyanry,ldxp_jianyansb,bggSum,备注,LD_lx,LD_xh,LD_name,LD_sjdh,LD_remark,PT_lx,PT_xh,PT_name,PT_sjdh,PT_remark,KT_lx,KT_xh,KT_name,KT_sjdh,KT_remark,NBP_lx0,NBP_xh0,NBP_name0,NBP_sjdh0,NBP_remark0,NBP_lx45,NBP_xh45,NBP_name45,NBP_sjdh45,NBP_remark45,JK_lx,JK_xh,JK_name,JK_sjdh,JK_remark)");
strSql.Append(" values (");
strSql.Append("@随工单号,@备料,@bl_sbbh1,@bl_sbbh2,@bl_sbbh3,@bl_sbbh4,@bl_xcsl,@bl_xctime,@bl_czy1,@bl_czy2,@bl_czy3,@bl_czy4,@bl_czyname1,@bl_czyname2,@bl_czyname3,@bl_czyname4,@bl_lry,@bl_lryname,@bl_bhgallsl,@blng1,@blng2,@blng3,@blng4,@blng5,@blng6,@blng7,@blng8,@blng9,@blngoth,@blngothnum,@LD焊接,@LD_sbbh1,@LD_sbbh2,@LD_sbbh3,@LD_sbbh4,@LD_sjsl,@LD_xcsl,@LD_xctime,@LD_czy1,@LD_czy2,@LD_czy3,@LD_czy4,@LD_czyname1,@LD_czyname2,@LD_czyname3,@LD_czyname4,@LD_lry,@LD_lryname,@LD_bhgallsl,@LD_jzsl,@ldng1,@ldng2,@ldng3,@ldng4,@ldng5,@ldng6,@ldng7,@ldng8,@ldng9,@ldngoth,@ldngothnum,@PT耦合固化,@PT_sbbh1,@PT_sbbh2,@PT_sbbh3,@PT_sbbh4,@PT_sjsl,@PT_xcsl,@PT_xctime,@PT_czy1,@PT_czy2,@PT_czy3,@PT_czy4,@PT_czyname1,@PT_czyname2,@PT_czyname3,@PT_czyname4,@PT_lry,@PT_lryname,@PT_bhgallsl,@PT_bhgyy,@ptng1,@ptng2,@ptng3,@ptng4,@ptng5,@ptng6,@ptng7,@ptng8,@ptng9,@ptngoth,@ptngothnum,@温循前,@WXQ_sbbh,@WXQ_sjsl,@WXQ_frsl,@WXQ_xctime,@WXQ_czy,@WXQ_czyname,@WXQ_lry,@WXQ_lryname,@WXQ_remark,@温循后,@WXH_sbbh,@WXH_qcsl,@WXH_xcsl,@WXH_wxsc,@WXH_xctime,@WXH_czy,@WXH_czyname,@WX_Hlry,@WXH_lryname,@WXH_remark,@测试,@CS_sbbh1,@CS_sbbh2,@CS_sbbh3,@CS_sbbh4,@CS_sjsl,@CS_xcsl,@CS_xctime,@CS_czy1,@CS_czy2,@CS_czy3,@CS_czy4,@CS_czyname1,@CS_czyname2,@CS_czyname3,@CS_czyname4,@CS_lry,@CS_lryname,@CS_bhgallsl,@csng1,@csng2,@csng3,@csng4,@csng5,@csng6,@csng7,@csng8,@csng9,@csngoth,@csngothnum,@清洗,@QX_sbbh1,@QX_sbbh2,@QX_sbbh3,@QX_sbbh4,@QX_sjsl,@QX_xcsl,@QX_xctime,@QX_czy1,@QX_czy2,@QX_czy3,@QX_czy4,@QX_czyname1,@QX_czyname2,@QX_czyname3,@QX_czyname4,@QX_lry,@QX_lryname,@QX_bhgallsl,@qxng1,@qxngoth,@qxngothnum,@包装,@BZ_sbbh1,@BZ_sbbh2,@BZ_sbbh3,@BZ_sbbh4,@BZ_sjsl,@BZ_xcsl,@BZ_xctime,@BZ_czy1,@BZ_czy2,@BZ_czy3,@BZ_czy4,@BZ_czyname1,@BZ_czyname2,@BZ_czyname3,@BZ_czyname4,@BZ_lry,@BZ_lryname,@BZ_bhgallsl,@bzng1,@bzngoth,@bzngothnum,@gcsj_liushuih,@lsh1,@lsh2,@lsh3,@gcsj_CASE,@case1,@case2,@case3,@gcsj_LDjia,@ld1,@ld2,@ld3,@gcsj_PDjia,@pd1,@pd2,@pd3,@gcsj_LDjian,@ldj1,@ldj2,@ldj3,@gcsj_jicha,@jc1,@jc2,@jc3,@gcsj_yatou,@yt1,@yt2,@yt3,@gcsj_oxianliang,@oxl1,@oxl2,@oxl3,@ldxp_xinpianjj,@ldxp_jianyanry,@ldxp_jianyansb,@bggSum,@备注,@LD_lx,@LD_xh,@LD_name,@LD_sjdh,@LD_remark,@PT_lx,@PT_xh,@PT_name,@PT_sjdh,@PT_remark,@KT_lx,@KT_xh,@KT_name,@KT_sjdh,@KT_remark,@NBP_lx0,@NBP_xh0,@NBP_name0,@NBP_sjdh0,@NBP_remark0,@NBP_lx45,@NBP_xh45,@NBP_name45,@NBP_sjdh45,@NBP_remark45,@JK_lx,@JK_xh,@JK_name,@JK_sjdh,@JK_remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@随工单号", SqlDbType.NVarChar,20),
new SqlParameter("@备料", SqlDbType.NVarChar,10),
new SqlParameter("@bl_sbbh1", SqlDbType.NVarChar,10),
new SqlParameter("@bl_sbbh2", SqlDbType.NVarChar,10),
new SqlParameter("@bl_sbbh3", SqlDbType.NVarChar,10),
new SqlParameter("@bl_sbbh4", SqlDbType.NVarChar,10),
new SqlParameter("@bl_xcsl", SqlDbType.Int,4),
new SqlParameter("@bl_xctime", SqlDbType.DateTime),
new SqlParameter("@bl_czy1", SqlDbType.NVarChar,10),
new SqlParameter("@bl_czy2", SqlDbType.NVarChar,10),
new SqlParameter("@bl_czy3", SqlDbType.NVarChar,10),
new SqlParameter("@bl_czy4", SqlDbType.NVarChar,10),
new SqlParameter("@bl_czyname1", SqlDbType.NVarChar,20),
new SqlParameter("@bl_czyname2", SqlDbType.NVarChar,20),
new SqlParameter("@bl_czyname3", SqlDbType.NVarChar,20),
new SqlParameter("@bl_czyname4", SqlDbType.NVarChar,20),
new SqlParameter("@bl_lry", SqlDbType.NVarChar,10),
new SqlParameter("@bl_lryname", SqlDbType.NVarChar,20),
new SqlParameter("@bl_bhgallsl", SqlDbType.Int,4),
new SqlParameter("@blng1", SqlDbType.Int,4),
new SqlParameter("@blng2", SqlDbType.Int,4),
new SqlParameter("@blng3", SqlDbType.Int,4),
new SqlParameter("@blng4", SqlDbType.Int,4),
new SqlParameter("@blng5", SqlDbType.Int,4),
new SqlParameter("@blng6", SqlDbType.Int,4),
new SqlParameter("@blng7", SqlDbType.Int,4),
new SqlParameter("@blng8", SqlDbType.Int,4),
new SqlParameter("@blng9", SqlDbType.Int,4),
new SqlParameter("@blngoth", SqlDbType.VarChar,50),
new SqlParameter("@blngothnum", SqlDbType.Int,4),
new SqlParameter("@LD焊接", SqlDbType.NVarChar,10),
new SqlParameter("@LD_sbbh1", SqlDbType.NVarChar,10),
new SqlParameter("@LD_sbbh2", SqlDbType.NVarChar,10),
new SqlParameter("@LD_sbbh3", SqlDbType.NVarChar,10),
new SqlParameter("@LD_sbbh4", SqlDbType.NVarChar,10),
new SqlParameter("@LD_sjsl", SqlDbType.Int,4),
new SqlParameter("@LD_xcsl", SqlDbType.Int,4),
new SqlParameter("@LD_xctime", SqlDbType.DateTime),
new SqlParameter("@LD_czy1", SqlDbType.NVarChar,10),
new SqlParameter("@LD_czy2", SqlDbType.NVarChar,10),
new SqlParameter("@LD_czy3", SqlDbType.NVarChar,10),
new SqlParameter("@LD_czy4", SqlDbType.NVarChar,10),
new SqlParameter("@LD_czyname1", SqlDbType.NVarChar,20),
new SqlParameter("@LD_czyname2", SqlDbType.NVarChar,20),
new SqlParameter("@LD_czyname3", SqlDbType.NVarChar,20),
new SqlParameter("@LD_czyname4", SqlDbType.NVarChar,20),
new SqlParameter("@LD_lry", SqlDbType.NVarChar,10),
new SqlParameter("@LD_lryname", SqlDbType.NVarChar,20),
new SqlParameter("@LD_bhgallsl", SqlDbType.Int,4),
new SqlParameter("@LD_jzsl", SqlDbType.Int,4),
new SqlParameter("@ldng1", SqlDbType.Int,4),
new SqlParameter("@ldng2", SqlDbType.Int,4),
new SqlParameter("@ldng3", SqlDbType.Int,4),
new SqlParameter("@ldng4", SqlDbType.Int,4),
new SqlParameter("@ldng5", SqlDbType.Int,4),
new SqlParameter("@ldng6", SqlDbType.Int,4),
new SqlParameter("@ldng7", SqlDbType.Int,4),
new SqlParameter("@ldng8", SqlDbType.Int,4),
new SqlParameter("@ldng9", SqlDbType.Int,4),
new SqlParameter("@ldngoth", SqlDbType.VarChar,30),
new SqlParameter("@ldngothnum", SqlDbType.Int,4),
new SqlParameter("@PT耦合固化", SqlDbType.NVarChar,10),
new SqlParameter("@PT_sbbh1", SqlDbType.NVarChar,10),
new SqlParameter("@PT_sbbh2", SqlDbType.NVarChar,10),
new SqlParameter("@PT_sbbh3", SqlDbType.NVarChar,10),
new SqlParameter("@PT_sbbh4", SqlDbType.NVarChar,10),
new SqlParameter("@PT_sjsl", SqlDbType.Int,4),
new SqlParameter("@PT_xcsl", SqlDbType.Int,4),
new SqlParameter("@PT_xctime", SqlDbType.DateTime),
new SqlParameter("@PT_czy1", SqlDbType.NVarChar,10),
new SqlParameter("@PT_czy2", SqlDbType.NVarChar,10),
new SqlParameter("@PT_czy3", SqlDbType.NVarChar,10),
new SqlParameter("@PT_czy4", SqlDbType.NVarChar,10),
new SqlParameter("@PT_czyname1", SqlDbType.NVarChar,20),
new SqlParameter("@PT_czyname2", SqlDbType.NVarChar,20),
new SqlParameter("@PT_czyname3", SqlDbType.NVarChar,20),
new SqlParameter("@PT_czyname4", SqlDbType.NVarChar,20),
new SqlParameter("@PT_lry", SqlDbType.NVarChar,10),
new SqlParameter("@PT_lryname", SqlDbType.NVarChar,20),
new SqlParameter("@PT_bhgallsl", SqlDbType.Int,4),
new SqlParameter("@PT_bhgyy", SqlDbType.NVarChar,200),
new SqlParameter("@ptng1", SqlDbType.Int,4),
new SqlParameter("@ptng2", SqlDbType.Int,4),
new SqlParameter("@ptng3", SqlDbType.Int,4),
new SqlParameter("@ptng4", SqlDbType.Int,4),
new SqlParameter("@ptng5", SqlDbType.Int,4),
new SqlParameter("@ptng6", SqlDbType.Int,4),
new SqlParameter("@ptng7", SqlDbType.Int,4),
new SqlParameter("@ptng8", SqlDbType.Int,4),
new SqlParameter("@ptng9", SqlDbType.Int,4),
new SqlParameter("@ptngoth", SqlDbType.VarChar,30),
new SqlParameter("@ptngothnum", SqlDbType.Int,4),
new SqlParameter("@温循前", SqlDbType.NVarChar,10),
new SqlParameter("@WXQ_sbbh", SqlDbType.NVarChar,10),
new SqlParameter("@WXQ_sjsl", SqlDbType.Int,4),
new SqlParameter("@WXQ_frsl", SqlDbType.Int,4),
new SqlParameter("@WXQ_xctime", SqlDbType.DateTime),
new SqlParameter("@WXQ_czy", SqlDbType.NVarChar,10),
new SqlParameter("@WXQ_czyname", SqlDbType.NVarChar,20),
new SqlParameter("@WXQ_lry", SqlDbType.NVarChar,10),
new SqlParameter("@WXQ_lryname", SqlDbType.NVarChar,20),
new SqlParameter("@WXQ_remark", SqlDbType.NVarChar,50),
new SqlParameter("@温循后", SqlDbType.NVarChar,10),
new SqlParameter("@WXH_sbbh", SqlDbType.NVarChar,10),
new SqlParameter("@WXH_qcsl", SqlDbType.Int,4),
new SqlParameter("@WXH_xcsl", SqlDbType.Int,4),
new SqlParameter("@WXH_wxsc", SqlDbType.NVarChar,10),
new SqlParameter("@WXH_xctime", SqlDbType.DateTime),
new SqlParameter("@WXH_czy", SqlDbType.NVarChar,10),
new SqlParameter("@WXH_czyname", SqlDbType.NVarChar,20),
new SqlParameter("@WX_Hlry", SqlDbType.NVarChar,10),
new SqlParameter("@WXH_lryname", SqlDbType.NVarChar,20),
new SqlParameter("@WXH_remark", SqlDbType.NVarChar,50),
new SqlParameter("@测试", SqlDbType.NVarChar,10),
new SqlParameter("@CS_sbbh1", SqlDbType.NVarChar,10),
new SqlParameter("@CS_sbbh2", SqlDbType.NVarChar,10),
new SqlParameter("@CS_sbbh3", SqlDbType.NVarChar,10),
new SqlParameter("@CS_sbbh4", SqlDbType.NVarChar,10),
new SqlParameter("@CS_sjsl", SqlDbType.Int,4),
new SqlParameter("@CS_xcsl", SqlDbType.Int,4),
new SqlParameter("@CS_xctime", SqlDbType.DateTime),
new SqlParameter("@CS_czy1", SqlDbType.NVarChar,10),
new SqlParameter("@CS_czy2", SqlDbType.NVarChar,10),
new SqlParameter("@CS_czy3", SqlDbType.NVarChar,10),
new SqlParameter("@CS_czy4", SqlDbType.NVarChar,10),
new SqlParameter("@CS_czyname1", SqlDbType.NVarChar,20),
new SqlParameter("@CS_czyname2", SqlDbType.NVarChar,20),
new SqlParameter("@CS_czyname3", SqlDbType.NVarChar,20),
new SqlParameter("@CS_czyname4", SqlDbType.NVarChar,20),
new SqlParameter("@CS_lry", SqlDbType.NVarChar,10),
new SqlParameter("@CS_lryname", SqlDbType.NVarChar,20),
new SqlParameter("@CS_bhgallsl", SqlDbType.Int,4),
new SqlParameter("@csng1", SqlDbType.Int,4),
new SqlParameter("@csng2", SqlDbType.Int,4),
new SqlParameter("@csng3", SqlDbType.Int,4),
new SqlParameter("@csng4", SqlDbType.Int,4),
new SqlParameter("@csng5", SqlDbType.Int,4),
new SqlParameter("@csng6", SqlDbType.Int,4),
new SqlParameter("@csng7", SqlDbType.Int,4),
new SqlParameter("@csng8", SqlDbType.Int,4),
new SqlParameter("@csng9", SqlDbType.Int,4),
new SqlParameter("@csngoth", SqlDbType.VarChar,30),
new SqlParameter("@csngothnum", SqlDbType.Int,4),
new SqlParameter("@清洗", SqlDbType.NVarChar,10),
new SqlParameter("@QX_sbbh1", SqlDbType.NVarChar,10),
new SqlParameter("@QX_sbbh2", SqlDbType.NVarChar,10),
new SqlParameter("@QX_sbbh3", SqlDbType.NVarChar,10),
new SqlParameter("@QX_sbbh4", SqlDbType.NVarChar,10),
new SqlParameter("@QX_sjsl", SqlDbType.Int,4),
new SqlParameter("@QX_xcsl", SqlDbType.Int,4),
new SqlParameter("@QX_xctime", SqlDbType.DateTime),
new SqlParameter("@QX_czy1", SqlDbType.NVarChar,10),
new SqlParameter("@QX_czy2", SqlDbType.NVarChar,10),
new SqlParameter("@QX_czy3", SqlDbType.NVarChar,10),
new SqlParameter("@QX_czy4", SqlDbType.NVarChar,10),
new SqlParameter("@QX_czyname1", SqlDbType.NVarChar,20),
new SqlParameter("@QX_czyname2", SqlDbType.NVarChar,20),
new SqlParameter("@QX_czyname3", SqlDbType.NVarChar,20),
new SqlParameter("@QX_czyname4", SqlDbType.NVarChar,20),
new SqlParameter("@QX_lry", SqlDbType.NVarChar,10),
new SqlParameter("@QX_lryname", SqlDbType.NVarChar,20),
new SqlParameter("@QX_bhgallsl", SqlDbType.Int,4),
new SqlParameter("@qxng1", SqlDbType.Int,4),
new SqlParameter("@qxngoth", SqlDbType.VarChar,30),
new SqlParameter("@qxngothnum", SqlDbType.Int,4),
new SqlParameter("@包装", SqlDbType.NVarChar,10),
new SqlParameter("@BZ_sbbh1", SqlDbType.NVarChar,10),
new SqlParameter("@BZ_sbbh2", SqlDbType.NVarChar,10),
new SqlParameter("@BZ_sbbh3", SqlDbType.NVarChar,10),
new SqlParameter("@BZ_sbbh4", SqlDbType.NVarChar,10),
new SqlParameter("@BZ_sjsl", SqlDbType.Int,4),
new SqlParameter("@BZ_xcsl", SqlDbType.Int,4),
new SqlParameter("@BZ_xctime", SqlDbType.DateTime),
new SqlParameter("@BZ_czy1", SqlDbType.NVarChar,10),
new SqlParameter("@BZ_czy2", SqlDbType.NVarChar,10),
new SqlParameter("@BZ_czy3", SqlDbType.NVarChar,10),
new SqlParameter("@BZ_czy4", SqlDbType.NVarChar,10),
new SqlParameter("@BZ_czyname1", SqlDbType.NVarChar,20),
new SqlParameter("@BZ_czyname2", SqlDbType.NVarChar,20),
new SqlParameter("@BZ_czyname3", SqlDbType.NVarChar,20),
new SqlParameter("@BZ_czyname4", SqlDbType.NVarChar,20),
new SqlParameter("@BZ_lry", SqlDbType.NVarChar,10),
new SqlParameter("@BZ_lryname", SqlDbType.NVarChar,20),
new SqlParameter("@BZ_bhgallsl", SqlDbType.Int,4),
new SqlParameter("@bzng1", SqlDbType.Int,4),
new SqlParameter("@bzngoth", SqlDbType.VarChar,30),
new SqlParameter("@bzngothnum", SqlDbType.Int,4),
new SqlParameter("@gcsj_liushuih", SqlDbType.NVarChar,10),
new SqlParameter("@lsh1", SqlDbType.NVarChar,20),
new SqlParameter("@lsh2", SqlDbType.NVarChar,20),
new SqlParameter("@lsh3", SqlDbType.NVarChar,20),
new SqlParameter("@gcsj_CASE", SqlDbType.NVarChar,10),
new SqlParameter("@case1", SqlDbType.NVarChar,20),
new SqlParameter("@case2", SqlDbType.NVarChar,20),
new SqlParameter("@case3", SqlDbType.NVarChar,20),
new SqlParameter("@gcsj_LDjia", SqlDbType.NVarChar,10),
new SqlParameter("@ld1", SqlDbType.NVarChar,20),
new SqlParameter("@ld2", SqlDbType.NVarChar,20),
new SqlParameter("@ld3", SqlDbType.NVarChar,20),
new SqlParameter("@gcsj_PDjia", SqlDbType.NVarChar,10),
new SqlParameter("@pd1", SqlDbType.NVarChar,20),
new SqlParameter("@pd2", SqlDbType.NVarChar,20),
new SqlParameter("@pd3", SqlDbType.NVarChar,20),
new SqlParameter("@gcsj_LDjian", SqlDbType.NVarChar,10),
new SqlParameter("@ldj1", SqlDbType.NVarChar,20),
new SqlParameter("@ldj2", SqlDbType.NVarChar,20),
new SqlParameter("@ldj3", SqlDbType.NVarChar,20),
new SqlParameter("@gcsj_jicha", SqlDbType.NVarChar,10),
new SqlParameter("@jc1", SqlDbType.Float,8),
new SqlParameter("@jc2", SqlDbType.Float,8),
new SqlParameter("@jc3", SqlDbType.Float,8),
new SqlParameter("@gcsj_yatou", SqlDbType.NVarChar,10),
new SqlParameter("@yt1", SqlDbType.NVarChar,20),
new SqlParameter("@yt2", SqlDbType.NVarChar,20),
new SqlParameter("@yt3", SqlDbType.NVarChar,20),
new SqlParameter("@gcsj_oxianliang", SqlDbType.NVarChar,10),
new SqlParameter("@oxl1", SqlDbType.NVarChar,20),
new SqlParameter("@oxl2", SqlDbType.NVarChar,20),
new SqlParameter("@oxl3", SqlDbType.NVarChar,20),
new SqlParameter("@ldxp_xinpianjj", SqlDbType.NVarChar,10),
new SqlParameter("@ldxp_jianyanry", SqlDbType.NVarChar,10),
new SqlParameter("@ldxp_jianyansb", SqlDbType.NVarChar,20),
new SqlParameter("@bggSum", SqlDbType.Int,4),
new SqlParameter("@备注", SqlDbType.NVarChar,100),
new SqlParameter("@LD_lx", SqlDbType.NVarChar,30),
new SqlParameter("@LD_xh", SqlDbType.NVarChar,20),
new SqlParameter("@LD_name", SqlDbType.NVarChar,30),
new SqlParameter("@LD_sjdh", SqlDbType.NVarChar,20),
new SqlParameter("@LD_remark", SqlDbType.NVarChar,50),
new SqlParameter("@PT_lx", SqlDbType.NVarChar,30),
new SqlParameter("@PT_xh", SqlDbType.NVarChar,20),
new SqlParameter("@PT_name", SqlDbType.NVarChar,30),
new SqlParameter("@PT_sjdh", SqlDbType.NVarChar,20),
new SqlParameter("@PT_remark", SqlDbType.NVarChar,50),
new SqlParameter("@KT_lx", SqlDbType.NVarChar,30),
new SqlParameter("@KT_xh", SqlDbType.NVarChar,20),
new SqlParameter("@KT_name", SqlDbType.NVarChar,30),
new SqlParameter("@KT_sjdh", SqlDbType.NVarChar,20),
new SqlParameter("@KT_remark", SqlDbType.NVarChar,50),
new SqlParameter("@NBP_lx0", SqlDbType.NVarChar,30),
new SqlParameter("@NBP_xh0", SqlDbType.NVarChar,20),
new SqlParameter("@NBP_name0", SqlDbType.NVarChar,30),
new SqlParameter("@NBP_sjdh0", SqlDbType.NVarChar,20),
new SqlParameter("@NBP_remark0", SqlDbType.NVarChar,50),
new SqlParameter("@NBP_lx45", SqlDbType.NVarChar,30),
new SqlParameter("@NBP_xh45", SqlDbType.NVarChar,20),
new SqlParameter("@NBP_name45", SqlDbType.NVarChar,30),
new SqlParameter("@NBP_sjdh45", SqlDbType.NVarChar,20),
new SqlParameter("@NBP_remark45", SqlDbType.NVarChar,50),
new SqlParameter("@JK_lx", SqlDbType.NVarChar,30),
new SqlParameter("@JK_xh", SqlDbType.NVarChar,20),
new SqlParameter("@JK_name", SqlDbType.NVarChar,30),
new SqlParameter("@JK_sjdh", SqlDbType.NVarChar,20),
new SqlParameter("@JK_remark", SqlDbType.NVarChar,50)};
parameters[0].Value = model.随工单号;
parameters[1].Value = model.备料;
parameters[2].Value = model.bl_sbbh1;
parameters[3].Value = model.bl_sbbh2;
parameters[4].Value = model.bl_sbbh3;
parameters[5].Value = model.bl_sbbh4;
parameters[6].Value = model.bl_xcsl;
parameters[7].Value = model.bl_xctime;
parameters[8].Value = model.bl_czy1;
parameters[9].Value = model.bl_czy2;
parameters[10].Value = model.bl_czy3;
parameters[11].Value = model.bl_czy4;
parameters[12].Value = model.bl_czyname1;
parameters[13].Value = model.bl_czyname2;
parameters[14].Value = model.bl_czyname3;
parameters[15].Value = model.bl_czyname4;
parameters[16].Value = model.bl_lry;
parameters[17].Value = model.bl_lryname;
parameters[18].Value = model.bl_bhgallsl;
parameters[19].Value = model.blng1;
parameters[20].Value = model.blng2;
parameters[21].Value = model.blng3;
parameters[22].Value = model.blng4;
parameters[23].Value = model.blng5;
parameters[24].Value = model.blng6;
parameters[25].Value = model.blng7;
parameters[26].Value = model.blng8;
parameters[27].Value = model.blng9;
parameters[28].Value = model.blngoth;
parameters[29].Value = model.blngothnum;
parameters[30].Value = model.LD焊接;
parameters[31].Value = model.LD_sbbh1;
parameters[32].Value = model.LD_sbbh2;
parameters[33].Value = model.LD_sbbh3;
parameters[34].Value = model.LD_sbbh4;
parameters[35].Value = model.LD_sjsl;
parameters[36].Value = model.LD_xcsl;
parameters[37].Value = model.LD_xctime;
parameters[38].Value = model.LD_czy1;
parameters[39].Value = model.LD_czy2;
parameters[40].Value = model.LD_czy3;
parameters[41].Value = model.LD_czy4;
parameters[42].Value = model.LD_czyname1;
parameters[43].Value = model.LD_czyname2;
parameters[44].Value = model.LD_czyname3;
parameters[45].Value = model.LD_czyname4;
parameters[46].Value = model.LD_lry;
parameters[47].Value = model.LD_lryname;
parameters[48].Value = model.LD_bhgallsl;
parameters[49].Value = model.LD_jzsl;
parameters[50].Value = model.ldng1;
parameters[51].Value = model.ldng2;
parameters[52].Value = model.ldng3;
parameters[53].Value = model.ldng4;
parameters[54].Value = model.ldng5;
parameters[55].Value = model.ldng6;
parameters[56].Value = model.ldng7;
parameters[57].Value = model.ldng8;
parameters[58].Value = model.ldng9;
parameters[59].Value = model.ldngoth;
parameters[60].Value = model.ldngothnum;
parameters[61].Value = model.PT耦合固化;
parameters[62].Value = model.PT_sbbh1;
parameters[63].Value = model.PT_sbbh2;
parameters[64].Value = model.PT_sbbh3;
parameters[65].Value = model.PT_sbbh4;
parameters[66].Value = model.PT_sjsl;
parameters[67].Value = model.PT_xcsl;
parameters[68].Value = model.PT_xctime;
parameters[69].Value = model.PT_czy1;
parameters[70].Value = model.PT_czy2;
parameters[71].Value = model.PT_czy3;
parameters[72].Value = model.PT_czy4;
parameters[73].Value = model.PT_czyname1;
parameters[74].Value = model.PT_czyname2;
parameters[75].Value = model.PT_czyname3;
parameters[76].Value = model.PT_czyname4;
parameters[77].Value = model.PT_lry;
parameters[78].Value = model.PT_lryname;
parameters[79].Value = model.PT_bhgallsl;
parameters[80].Value = model.PT_bhgyy;
parameters[81].Value = model.ptng1;
parameters[82].Value = model.ptng2;
parameters[83].Value = model.ptng3;
parameters[84].Value = model.ptng4;
parameters[85].Value = model.ptng5;
parameters[86].Value = model.ptng6;
parameters[87].Value = model.ptng7;
parameters[88].Value = model.ptng8;
parameters[89].Value = model.ptng9;
parameters[90].Value = model.ptngoth;
parameters[91].Value = model.ptngothnum;
parameters[92].Value = model.温循前;
parameters[93].Value = model.WXQ_sbbh;
parameters[94].Value = model.WXQ_sjsl;
parameters[95].Value = model.WXQ_frsl;
parameters[96].Value = model.WXQ_xctime;
parameters[97].Value = model.WXQ_czy;
parameters[98].Value = model.WXQ_czyname;
parameters[99].Value = model.WXQ_lry;
parameters[100].Value = model.WXQ_lryname;
parameters[101].Value = model.WXQ_remark;
parameters[102].Value = model.温循后;
parameters[103].Value = model.WXH_sbbh;
parameters[104].Value = model.WXH_qcsl;
parameters[105].Value = model.WXH_xcsl;
parameters[106].Value = model.WXH_wxsc;
parameters[107].Value = model.WXH_xctime;
parameters[108].Value = model.WXH_czy;
parameters[109].Value = model.WXH_czyname;
parameters[110].Value = model.WX_Hlry;
parameters[111].Value = model.WXH_lryname;
parameters[112].Value = model.WXH_remark;
parameters[113].Value = model.测试;
parameters[114].Value = model.CS_sbbh1;
parameters[115].Value = model.CS_sbbh2;
parameters[116].Value = model.CS_sbbh3;
parameters[117].Value = model.CS_sbbh4;
parameters[118].Value = model.CS_sjsl;
parameters[119].Value = model.CS_xcsl;
parameters[120].Value = model.CS_xctime;
parameters[121].Value = model.CS_czy1;
parameters[122].Value = model.CS_czy2;
parameters[123].Value = model.CS_czy3;
parameters[124].Value = model.CS_czy4;
parameters[125].Value = model.CS_czyname1;
parameters[126].Value = model.CS_czyname2;
parameters[127].Value = model.CS_czyname3;
parameters[128].Value = model.CS_czyname4;
parameters[129].Value = model.CS_lry;
parameters[130].Value = model.CS_lryname;
parameters[131].Value = model.CS_bhgallsl;
parameters[132].Value = model.csng1;
parameters[133].Value = model.csng2;
parameters[134].Value = model.csng3;
parameters[135].Value = model.csng4;
parameters[136].Value = model.csng5;
parameters[137].Value = model.csng6;
parameters[138].Value = model.csng7;
parameters[139].Value = model.csng8;
parameters[140].Value = model.csng9;
parameters[141].Value = model.csngoth;
parameters[142].Value = model.csngothnum;
parameters[143].Value = model.清洗;
parameters[144].Value = model.QX_sbbh1;
parameters[145].Value = model.QX_sbbh2;
parameters[146].Value = model.QX_sbbh3;
parameters[147].Value = model.QX_sbbh4;
parameters[148].Value = model.QX_sjsl;
parameters[149].Value = model.QX_xcsl;
parameters[150].Value = model.QX_xctime;
parameters[151].Value = model.QX_czy1;
parameters[152].Value = model.QX_czy2;
parameters[153].Value = model.QX_czy3;
parameters[154].Value = model.QX_czy4;
parameters[155].Value = model.QX_czyname1;
parameters[156].Value = model.QX_czyname2;
parameters[157].Value = model.QX_czyname3;
parameters[158].Value = model.QX_czyname4;
parameters[159].Value = model.QX_lry;
parameters[160].Value = model.QX_lryname;
parameters[161].Value = model.QX_bhgallsl;
parameters[162].Value = model.qxng1;
parameters[163].Value = model.qxngoth;
parameters[164].Value = model.qxngothnum;
parameters[165].Value = model.包装;
parameters[166].Value = model.BZ_sbbh1;
parameters[167].Value = model.BZ_sbbh2;
parameters[168].Value = model.BZ_sbbh3;
parameters[169].Value = model.BZ_sbbh4;
parameters[170].Value = model.BZ_sjsl;
parameters[171].Value = model.BZ_xcsl;
parameters[172].Value = model.BZ_xctime;
parameters[173].Value = model.BZ_czy1;
parameters[174].Value = model.BZ_czy2;
parameters[175].Value = model.BZ_czy3;
parameters[176].Value = model.BZ_czy4;
parameters[177].Value = model.BZ_czyname1;
parameters[178].Value = model.BZ_czyname2;
parameters[179].Value = model.BZ_czyname3;
parameters[180].Value = model.BZ_czyname4;
parameters[181].Value = model.BZ_lry;
parameters[182].Value = model.BZ_lryname;
parameters[183].Value = model.BZ_bhgallsl;
parameters[184].Value = model.bzng1;
parameters[185].Value = model.bzngoth;
parameters[186].Value = model.bzngothnum;
parameters[187].Value = model.gcsj_liushuih;
parameters[188].Value = model.lsh1;
parameters[189].Value = model.lsh2;
parameters[190].Value = model.lsh3;
parameters[191].Value = model.gcsj_CASE;
parameters[192].Value = model.case1;
parameters[193].Value = model.case2;
parameters[194].Value = model.case3;
parameters[195].Value = model.gcsj_LDjia;
parameters[196].Value = model.ld1;
parameters[197].Value = model.ld2;
parameters[198].Value = model.ld3;
parameters[199].Value = model.gcsj_PDjia;
parameters[200].Value = model.pd1;
parameters[201].Value = model.pd2;
parameters[202].Value = model.pd3;
parameters[203].Value = model.gcsj_LDjian;
parameters[204].Value = model.ldj1;
parameters[205].Value = model.ldj2;
parameters[206].Value = model.ldj3;
parameters[207].Value = model.gcsj_jicha;
parameters[208].Value = model.jc1;
parameters[209].Value = model.jc2;
parameters[210].Value = model.jc3;
parameters[211].Value = model.gcsj_yatou;
parameters[212].Value = model.yt1;
parameters[213].Value = model.yt2;
parameters[214].Value = model.yt3;
parameters[215].Value = model.gcsj_oxianliang;
parameters[216].Value = model.oxl1;
parameters[217].Value = model.oxl2;
parameters[218].Value = model.oxl3;
parameters[219].Value = model.ldxp_xinpianjj;
parameters[220].Value = model.ldxp_jianyanry;
parameters[221].Value = model.ldxp_jianyansb;
parameters[222].Value = model.bggSum;
parameters[223].Value = model.备注;
parameters[224].Value = model.LD_lx;
parameters[225].Value = model.LD_xh;
parameters[226].Value = model.LD_name;
parameters[227].Value = model.LD_sjdh;
parameters[228].Value = model.LD_remark;
parameters[229].Value = model.PT_lx;
parameters[230].Value = model.PT_xh;
parameters[231].Value = model.PT_name;
parameters[232].Value = model.PT_sjdh;
parameters[233].Value = model.PT_remark;
parameters[234].Value = model.KT_lx;
parameters[235].Value = model.KT_xh;
parameters[236].Value = model.KT_name;
parameters[237].Value = model.KT_sjdh;
parameters[238].Value = model.KT_remark;
parameters[239].Value = model.NBP_lx0;
parameters[240].Value = model.NBP_xh0;
parameters[241].Value = model.NBP_name0;
parameters[242].Value = model.NBP_sjdh0;
parameters[243].Value = model.NBP_remark0;
parameters[244].Value = model.NBP_lx45;
parameters[245].Value = model.NBP_xh45;
parameters[246].Value = model.NBP_name45;
parameters[247].Value = model.NBP_sjdh45;
parameters[248].Value = model.NBP_remark45;
parameters[249].Value = model.JK_lx;
parameters[250].Value = model.JK_xh;
parameters[251].Value = model.JK_name;
parameters[252].Value = model.JK_sjdh;
parameters[253].Value = model.JK_remark;
int rows = dbhelper1.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
