void add_pqna(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.CustomerrecordNAEntity model) { strSql = new StringBuilder( ); strSql.Append("insert into R_PQNA("); strSql.Append("NA001,NA002,NA003,NA004,NA005,NA006,NA007,NA008,NA009)"); strSql.Append(" values ("); strSql.Append("@NA001,@NA002,@NA003,@NA004,@NA005,@NA006,@NA007,@NA008,@NA009)"); SqlParameter [] parameters = { new SqlParameter("@NA001", SqlDbType.NVarChar, 20), new SqlParameter("@NA002", SqlDbType.NVarChar, 20), new SqlParameter("@NA003", SqlDbType.NVarChar, 20), new SqlParameter("@NA004", SqlDbType.NVarChar, 20), new SqlParameter("@NA005", SqlDbType.NVarChar, 20), new SqlParameter("@NA006", SqlDbType.NVarChar, 20), new SqlParameter("@NA007", SqlDbType.NVarChar, 20), new SqlParameter("@NA008", SqlDbType.NVarChar, 50), new SqlParameter("@NA009", SqlDbType.NVarChar, 20) }; parameters [0].Value = model.NA001; parameters [1].Value = model.NA002; parameters [2].Value = model.NA003; parameters [3].Value = model.NA004; parameters [4].Value = model.NA005; parameters [5].Value = model.NA006; parameters [6].Value = model.NA007; parameters [7].Value = model.NA008; parameters [8].Value = model.NA009; SQLString.Add(strSql, parameters); }
/// <summary> /// save data to r_pqn,r_pqna /// </summary> /// <param name="model"></param> /// <param name="table"></param> /// <param name="strList"></param> /// <param name="logins"></param> /// <returns></returns> public bool Save(MulaolaoLibrary.CustomerrecordEntity model, DataTable table, string logins) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); model.KH01 = getOddNum( ); add_pqn(SQLString, strSql, model); SQLString.Add(Drity.DrityOfComparation("R_369", "客户信息传递记录表(R_369)", logins, Drity.GetDt( ), model.KH01, strSql.ToString( ).Replace("'", "''"), "新增", "增加"), null); MulaolaoLibrary.CustomerrecordNAEntity _na = new MulaolaoLibrary.CustomerrecordNAEntity( ); _na.NA001 = model.KH01; for (int i = 0; i < table.Rows.Count; i++) { _na.NA002 = table.Rows [i] ["NA002"].ToString( ); _na.NA003 = table.Rows [i] ["NA003"].ToString( ); _na.NA004 = table.Rows [i] ["NA004"].ToString( ); _na.NA005 = table.Rows [i] ["NA005"].ToString( ); _na.NA006 = table.Rows [i] ["NA006"].ToString( ); _na.NA007 = table.Rows [i] ["NA007"].ToString( ); _na.NA008 = table.Rows [i] ["NA008"].ToString( ); _na.NA009 = table.Rows [i] ["NA009"].ToString( ); add_pqna(SQLString, strSql, _na); } return(SqlHelper.ExecuteSqlTran(SQLString)); }
void delete_pqna(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.CustomerrecordNAEntity model) { strSql = new StringBuilder( ); strSql.Append("DELETE FROM R_PQNA "); strSql.AppendFormat("WHERE idx={0}", model.idx); SQLString.Add(strSql, null); }
public R_FrmCustomerrecord( ) { InitializeComponent(); _kh = new MulaolaoLibrary.CustomerrecordEntity( ); _na = new MulaolaoLibrary.CustomerrecordNAEntity( ); _bll = new MulaolaoBll.Bll.CustomerrecordBll( ); tableView = new DataTable( ); lab.Visible = false; GridViewMoHuSelect.SetFilter(gridView1); GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { this.gridView1 }); UserInfoMation.tableName = this.Name; }
/// <summary> /// edit data to r_pqn,r_pqna /// </summary> /// <param name="model"></param> /// <param name="table"></param> /// <param name="logins"></param> /// <param name="strList"></param> /// <returns></returns> public bool Edit(MulaolaoLibrary.CustomerrecordEntity model, DataTable table, string logins, List <string> strList) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); edit_pqn(SQLString, strSql, model); SQLString.Add(Drity.DrityOfComparation("R_369", "客户信息传递记录表(R_369)", logins, Drity.GetDt( ), model.KH01, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑"), null); MulaolaoLibrary.CustomerrecordNAEntity _na = new MulaolaoLibrary.CustomerrecordNAEntity( ); _na.NA001 = model.KH01; for (int i = 0; i < table.Rows.Count; i++) { _na.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( )); _na.NA002 = table.Rows [i] ["NA002"].ToString( ); _na.NA003 = table.Rows [i] ["NA003"].ToString( ); _na.NA004 = table.Rows [i] ["NA004"].ToString( ); _na.NA005 = table.Rows [i] ["NA005"].ToString( ); _na.NA006 = table.Rows [i] ["NA006"].ToString( ); _na.NA007 = table.Rows [i] ["NA007"].ToString( ); _na.NA008 = table.Rows [i] ["NA008"].ToString( ); _na.NA009 = table.Rows [i] ["NA009"].ToString( ); if (_na.idx < 1) { add_pqna(SQLString, strSql, _na); } else { edit_pqna(SQLString, strSql, _na); } } if (strList.Count > 0) { foreach (string s in strList) { _na.idx = Convert.ToInt32(s); delete_pqna(SQLString, strSql, _na); } } return(SqlHelper.ExecuteSqlTran(SQLString)); }
void edit_pqna(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.CustomerrecordNAEntity model) { strSql = new StringBuilder( ); strSql.Append("update R_PQNA set "); strSql.Append("NA001=@NA001,"); strSql.Append("NA002=@NA002,"); strSql.Append("NA003=@NA003,"); strSql.Append("NA004=@NA004,"); strSql.Append("NA005=@NA005,"); strSql.Append("NA006=@NA006,"); strSql.Append("NA007=@NA007,"); strSql.Append("NA008=@NA008,"); strSql.Append("NA009=@NA009 "); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@NA001", SqlDbType.NVarChar, 20), new SqlParameter("@NA002", SqlDbType.NVarChar, 20), new SqlParameter("@NA003", SqlDbType.NVarChar, 20), new SqlParameter("@NA004", SqlDbType.NVarChar, 20), new SqlParameter("@NA005", SqlDbType.NVarChar, 20), new SqlParameter("@NA006", SqlDbType.NVarChar, 20), new SqlParameter("@NA007", SqlDbType.NVarChar, 20), new SqlParameter("@NA008", SqlDbType.NVarChar, 50), new SqlParameter("@NA009", SqlDbType.NVarChar, 20), new SqlParameter("@idx", SqlDbType.Int, 4) }; parameters [0].Value = model.NA001; parameters [1].Value = model.NA002; parameters [2].Value = model.NA003; parameters [3].Value = model.NA004; parameters [4].Value = model.NA005; parameters [5].Value = model.NA006; parameters [6].Value = model.NA007; parameters [7].Value = model.NA008; parameters [8].Value = model.NA009; parameters [9].Value = model.idx; SQLString.Add(strSql, parameters); }