void add_pqcf(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.StandardAuditTreCFEntity model) { strSql = new StringBuilder( ); strSql.Append("insert into R_PQCF("); strSql.Append("CF001,CF002,CF003,CF004,CF005,CF006,CF007,CF008,CF009,CF010)"); strSql.Append(" values ("); strSql.Append("@CF001,@CF002,@CF003,@CF004,@CF005,@CF006,@CF007,@CF008,@CF009,@CF010)"); SqlParameter [] parameters = { new SqlParameter("@CF001", SqlDbType.NVarChar, 20), new SqlParameter("@CF002", SqlDbType.NVarChar, 20), new SqlParameter("@CF003", SqlDbType.NVarChar, 50), new SqlParameter("@CF004", SqlDbType.NVarChar, 20), new SqlParameter("@CF005", SqlDbType.Int, 4), new SqlParameter("@CF006", SqlDbType.NVarChar, 50), new SqlParameter("@CF007", SqlDbType.NVarChar, 20), new SqlParameter("@CF008", SqlDbType.NVarChar, 20), new SqlParameter("@CF009", SqlDbType.NVarChar, 20), new SqlParameter("@CF010", SqlDbType.NVarChar, 20) }; parameters [0].Value = model.CF001; parameters [1].Value = model.CF002; parameters [2].Value = model.CF003; parameters [3].Value = model.CF004; parameters [4].Value = model.CF005; parameters [5].Value = model.CF006; parameters [6].Value = model.CF007; parameters [7].Value = model.CF008; parameters [8].Value = model.CF009; parameters [9].Value = model.CF010; SQLString.Add(strSql, parameters); }
public MulaolaoLibrary.StandardAuditTreCFEntity getDataRow(DataRow row) { MulaolaoLibrary.StandardAuditTreCFEntity model = new MulaolaoLibrary.StandardAuditTreCFEntity( ); if (row != null) { if (row ["CF001"] != null) { model.CF001 = row ["CF001"].ToString( ); } if (row ["CF002"] != null) { model.CF002 = row ["CF002"].ToString( ); } if (row ["CF003"] != null) { model.CF003 = row ["CF003"].ToString( ); } if (row ["CF004"] != null) { model.CF004 = row ["CF004"].ToString( ); } if (row ["CF005"] != null && row ["CF005"].ToString( ) != string.Empty) { model.CF005 = int.Parse(row ["CF005"].ToString( )); } if (row ["CF006"] != null) { model.CF006 = row ["CF006"].ToString( ); } if (row ["CF007"] != null) { model.CF007 = row ["CF007"].ToString( ); } if (row ["CF008"] != null) { model.CF008 = row ["CF008"].ToString( ); } if (row ["CF009"] != null) { model.CF009 = row ["CF009"].ToString( ); } if (row ["CF010"] != null) { model.CF010 = row ["CF010"].ToString( ); } } return(model); }
void getData( ) { _cf = _bll.getModel(_cf.CF001); secPro.EditValue = _cf.CF002; txtNum.Text = _cf.CF002; txtNo.Text = _cf.CF004; txtNumer.Text = _cf.CF005.ToString( ); txtColor.Text = _cf.CF006; cmbUserOne.Text = _cf.CF007; cmbUserTwo.Text = _cf.CF008; cmbUserTre.Text = _cf.CF009; cmbUserFor.Text = _cf.CF010; tableView = _bll.getView(" CG001='" + _cf.CF001 + "'"); gridControl1.DataSource = tableView; }
public FormStandardAuditTre( ) { InitializeComponent( ); _cf = new MulaolaoLibrary.StandardAuditTreCFEntity( ); _cg = new MulaolaoLibrary.StandardAuditTreCGEntity( ); _bll = new MulaolaoBll.Bll.StandardAuditTreBll( ); tableView = new DataTable( ); PrintOne = new DataTable( ); PrintTwo = new DataTable( ); GridViewMoHuSelect.SetFilter(secView); GridViewMoHuSelect.SetFilter(bandedGridView1); GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { bandedGridView1 }); Power(this); UnEnable( ); MulaolaoBll.UserInfoMation.tableName = this.Name; secPro.Properties.DataSource = _bll.getProInfo( ); secPro.Properties.DisplayMember = "PQF04"; secPro.Properties.ValueMember = "PQF01"; DataTable dt = _bll.getUser( ); if (dt != null && dt.Rows.Count > 0) { DataTable da = dt.Copy( ).DefaultView.ToTable(true, "CF007"); for (int i = 0; i < da.Rows.Count; i++) { cmbUserOne.Properties.Items.Add(da.Rows [i] ["CF007"].ToString( )); } da = dt.Copy( ).DefaultView.ToTable(true, "CF008"); for (int i = 0; i < da.Rows.Count; i++) { cmbUserTwo.Properties.Items.Add(da.Rows [i] ["CF008"].ToString( )); } da = dt.Copy( ).DefaultView.ToTable(true, "CF009"); for (int i = 0; i < da.Rows.Count; i++) { cmbUserTre.Properties.Items.Add(da.Rows [i] ["CF009"].ToString( )); } da = dt.Copy( ).DefaultView.ToTable(true, "CF010"); for (int i = 0; i < da.Rows.Count; i++) { cmbUserFor.Properties.Items.Add(da.Rows [i] ["CF010"].ToString( )); } } }
void edit_pqcf(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.StandardAuditTreCFEntity model) { strSql = new StringBuilder( ); strSql.Append("update R_PQCF set "); strSql.Append("CF002=@CF002,"); strSql.Append("CF003=@CF003,"); strSql.Append("CF004=@CF004,"); strSql.Append("CF005=@CF005,"); strSql.Append("CF006=@CF006,"); strSql.Append("CF007=@CF007,"); strSql.Append("CF008=@CF008,"); strSql.Append("CF009=@CF009,"); strSql.Append("CF010=@CF010 "); strSql.Append(" where CF001=@CF001"); SqlParameter [] parameters = { new SqlParameter("@CF001", SqlDbType.NVarChar, 20), new SqlParameter("@CF002", SqlDbType.NVarChar, 20), new SqlParameter("@CF003", SqlDbType.NVarChar, 50), new SqlParameter("@CF004", SqlDbType.NVarChar, 20), new SqlParameter("@CF005", SqlDbType.Int, 4), new SqlParameter("@CF006", SqlDbType.NVarChar, 50), new SqlParameter("@CF007", SqlDbType.NVarChar, 20), new SqlParameter("@CF008", SqlDbType.NVarChar, 20), new SqlParameter("@CF009", SqlDbType.NVarChar, 20), new SqlParameter("@CF010", SqlDbType.NVarChar, 20) }; parameters [0].Value = model.CF001; parameters [1].Value = model.CF002; parameters [2].Value = model.CF003; parameters [3].Value = model.CF004; parameters [4].Value = model.CF005; parameters [5].Value = model.CF006; parameters [6].Value = model.CF007; parameters [7].Value = model.CF008; parameters [8].Value = model.CF009; parameters [9].Value = model.CF010; SQLString.Add(strSql, parameters); }
/// <summary> /// edit data from r_pqcb and r_pqcc to database /// </summary> /// <param name="table"></param> /// <param name="_cb"></param> /// <param name="logins"></param> /// <param name="strList"></param> /// <returns></returns> public bool Edit(DataTable table, MulaolaoLibrary.StandardAuditTreCFEntity _cf, string logins, List <string> strList) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); edit_pqcf(SQLString, strSql, _cf); SQLString.Add(Drity.DrityOfComparation("R_484", "动力段生产首件量.检具审核确认记录表(R_484)", logins, Drity.GetDt( ), _cf.CF001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑"), null); MulaolaoLibrary.StandardAuditTreCGEntity _ce = new MulaolaoLibrary.StandardAuditTreCGEntity( ); _ce.CG001 = _cf.CF001; for (int i = 0; i < table.Rows.Count; i++) { _ce.CG002 = table.Rows [i] ["CG002"].ToString( ); _ce.CG003 = table.Rows [i] ["CG003"].ToString( ); _ce.CG004 = table.Rows [i] ["CG004"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["CG005"].ToString( ))) { _ce.CG005 = null; } else { _ce.CG005 = Convert.ToDateTime(table.Rows [i] ["CG005"]); } if (string.IsNullOrEmpty(table.Rows [i] ["CG006"].ToString( ))) { _ce.CG006 = null; } else { _ce.CG006 = Convert.ToDateTime(table.Rows [i] ["CG006"]); } _ce.CG007 = table.Rows [i] ["CG007"].ToString( ); _ce.CG008 = table.Rows [i] ["CG008"].ToString( ); _ce.CG009 = table.Rows [i] ["CG009"].ToString( ); _ce.CG010 = table.Rows [i] ["CG010"].ToString( ); _ce.CG011 = table.Rows [i] ["CG011"].ToString( ); _ce.CG012 = table.Rows [i] ["CG012"].ToString( ); _ce.CG013 = table.Rows [i] ["CG013"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["CG014"].ToString( ))) { _ce.CG014 = null; } else { _ce.CG014 = Convert.ToDateTime(table.Rows [i] ["CG014"]); } _ce.CG015 = table.Rows [i] ["CG015"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["CG016"].ToString( ))) { _ce.CG016 = null; } else { _ce.CG016 = Convert.ToDateTime(table.Rows [i] ["CG016"]); } _ce.CG017 = table.Rows [i] ["CG017"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["CG018"].ToString( ))) { _ce.CG018 = null; } else { _ce.CG018 = Convert.ToDateTime(table.Rows [i] ["CG018"]); } _ce.CG019 = table.Rows [i] ["CG019"].ToString( ); _ce.CG020 = table.Rows [i] ["CG020"].ToString( ); _ce.CG021 = table.Rows [i] ["CG021"].ToString( ); _ce.CG022 = table.Rows [i] ["CG022"].ToString( ); _ce.CG023 = table.Rows [i] ["CG023"].ToString( ); _ce.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( )); if (_ce.idx < 1) { add_pqcg(SQLString, strSql, _ce, logins); } else { edit_pqcg(SQLString, strSql, _ce, logins); } } foreach (string s in strList) { _ce.idx = Convert.ToInt32(s); delete_pqcg(SQLString, strSql, _ce, logins); } return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// edit data from r_pqcb and r_pqcc to database /// </summary> /// <param name="table"></param> /// <param name="_cb"></param> /// <param name="logins"></param> /// <param name="strList"></param> /// <returns></returns> public bool Edit(DataTable table, MulaolaoLibrary.StandardAuditTreCFEntity _cd, string logins, List <string> strList) { return(_dal.Edit(table, _cd, logins, strList)); }
/// <summary> /// save data to r_pqcb and r_pqcc /// </summary> /// <param name="table"></param> /// <param name="_cb"></param> /// <returns></returns> public bool Save(DataTable table, MulaolaoLibrary.StandardAuditTreCFEntity _cd, string logins) { return(_dal.Save(table, _cd, logins)); }