private void Frm_Analysis_Load(object sender, EventArgs e) { if (string.IsNullOrEmpty(source_code)) { MessageBox.Show("参数未设置"); this.Close(); return; } if (source_code == "9107") { this.Text = "小包分析代码设置"; } else if (source_code == "9108") { this.Text = "外箱分析代码设置"; } #region 分析代码名称获取 FOUNDERPCB_ANALYSIS anainfo = new FOUNDERPCB_ANALYSIS(); FOUNDERPCB_ANALYSISBLL anabll = new FOUNDERPCB_ANALYSISBLL(db); if (anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=1").Count > 0) { int rkey = anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=1")[0].RKEY; anainfo = anabll.GetModel(rkey); if (anainfo.ANS_NAME.Trim().Length > 0) { textBox1.Text = anainfo.ANS_NAME.Trim(); } } if (anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=2").Count > 0) { int rkey = anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=2")[0].RKEY; anainfo = anabll.GetModel(rkey); if (anainfo.ANS_NAME.Trim().Length > 0) { textBox2.Text = anainfo.ANS_NAME.Trim(); } } if (anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=3").Count > 0) { int rkey = anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=3")[0].RKEY; anainfo = anabll.GetModel(rkey); if (anainfo.ANS_NAME.Trim().Length > 0) { textBox3.Text = anainfo.ANS_NAME.Trim(); } } if (anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=4").Count > 0) { int rkey = anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=4")[0].RKEY; anainfo = anabll.GetModel(rkey); if (anainfo.ANS_NAME.Trim().Length > 0) { textBox4.Text = anainfo.ANS_NAME.Trim(); } } if (anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=5").Count > 0) { int rkey = anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=5")[0].RKEY; anainfo = anabll.GetModel(rkey); if (anainfo.ANS_NAME.Trim().Length > 0) { textBox5.Text = anainfo.ANS_NAME.Trim(); } } #endregion }
private void button1_Click(object sender, EventArgs e) { FOUNDERPCB_ANALYSIS info = new FOUNDERPCB_ANALYSIS(); FOUNDERPCB_ANALYSISBLL bll = new FOUNDERPCB_ANALYSISBLL(db); #region 表不存在则创建 if (!db.TabExists("FOUNDERPCB_ANALYSIS")) { string sql = @"CREATE TABLE [dbo].[FOUNDERPCB_ANALYSIS]( [RKEY] [int] IDENTITY(1,1) NOT NULL, [SOURCE_CODE] [varchar](20) NULL, [ID_KEY] [int] NULL, [ANS_NAME] [varchar](50) NULL, CONSTRAINT [PK_FOUNDERPCB_ANALYSIS] PRIMARY KEY CLUSTERED ( [RKEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; db.ExecuteNonQuery(sql); } #endregion #region 事务处理 using (SqlConnection conn = new SqlConnection(GlobalVal.ConnectionString(GlobalVal.UserInfo.FactoryID))) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted)) { SqlCommand cmd = new SqlCommand(); cmd.CommandTimeout = 360; try { #region 分析代码1 if (bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=1").Count > 0) { int rkey = bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=1")[0].RKEY; info = bll.GetModel(rkey); info.ANS_NAME = textBox1.Text.Trim(); bll.Update(cmd, conn, trans, info); } else { info.SOURCE_CODE = source_code; info.ID_KEY = 1; info.ANS_NAME = textBox1.Text.Trim(); bll.Add(cmd, conn, trans, info); } #endregion #region 分析代码2 if (bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=2").Count > 0) { int rkey = bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=2")[0].RKEY; info = bll.GetModel(rkey); info.ANS_NAME = textBox2.Text.Trim(); bll.Update(cmd, conn, trans, info); } else { info.SOURCE_CODE = source_code; info.ID_KEY = 2; info.ANS_NAME = textBox2.Text.Trim(); bll.Add(cmd, conn, trans, info); } #endregion #region 分析代码3 if (bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=3").Count > 0) { int rkey = bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=3")[0].RKEY; info = bll.GetModel(rkey); info.ANS_NAME = textBox3.Text.Trim(); bll.Update(cmd, conn, trans, info); } else { info.SOURCE_CODE = source_code; info.ID_KEY = 3; info.ANS_NAME = textBox3.Text.Trim(); bll.Add(cmd, conn, trans, info); } #endregion #region 分析代码4 if (bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=4").Count > 0) { int rkey = bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=4")[0].RKEY; info = bll.GetModel(rkey); info.ANS_NAME = textBox4.Text.Trim(); bll.Update(cmd, conn, trans, info); } else { info.SOURCE_CODE = source_code; info.ID_KEY = 4; info.ANS_NAME = textBox4.Text.Trim(); bll.Add(cmd, conn, trans, info); } #endregion #region 分析代码5 if (bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=5").Count > 0) { int rkey = bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=5")[0].RKEY; info = bll.GetModel(rkey); info.ANS_NAME = textBox5.Text.Trim(); bll.Update(cmd, conn, trans, info); } else { info.SOURCE_CODE = source_code; info.ID_KEY = 5; info.ANS_NAME = textBox5.Text.Trim(); bll.Add(cmd, conn, trans, info); } #endregion trans.Commit(); MessageBox.Show("保存成功!"); } catch (Exception ee) { trans.Rollback();//异常回滚 log.PrintInfo(ee); MessageBox.Show("数据处理失败!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } } #endregion }