void add_pqcf(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.StandardAuditFivCJEntity model) { strSql = new StringBuilder( ); strSql.Append("insert into R_PQCJ("); strSql.Append("CJ001,CJ002,CJ003,CJ004,CJ005,CJ006,CJ007,CJ008,CJ009,CJ010)"); strSql.Append(" values ("); strSql.Append("@CJ001,@CJ002,@CJ003,@CJ004,@CJ005,@CJ006,@CJ007,@CJ008,@CJ009,@CJ010)"); SqlParameter [] parameters = { new SqlParameter("@CJ001", SqlDbType.NVarChar, 20), new SqlParameter("@CJ002", SqlDbType.NVarChar, 20), new SqlParameter("@CJ003", SqlDbType.NVarChar, 50), new SqlParameter("@CJ004", SqlDbType.NVarChar, 20), new SqlParameter("@CJ005", SqlDbType.Int, 4), new SqlParameter("@CJ006", SqlDbType.NVarChar, 50), new SqlParameter("@CJ007", SqlDbType.NVarChar, 20), new SqlParameter("@CJ008", SqlDbType.NVarChar, 20), new SqlParameter("@CJ009", SqlDbType.NVarChar, 20), new SqlParameter("@CJ010", SqlDbType.NVarChar, 20) }; parameters [0].Value = model.CJ001; parameters [1].Value = model.CJ002; parameters [2].Value = model.CJ003; parameters [3].Value = model.CJ004; parameters [4].Value = model.CJ005; parameters [5].Value = model.CJ006; parameters [6].Value = model.CJ007; parameters [7].Value = model.CJ008; parameters [8].Value = model.CJ009; parameters [9].Value = model.CJ010; SQLString.Add(strSql, parameters); }
public MulaolaoLibrary.StandardAuditFivCJEntity getDataRow(DataRow row) { MulaolaoLibrary.StandardAuditFivCJEntity model = new MulaolaoLibrary.StandardAuditFivCJEntity( ); if (row != null) { if (row ["CJ001"] != null) { model.CJ001 = row ["CJ001"].ToString( ); } if (row ["CJ002"] != null) { model.CJ002 = row ["CJ002"].ToString( ); } if (row ["CJ003"] != null) { model.CJ003 = row ["CJ003"].ToString( ); } if (row ["CJ004"] != null) { model.CJ004 = row ["CJ004"].ToString( ); } if (row ["CJ005"] != null && row ["CJ005"].ToString( ) != string.Empty) { model.CJ005 = int.Parse(row ["CJ005"].ToString( )); } if (row ["CJ006"] != null) { model.CJ006 = row ["CJ006"].ToString( ); } if (row ["CJ007"] != null) { model.CJ007 = row ["CJ007"].ToString( ); } if (row ["CJ008"] != null) { model.CJ008 = row ["CJ008"].ToString( ); } if (row ["CJ009"] != null) { model.CJ009 = row ["CJ009"].ToString( ); } if (row ["CJ010"] != null) { model.CJ010 = row ["CJ010"].ToString( ); } } return(model); }
void getData( ) { _cj = _bll.getModel(_cj.CJ001); secPro.EditValue = _cj.CJ002; txtNum.Text = _cj.CJ002; txtNo.Text = _cj.CJ004; txtNumer.Text = _cj.CJ005.ToString( ); txtColor.Text = _cj.CJ006; cmbUserOne.Text = _cj.CJ007; cmbUserTwo.Text = _cj.CJ008; cmbUserTre.Text = _cj.CJ009; cmbUserFor.Text = _cj.CJ010; tableView = _bll.getView(" CK001='" + _cj.CJ001 + "'"); gridControl1.DataSource = tableView; }
public FormStandardAuditFiv( ) { InitializeComponent( ); _cj = new MulaolaoLibrary.StandardAuditFivCJEntity( ); _ck = new MulaolaoLibrary.StandardAuditFivCKEntity( ); _bll = new MulaolaoBll.Bll.StandardAuditFivBll( ); 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, "CJ007"); for (int i = 0; i < da.Rows.Count; i++) { cmbUserOne.Properties.Items.Add(da.Rows [i] ["CJ007"].ToString( )); } da = dt.Copy( ).DefaultView.ToTable(true, "CJ008"); for (int i = 0; i < da.Rows.Count; i++) { cmbUserTwo.Properties.Items.Add(da.Rows [i] ["CJ008"].ToString( )); } da = dt.Copy( ).DefaultView.ToTable(true, "CJ009"); for (int i = 0; i < da.Rows.Count; i++) { cmbUserTre.Properties.Items.Add(da.Rows [i] ["CJ009"].ToString( )); } da = dt.Copy( ).DefaultView.ToTable(true, "CJ010"); for (int i = 0; i < da.Rows.Count; i++) { cmbUserFor.Properties.Items.Add(da.Rows [i] ["CJ010"].ToString( )); } } }
void edit_pqcf(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.StandardAuditFivCJEntity model) { strSql = new StringBuilder( ); strSql.Append("update R_PQCJ set "); strSql.Append("CJ002=@CJ002,"); strSql.Append("CJ003=@CJ003,"); strSql.Append("CJ004=@CJ004,"); strSql.Append("CJ005=@CJ005,"); strSql.Append("CJ006=@CJ006,"); strSql.Append("CJ007=@CJ007,"); strSql.Append("CJ008=@CJ008,"); strSql.Append("CJ009=@CJ009,"); strSql.Append("CJ010=@CJ010 "); strSql.Append(" where CJ001=@CJ001"); SqlParameter [] parameters = { new SqlParameter("@CJ001", SqlDbType.NVarChar, 20), new SqlParameter("@CJ002", SqlDbType.NVarChar, 20), new SqlParameter("@CJ003", SqlDbType.NVarChar, 50), new SqlParameter("@CJ004", SqlDbType.NVarChar, 20), new SqlParameter("@CJ005", SqlDbType.Int, 4), new SqlParameter("@CJ006", SqlDbType.NVarChar, 50), new SqlParameter("@CJ007", SqlDbType.NVarChar, 20), new SqlParameter("@CJ008", SqlDbType.NVarChar, 20), new SqlParameter("@CJ009", SqlDbType.NVarChar, 20), new SqlParameter("@CJ010", SqlDbType.NVarChar, 20) }; parameters [0].Value = model.CJ001; parameters [1].Value = model.CJ002; parameters [2].Value = model.CJ003; parameters [3].Value = model.CJ004; parameters [4].Value = model.CJ005; parameters [5].Value = model.CJ006; parameters [6].Value = model.CJ007; parameters [7].Value = model.CJ008; parameters [8].Value = model.CJ009; parameters [9].Value = model.CJ010; 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.StandardAuditFivCJEntity _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.StandardAuditFivCJEntity _cd, string logins) { return(_dal.Save(table, _cd, logins)); }
/// <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.StandardAuditFivCJEntity _cf, string logins, List <string> strList) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); edit_pqcf(SQLString, strSql, _cf); SQLString.Add(Drity.DrityOfComparation("R_489", "电脑雕刻生产首件样审核确认记录表(R_489)", logins, Drity.GetDt( ), _cf.CJ001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑"), null); MulaolaoLibrary.StandardAuditFivCKEntity _ce = new MulaolaoLibrary.StandardAuditFivCKEntity( ); _ce.CK001 = _cf.CJ001; for (int i = 0; i < table.Rows.Count; i++) { _ce.CK002 = table.Rows [i] ["CK002"].ToString( ); _ce.CK003 = table.Rows [i] ["CK003"].ToString( ); _ce.CK004 = table.Rows [i] ["CK004"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["CK005"].ToString( ))) { _ce.CK005 = null; } else { _ce.CK005 = Convert.ToDateTime(table.Rows [i] ["CK005"]); } if (string.IsNullOrEmpty(table.Rows [i] ["CK006"].ToString( ))) { _ce.CK006 = null; } else { _ce.CK006 = Convert.ToDateTime(table.Rows [i] ["CK006"]); } _ce.CK007 = table.Rows [i] ["CK007"].ToString( ); _ce.CK008 = table.Rows [i] ["CK008"].ToString( ); _ce.CK009 = table.Rows [i] ["CK009"].ToString( ); _ce.CK010 = table.Rows [i] ["CK010"].ToString( ); _ce.CK011 = table.Rows [i] ["CK011"].ToString( ); _ce.CK012 = table.Rows [i] ["CK012"].ToString( ); _ce.CK013 = table.Rows [i] ["CK013"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["CK014"].ToString( ))) { _ce.CK014 = null; } else { _ce.CK014 = Convert.ToDateTime(table.Rows [i] ["CK014"]); } _ce.CK015 = table.Rows [i] ["CK015"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["CK016"].ToString( ))) { _ce.CK016 = null; } else { _ce.CK016 = Convert.ToDateTime(table.Rows [i] ["CK016"]); } _ce.CK017 = table.Rows [i] ["CK017"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["CK018"].ToString( ))) { _ce.CK018 = null; } else { _ce.CK018 = Convert.ToDateTime(table.Rows [i] ["CK018"]); } _ce.CK021 = table.Rows [i] ["CK021"].ToString( ); _ce.CK022 = table.Rows [i] ["CK022"].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> /// 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.StandardAuditFivCJEntity _cf, string logins) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); _cf.CJ001 = getOddNum( ); add_pqcf(SQLString, strSql, _cf); SQLString.Add(Drity.DrityOfComparation("R_484", "动力段生产首件量.检具审核确认记录表(R_484)", logins, Drity.GetDt( ), _cf.CJ001, strSql.ToString( ).Replace("'", "''"), "新增", "新增"), null); MulaolaoLibrary.StandardAuditFivCKEntity _ce = new MulaolaoLibrary.StandardAuditFivCKEntity( ); _ce.CK001 = _cf.CJ001; for (int i = 0; i < table.Rows.Count; i++) { _ce.CK002 = table.Rows [i] ["CK002"].ToString( ); _ce.CK003 = table.Rows [i] ["CK003"].ToString( ); _ce.CK004 = table.Rows [i] ["CK004"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["CK005"].ToString( ))) { _ce.CK005 = null; } else { _ce.CK005 = Convert.ToDateTime(table.Rows [i] ["CK005"]); } if (string.IsNullOrEmpty(table.Rows [i] ["CK006"].ToString( ))) { _ce.CK006 = null; } else { _ce.CK006 = Convert.ToDateTime(table.Rows [i] ["CK006"]); } _ce.CK007 = table.Rows [i] ["CK007"].ToString( ); _ce.CK008 = table.Rows [i] ["CK008"].ToString( ); _ce.CK009 = table.Rows [i] ["CK009"].ToString( ); _ce.CK010 = table.Rows [i] ["CK010"].ToString( ); _ce.CK011 = table.Rows [i] ["CK011"].ToString( ); _ce.CK012 = table.Rows [i] ["CK012"].ToString( ); _ce.CK013 = table.Rows [i] ["CK013"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["CK014"].ToString( ))) { _ce.CK014 = null; } else { _ce.CK014 = Convert.ToDateTime(table.Rows [i] ["CK014"]); } _ce.CK015 = table.Rows [i] ["CK015"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["CK016"].ToString( ))) { _ce.CK016 = null; } else { _ce.CK016 = Convert.ToDateTime(table.Rows [i] ["CK016"]); } _ce.CK017 = table.Rows [i] ["CK017"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["CK018"].ToString( ))) { _ce.CK018 = null; } else { _ce.CK018 = Convert.ToDateTime(table.Rows [i] ["CK018"]); } _ce.CK021 = table.Rows [i] ["CK021"].ToString( ); _ce.CK022 = table.Rows [i] ["CK022"].ToString( ); add_pqcg(SQLString, strSql, _ce, logins); } return(SqlHelper.ExecuteSqlTran(SQLString)); }