public FormTestResultRecord( ) { InitializeComponent( ); _cr = new MulaolaoLibrary.TestResultRecordCREntity( ); _cs = new MulaolaoLibrary.TestResultRecordCSEntity( ); _ct = new MulaolaoLibrary.TestResultRecordCTEntity( ); _bll = new MulaolaoBll.Bll.TestResultRecordBll( ); tableView = new DataTable( ); tableViewOne = new DataTable( ); GridViewMoHuSelect.SetFilter(secView); GridViewMoHuSelect.SetFilter(gridView1); GridViewMoHuSelect.SetFilter(gridView2); GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, gridView2 }); MulaolaoBll.UserInfoMation.tableName = this.Name; Power(this); UnEnable( ); secPro.Properties.DataSource = _bll.getProInfo( ); secPro.Properties.DisplayMember = "PQF04"; secPro.Properties.ValueMember = "PQF01"; reCheckBox.DataSource = _bll.getTableOfNum( ); reCheckBox.DisplayMember = "CT"; tableViewOne = _bll.getTableViewOne( ); gridControl2.DataSource = tableViewOne; }
void edit_ct(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestResultRecordCTEntity model) { strSql = new StringBuilder( ); strSql.Append("update R_PQCT set "); strSql.Append("CT001=@CT001,"); strSql.Append("CT002=@CT002,"); strSql.Append("CT003=@CT003,"); strSql.Append("CT004=@CT004,"); strSql.Append("CT005=@CT005,"); strSql.Append("CT006=@CT006,"); strSql.Append("CT007=@CT007,"); strSql.Append("CT009=@CT009,"); strSql.Append("CT010=@CT010,"); strSql.Append("CT011=@CT011,"); strSql.Append("CT012=@CT012,"); strSql.Append("CT013=@CT013,"); strSql.Append("CT014=@CT014 "); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@CT001", SqlDbType.NVarChar, 20), new SqlParameter("@CT002", SqlDbType.NVarChar, 100), new SqlParameter("@CT003", SqlDbType.NVarChar, 100), new SqlParameter("@CT004", SqlDbType.NVarChar, 100), new SqlParameter("@CT005", SqlDbType.NVarChar, 100), new SqlParameter("@CT006", SqlDbType.NVarChar, 100), new SqlParameter("@CT007", SqlDbType.NVarChar, 100), new SqlParameter("@CT009", SqlDbType.NVarChar, 10), new SqlParameter("@CT010", SqlDbType.NVarChar, 10), new SqlParameter("@CT011", SqlDbType.NVarChar, 10), new SqlParameter("@CT012", SqlDbType.NVarChar, 10), new SqlParameter("@CT013", SqlDbType.NVarChar, 10), new SqlParameter("@CT014", SqlDbType.NVarChar, 10), new SqlParameter("@idx", SqlDbType.Int, 4) }; parameters [0].Value = model.CT001; parameters [1].Value = model.CT002; parameters [2].Value = model.CT003; parameters [3].Value = model.CT004; parameters [4].Value = model.CT005; parameters [5].Value = model.CT006; parameters [6].Value = model.CT007; parameters [7].Value = model.CT009; parameters [8].Value = model.CT010; parameters [9].Value = model.CT011; parameters [10].Value = model.CT012; parameters [11].Value = model.CT013; parameters [12].Value = model.CT014; parameters [13].Value = model.idx; SQLString.Add(strSql, parameters); }
void delete_dt(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestResultRecordCTEntity model) { strSql = new StringBuilder( ); strSql.Append("delete from R_PQCT "); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@idx", SqlDbType.Int, 4) }; parameters [0].Value = model.idx; SQLString.Add(strSql, parameters); }
void add_ct(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestResultRecordCTEntity model) { strSql = new StringBuilder( ); strSql.Append("insert into R_PQCT("); strSql.Append("CT001,CT002,CT003,CT004,CT005,CT006,CT007,CT009,CT010,CT011,CT012,CT013,CT014)"); strSql.Append(" values ("); strSql.Append("@CT001,@CT002,@CT003,@CT004,@CT005,@CT006,@CT007,@CT009,@CT010,@CT011,@CT012,@CT013,@CT014)"); SqlParameter [] parameters = { new SqlParameter("@CT001", SqlDbType.NVarChar, 20), new SqlParameter("@CT002", SqlDbType.NVarChar, 100), new SqlParameter("@CT003", SqlDbType.NVarChar, 100), new SqlParameter("@CT004", SqlDbType.NVarChar, 100), new SqlParameter("@CT005", SqlDbType.NVarChar, 100), new SqlParameter("@CT006", SqlDbType.NVarChar, 100), new SqlParameter("@CT007", SqlDbType.NVarChar, 100), new SqlParameter("@CT009", SqlDbType.NVarChar, 10), new SqlParameter("@CT010", SqlDbType.NVarChar, 10), new SqlParameter("@CT011", SqlDbType.NVarChar, 10), new SqlParameter("@CT012", SqlDbType.NVarChar, 10), new SqlParameter("@CT013", SqlDbType.NVarChar, 10), new SqlParameter("@CT014", SqlDbType.NVarChar, 10) }; parameters [0].Value = model.CT001; parameters [1].Value = model.CT002; parameters [2].Value = model.CT003; parameters [3].Value = model.CT004; parameters [4].Value = model.CT005; parameters [5].Value = model.CT006; parameters [6].Value = model.CT007; parameters [7].Value = model.CT009; parameters [8].Value = model.CT010; parameters [9].Value = model.CT011; parameters [10].Value = model.CT012; parameters [11].Value = model.CT013; parameters [12].Value = model.CT014; SQLString.Add(strSql, parameters); }
/// <summary> /// save data to databse /// </summary> /// <param name="table">单身</param> /// <param name="_cr">单头</param> /// <param name="tableOne">系数</param> /// <param name="coeList">系数删除</param> /// <param name="bodyList">单身删除</param> /// <param name="logins">登录人</param> /// <returns></returns> public bool Save(DataTable table, MulaolaoLibrary.TestResultRecordCREntity _cr, DataTable tableOne, List <string> coeList, List <string> bodyList, string logins) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); if (_cr.idx < 1) { _cr.CR001 = getOddNum( ); add_cr(SQLString, strSql, _cr); SQLString.Add(Drity.DrityOfComparation("R_418", "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "新增表头"), null); } else { edit_cr(SQLString, strSql, _cr); SQLString.Add(Drity.DrityOfComparation("R_418", "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑表头"), null); } MulaolaoLibrary.TestResultRecordCSEntity _cs = new MulaolaoLibrary.TestResultRecordCSEntity( ); _cs.CS001 = _cr.CR001; for (int i = 0; i < table.Rows.Count; i++) { if (string.IsNullOrEmpty(table.Rows [i] ["CS002"].ToString( ))) { _cs.CS002 = null; } else { _cs.CS002 = Convert.ToDateTime(table.Rows [i] ["CS002"].ToString( )); } _cs.CS003 = table.Rows [i] ["CS003"].ToString( ); _cs.CS004 = table.Rows [i] ["CS004"].ToString( ); _cs.CS005 = table.Rows [i] ["CS005"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["CS006"].ToString( ))) { _cs.CS006 = null; } else { _cs.CS006 = Convert.ToDateTime(table.Rows [i] ["CS006"].ToString( )); } _cs.CS007 = string.IsNullOrEmpty(table.Rows [i] ["CS007"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CS007"].ToString( )); _cs.CS008 = string.IsNullOrEmpty(table.Rows [i] ["CS008"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CS008"].ToString( )); _cs.CS009 = table.Rows [i] ["CS009"].ToString( ); _cs.CS010 = table.Rows [i] ["CS010"].ToString( ); _cs.CS011 = table.Rows [i] ["CS011"].ToString( ); _cs.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( )); if (_cs.idx < 1) { add_cs(SQLString, strSql, _cs); SQLString.Add(Drity.DrityOfComparation("R_418-" + i, "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "新增单身"), null); } else { edit_cs(SQLString, strSql, _cs); SQLString.Add(Drity.DrityOfComparation("R_418-" + i, "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "编辑单身"), null); } } if (bodyList.Count > 0) { foreach (string s in bodyList) { delete_cs(SQLString, strSql, _cs); SQLString.Add(Drity.DrityOfComparation("R_418-" + s, "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "删除单身"), null); } } MulaolaoLibrary.TestResultRecordCTEntity _ct = new MulaolaoLibrary.TestResultRecordCTEntity( ); for (int i = 0; i < tableOne.Rows.Count; i++) { _ct.CT001 = tableOne.Rows [i] ["CT001"].ToString( ); _ct.CT002 = tableOne.Rows [i] ["CT002"].ToString( ); _ct.CT003 = tableOne.Rows [i] ["CT003"].ToString( ); _ct.CT004 = tableOne.Rows [i] ["CT004"].ToString( ); _ct.CT005 = tableOne.Rows [i] ["CT005"].ToString( ); _ct.CT006 = tableOne.Rows [i] ["CT006"].ToString( ); _ct.CT007 = tableOne.Rows [i] ["CT007"].ToString( ); _ct.CT009 = tableOne.Rows [i] ["CT009"].ToString( ); _ct.CT010 = tableOne.Rows [i] ["CT010"].ToString( ); _ct.CT011 = tableOne.Rows [i] ["CT011"].ToString( ); _ct.CT012 = tableOne.Rows [i] ["CT012"].ToString( ); _ct.CT013 = tableOne.Rows [i] ["CT013"].ToString( ); _ct.CT014 = tableOne.Rows [i] ["CT014"].ToString( ); _ct.idx = string.IsNullOrEmpty(tableOne.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(tableOne.Rows [i] ["idx"].ToString( )); if (_ct.idx < 1) { add_ct(SQLString, strSql, _ct); SQLString.Add(Drity.DrityOfComparation("R_418-" + i, "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "新增系数"), null); } else { edit_ct(SQLString, strSql, _ct); SQLString.Add(Drity.DrityOfComparation("R_418-" + i, "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "编辑系数"), null); } } if (coeList.Count > 0) { foreach (string s in coeList) { _ct.idx = Convert.ToInt32(s); delete_dt(SQLString, strSql, _ct); SQLString.Add(Drity.DrityOfComparation("R_418-" + s, "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "删除系数"), null); } } return(SqlHelper.ExecuteSqlTran(SQLString)); }