void add_db(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestReportForAQDBEntity model) { strSql = new StringBuilder( ); strSql.Append("insert into R_PQDB("); strSql.Append("DB001,DB002,DB003,DB004,DB005,DB006,DB007,DB008,DB009,DB010)"); strSql.Append(" values ("); strSql.Append("@DB001,@DB002,@DB003,@DB004,@DB005,@DB006,@DB007,@DB008,@DB009,@DB010)"); SqlParameter [] parameters = { new SqlParameter("@DB001", SqlDbType.NVarChar, 20), new SqlParameter("@DB002", SqlDbType.NVarChar, 50), new SqlParameter("@DB003", SqlDbType.NVarChar, 50), new SqlParameter("@DB004", SqlDbType.Int, 4), new SqlParameter("@DB005", SqlDbType.Int, 4), new SqlParameter("@DB006", SqlDbType.Int, 4), new SqlParameter("@DB007", SqlDbType.Int, 4), new SqlParameter("@DB008", SqlDbType.Int, 4), new SqlParameter("@DB009", SqlDbType.NVarChar, 100), new SqlParameter("@DB010", SqlDbType.Int, 4) }; parameters [0].Value = model.DB001; parameters [1].Value = model.DB002; parameters [2].Value = model.DB003; parameters [3].Value = model.DB004; parameters [4].Value = model.DB005; parameters [5].Value = model.DB006; parameters [6].Value = model.DB007; parameters [7].Value = model.DB008; parameters [8].Value = model.DB009; parameters [9].Value = model.DB010; SQLString.Add(strSql, parameters); }
/// <summary> /// save data to r_pqda r_pqdb /// </summary> /// <param name="table"></param> /// <param name="_da"></param> /// <param name="bodyList"></param> /// <param name="logins"></param> /// <returns></returns> public bool Save(DataTable table, MulaolaoLibrary.TestReportForAQDAEntity _da, List <string> bodyList, string logins) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); if (_da.idx < 1) { _da.DA001 = getOddNum( ); add_da(SQLString, strSql, _da); SQLString.Add(Drity.DrityOfComparation("R_142", "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "新增", "新增表头"), null); } else { edit_da(SQLString, strSql, _da); SQLString.Add(Drity.DrityOfComparation("R_142", "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑表头"), null); } MulaolaoLibrary.TestReportForAQDBEntity model = new MulaolaoLibrary.TestReportForAQDBEntity( ); model.DB001 = _da.DA001; for (int i = 0; i < table.Rows.Count; i++) { model.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( )); model.DB002 = table.Rows [i] ["DB002"].ToString( ); model.DB003 = table.Rows [i] ["DB003"].ToString( ); model.DB004 = string.IsNullOrEmpty(table.Rows [i] ["DB004"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB004"].ToString( )); model.DB005 = string.IsNullOrEmpty(table.Rows [i] ["DB005"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB005"].ToString( )); model.DB006 = string.IsNullOrEmpty(table.Rows [i] ["DB006"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB006"].ToString( )); model.DB007 = string.IsNullOrEmpty(table.Rows [i] ["DB007"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB007"].ToString( )); model.DB008 = string.IsNullOrEmpty(table.Rows [i] ["DB008"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB008"].ToString( )); model.DB009 = table.Rows [i] ["DB009"].ToString( ); model.DB010 = string.IsNullOrEmpty(table.Rows [i] ["DB010"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB010"].ToString( )); if (model.idx < 1) { add_db(SQLString, strSql, model); SQLString.Add(Drity.DrityOfComparation("R_142" + i, "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "新增", "新增表身"), null); } else { edit_db(SQLString, strSql, model); SQLString.Add(Drity.DrityOfComparation("R_142" + i, "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑表身"), null); } } if (bodyList.Count > 0) { foreach (string s in bodyList) { model.idx = Convert.ToInt32(s); delete_db(SQLString, strSql, model); SQLString.Add(Drity.DrityOfComparation("R_142" + model.idx, "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "删除", "删除表身"), null); } } return(SqlHelper.ExecuteSqlTran(SQLString)); }
void delete_db(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestReportForAQDBEntity model) { strSql = new StringBuilder( ); strSql.Append("delete from R_PQDB "); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@idx", SqlDbType.Int, 4) }; parameters [0].Value = model.idx; SQLString.Add(strSql, parameters); }
void edit_db(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestReportForAQDBEntity model) { strSql = new StringBuilder( ); strSql.Append("update R_PQDB set "); strSql.Append("DB001=@DB001,"); strSql.Append("DB002=@DB002,"); strSql.Append("DB003=@DB003,"); strSql.Append("DB004=@DB004,"); strSql.Append("DB005=@DB005,"); strSql.Append("DB006=@DB006,"); strSql.Append("DB007=@DB007,"); strSql.Append("DB008=@DB008,"); strSql.Append("DB009=@DB009,"); strSql.Append("DB010=@DB010 "); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@DB001", SqlDbType.NVarChar, 20), new SqlParameter("@DB002", SqlDbType.NVarChar, 50), new SqlParameter("@DB003", SqlDbType.NVarChar, 50), new SqlParameter("@DB004", SqlDbType.Int, 4), new SqlParameter("@DB005", SqlDbType.Int, 4), new SqlParameter("@DB006", SqlDbType.Int, 4), new SqlParameter("@DB007", SqlDbType.Int, 4), new SqlParameter("@DB008", SqlDbType.Int, 4), new SqlParameter("@DB009", SqlDbType.NVarChar, 100), new SqlParameter("@DB010", SqlDbType.Int, 4), new SqlParameter("@idx", SqlDbType.Int, 4) }; parameters [0].Value = model.DB001; parameters [1].Value = model.DB002; parameters [2].Value = model.DB003; parameters [3].Value = model.DB004; parameters [4].Value = model.DB005; parameters [5].Value = model.DB006; parameters [6].Value = model.DB007; parameters [7].Value = model.DB008; parameters [8].Value = model.DB009; parameters [9].Value = model.DB010; parameters [10].Value = model.idx; SQLString.Add(strSql, parameters); }
public FormTestReportForAQ( ) { InitializeComponent( ); _da = new MulaolaoLibrary.TestReportForAQDAEntity( ); _db = new MulaolaoLibrary.TestReportForAQDBEntity( ); _bll = new MulaolaoBll.Bll.TestReportForAQBll( ); tableView = new DataTable( ); GridViewMoHuSelect.SetFilter(secView); GridViewMoHuSelect.SetFilter(gridView1); GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1 }); MulaolaoBll.UserInfoMation.tableName = this.Name; Power(this); UnEnable( ); secDA002.Properties.DataSource = _bll.getProInfo( ); secDA002.Properties.DisplayMember = "PQF04"; secDA002.Properties.ValueMember = "PQF01"; }