void setValues( ) { tableView = _bll.getTableView("DB001='" + _db.DB001 + "'"); gridControl1.DataSource = tableView; _da = _bll.getModel(_da.DA001); setValue( ); }
void add_da(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestReportForAQDAEntity model) { strSql = new StringBuilder( ); strSql.Append("insert into R_PQDA("); strSql.Append("DA001,DA002,DA003,DA004,DA005,DA006,DA007,DA008,DA009,DA010,DA011,DA012,DA013,DA014,DA015,DA016,DA017,DA018,DA019,DA020,DA021)"); strSql.Append(" values ("); strSql.Append("@DA001,@DA002,@DA003,@DA004,@DA005,@DA006,@DA007,@DA008,@DA009,@DA010,@DA011,@DA012,@DA013,@DA014,@DA015,@DA016,@DA017,@DA018,@DA019,@DA020,@DA021)"); SqlParameter [] parameters = { new SqlParameter("@DA001", SqlDbType.NVarChar, 20), new SqlParameter("@DA002", SqlDbType.NVarChar, 50), new SqlParameter("@DA003", SqlDbType.NVarChar, 20), new SqlParameter("@DA004", SqlDbType.NVarChar, 20), new SqlParameter("@DA005", SqlDbType.NVarChar, 20), new SqlParameter("@DA006", SqlDbType.Int, 4), new SqlParameter("@DA007", SqlDbType.NVarChar, 20), new SqlParameter("@DA008", SqlDbType.NVarChar, 20), new SqlParameter("@DA009", SqlDbType.NVarChar, 20), new SqlParameter("@DA010", SqlDbType.Date, 3), new SqlParameter("@DA011", SqlDbType.Date, 3), new SqlParameter("@DA012", SqlDbType.Date, 3), new SqlParameter("@DA013", SqlDbType.Date, 3), new SqlParameter("@DA014", SqlDbType.NVarChar, 200), new SqlParameter("@DA015", SqlDbType.Bit, 1), new SqlParameter("@DA016", SqlDbType.Bit, 1), new SqlParameter("@DA017", SqlDbType.Bit, 1), new SqlParameter("@DA018", SqlDbType.NVarChar, 20), new SqlParameter("@DA019", SqlDbType.Date, 3), new SqlParameter("@DA020", SqlDbType.NVarChar, 20), new SqlParameter("@DA021", SqlDbType.Date, 3) }; parameters [0].Value = model.DA001; parameters [1].Value = model.DA002; parameters [2].Value = model.DA003; parameters [3].Value = model.DA004; parameters [4].Value = model.DA005; parameters [5].Value = model.DA006; parameters [6].Value = model.DA007; parameters [7].Value = model.DA008; parameters [8].Value = model.DA009; parameters [9].Value = model.DA010; parameters [10].Value = model.DA011; parameters [11].Value = model.DA012; parameters [12].Value = model.DA013; parameters [13].Value = model.DA014; parameters [14].Value = model.DA015; parameters [15].Value = model.DA016; parameters [16].Value = model.DA017; parameters [17].Value = model.DA018; parameters [18].Value = model.DA019; parameters [19].Value = model.DA020; parameters [20].Value = model.DA021; 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)); }
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"; }
public MulaolaoLibrary.TestReportForAQDAEntity getModel(DataRow row) { MulaolaoLibrary.TestReportForAQDAEntity model = new MulaolaoLibrary.TestReportForAQDAEntity( ); if (row != null) { if (row ["idx"] != null && row ["idx"].ToString( ) != "") { model.idx = int.Parse(row ["idx"].ToString( )); } if (row ["DA001"] != null) { model.DA001 = row ["DA001"].ToString( ); } if (row ["DA002"] != null) { model.DA002 = row ["DA002"].ToString( ); } if (row ["DA003"] != null) { model.DA003 = row ["DA003"].ToString( ); } if (row ["DA004"] != null) { model.DA004 = row ["DA004"].ToString( ); } if (row ["DA005"] != null) { model.DA005 = row ["DA005"].ToString( ); } if (row ["DA006"] != null && row ["DA006"].ToString( ) != "") { model.DA006 = int.Parse(row ["DA006"].ToString( )); } if (row ["DA007"] != null) { model.DA007 = row ["DA007"].ToString( ); } if (row ["DA008"] != null) { model.DA008 = row ["DA008"].ToString( ); } if (row ["DA009"] != null) { model.DA009 = row ["DA009"].ToString( ); } if (row ["DA010"] != null && row ["DA010"].ToString( ) != "") { model.DA010 = DateTime.Parse(row ["DA010"].ToString( )); } if (row ["DA011"] != null && row ["DA011"].ToString( ) != "") { model.DA011 = DateTime.Parse(row ["DA011"].ToString( )); } if (row ["DA012"] != null && row ["DA012"].ToString( ) != "") { model.DA012 = DateTime.Parse(row ["DA012"].ToString( )); } if (row ["DA013"] != null && row ["DA013"].ToString( ) != "") { model.DA013 = DateTime.Parse(row ["DA013"].ToString( )); } if (row ["DA014"] != null) { model.DA014 = row ["DA014"].ToString( ); } if (row ["DA015"] != null && row ["DA015"].ToString( ) != "") { if ((row ["DA015"].ToString( ) == "1") || (row ["DA015"].ToString( ).ToLower( ) == "true")) { model.DA015 = true; } else { model.DA015 = false; } } if (row ["DA016"] != null && row ["DA016"].ToString( ) != "") { if ((row ["DA016"].ToString( ) == "1") || (row ["DA016"].ToString( ).ToLower( ) == "true")) { model.DA016 = true; } else { model.DA016 = false; } } if (row ["DA017"] != null && row ["DA017"].ToString( ) != "") { if ((row ["DA017"].ToString( ) == "1") || (row ["DA017"].ToString( ).ToLower( ) == "true")) { model.DA017 = true; } else { model.DA017 = false; } } if (row ["DA018"] != null) { model.DA018 = row ["DA018"].ToString( ); } if (row ["DA019"] != null && row ["DA019"].ToString( ) != "") { model.DA019 = DateTime.Parse(row ["DA019"].ToString( )); } if (row ["DA020"] != null) { model.DA020 = row ["DA020"].ToString( ); } if (row ["DA021"] != null && row ["DA021"].ToString( ) != "") { model.DA021 = DateTime.Parse(row ["DA021"].ToString( )); } } return(model); }
void edit_da(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestReportForAQDAEntity model) { strSql = new StringBuilder( ); strSql.Append("update R_PQDA set "); strSql.Append("DA001=@DA001,"); strSql.Append("DA002=@DA002,"); strSql.Append("DA003=@DA003,"); strSql.Append("DA004=@DA004,"); strSql.Append("DA005=@DA005,"); strSql.Append("DA006=@DA006,"); strSql.Append("DA007=@DA007,"); strSql.Append("DA008=@DA008,"); strSql.Append("DA009=@DA009,"); strSql.Append("DA010=@DA010,"); strSql.Append("DA011=@DA011,"); strSql.Append("DA012=@DA012,"); strSql.Append("DA013=@DA013,"); strSql.Append("DA014=@DA014,"); strSql.Append("DA015=@DA015,"); strSql.Append("DA016=@DA016,"); strSql.Append("DA017=@DA017,"); strSql.Append("DA018=@DA018,"); strSql.Append("DA019=@DA019,"); strSql.Append("DA020=@DA020,"); strSql.Append("DA021=@DA021 "); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@DA001", SqlDbType.NVarChar, 20), new SqlParameter("@DA002", SqlDbType.NVarChar, 50), new SqlParameter("@DA003", SqlDbType.NVarChar, 20), new SqlParameter("@DA004", SqlDbType.NVarChar, 20), new SqlParameter("@DA005", SqlDbType.NVarChar, 20), new SqlParameter("@DA006", SqlDbType.Int, 4), new SqlParameter("@DA007", SqlDbType.NVarChar, 20), new SqlParameter("@DA008", SqlDbType.NVarChar, 20), new SqlParameter("@DA009", SqlDbType.NVarChar, 20), new SqlParameter("@DA010", SqlDbType.Date, 3), new SqlParameter("@DA011", SqlDbType.Date, 3), new SqlParameter("@DA012", SqlDbType.Date, 3), new SqlParameter("@DA013", SqlDbType.Date, 3), new SqlParameter("@DA014", SqlDbType.NVarChar, 200), new SqlParameter("@DA015", SqlDbType.Bit, 1), new SqlParameter("@DA016", SqlDbType.Bit, 1), new SqlParameter("@DA017", SqlDbType.Bit, 1), new SqlParameter("@DA018", SqlDbType.NVarChar, 20), new SqlParameter("@DA019", SqlDbType.Date, 3), new SqlParameter("@DA020", SqlDbType.NVarChar, 20), new SqlParameter("@DA021", SqlDbType.Date, 3), new SqlParameter("@idx", SqlDbType.Int, 4) }; parameters [0].Value = model.DA001; parameters [1].Value = model.DA002; parameters [2].Value = model.DA003; parameters [3].Value = model.DA004; parameters [4].Value = model.DA005; parameters [5].Value = model.DA006; parameters [6].Value = model.DA007; parameters [7].Value = model.DA008; parameters [8].Value = model.DA009; parameters [9].Value = model.DA010; parameters [10].Value = model.DA011; parameters [11].Value = model.DA012; parameters [12].Value = model.DA013; parameters [13].Value = model.DA014; parameters [14].Value = model.DA015; parameters [15].Value = model.DA016; parameters [16].Value = model.DA017; parameters [17].Value = model.DA018; parameters [18].Value = model.DA019; parameters [19].Value = model.DA020; parameters [20].Value = model.DA021; parameters [21].Value = model.idx; 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) { return(_dal.Save(table, _da, bodyList, logins)); }