/// <summary> /// 增加 /// </summary> /// <param name="table"></param> /// <param name="model"></param> /// <returns></returns> public bool Add(DataTable table, MulaolaoLibrary.InvenAdSheetINAEntity model) { Dictionary <object, object> SQLString = new Dictionary <object, object> ( ); model.INA001 = getCode( ); addHeader(model, SQLString); MulaolaoLibrary.InvenAdSheetINBEntity body = new MulaolaoLibrary.InvenAdSheetINBEntity( ); body.INB001 = model.INA001; foreach (DataRow row in table.Rows) { body.INB002 = row ["INB002"].ToString( ); body.INB003 = row ["INB003"].ToString( ); body.INB004 = row ["INB004"].ToString( ); body.INB005 = row ["INB005"].ToString( ); body.INB006 = row ["INB006"].ToString( ); body.INB007 = string.IsNullOrEmpty(row ["INB007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB007"]); body.INB008 = row ["INB008"].ToString( ); body.INB009 = row ["INB009"].ToString( ); body.INB010 = string.IsNullOrEmpty(row ["INB010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB010"]); body.INB011 = string.IsNullOrEmpty(row ["INB011"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB011"]); body.INB012 = string.IsNullOrEmpty(row ["INB012"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB012"]); body.INB013 = string.IsNullOrEmpty(row ["INB013"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB013"]); body.INB014 = row ["INB014"].ToString( ); body.INB015 = string.IsNullOrEmpty(row ["INB015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB015"]); body.INB016 = row ["INB016"].ToString( ); addBody(body, SQLString); } return(SqlHelper.ExecuteSqlTran(SQLString)); }
void editHeader(MulaolaoLibrary.InvenAdSheetINAEntity model, Dictionary <object, object> SQLString) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_INA SET "); strSql.Append("INA003=@INA003 "); strSql.Append(" WHERE INA001=@INA001"); SqlParameter [] parameters = { new SqlParameter("@INA001", SqlDbType.NVarChar, 20), new SqlParameter("@INA003", SqlDbType.NVarChar, 20) }; parameters [0].Value = model.INA001; parameters [1].Value = model.INA003; SQLString.Add(strSql, parameters); }
public FormInvenAdSheet( ) { InitializeComponent( ); _bll = new MulaolaoBll.Bll.InvenAdSheetBll( ); model = new MulaolaoLibrary.InvenAdSheetINAEntity( ); body = new MulaolaoLibrary.InvenAdSheetINBEntity( ); toolStrip1.Items.Remove(toolPrint); toolStrip1.Items.Remove(toolExport); toolStrip1.Items.Remove(toolLibrary); toolStrip1.Items.Remove(toolStorage); toolStrip1.Items.Remove(toolcopy); controlUnEnable( ); dt = MulaolaoBll.Drity.GetDt( ); label45.Visible = false; }
/// <summary> /// 编辑 /// </summary> /// <param name="table"></param> /// <param name="model"></param> /// <param name="strList"></param> /// <returns></returns> public bool Edit(DataTable table, MulaolaoLibrary.InvenAdSheetINAEntity model, List <string> strList) { Dictionary <object, object> SQLString = new Dictionary <object, object> ( ); editHeader(model, SQLString); MulaolaoLibrary.InvenAdSheetINBEntity body = new MulaolaoLibrary.InvenAdSheetINBEntity( ); body.INB001 = model.INA001; foreach (DataRow row in table.Rows) { body.id = string.IsNullOrEmpty(row ["id"].ToString( )) == true ? 0 : Convert.ToInt32(row ["id"]); body.INB002 = row ["INB002"].ToString( ); body.INB003 = row ["INB003"].ToString( ); body.INB004 = row ["INB004"].ToString( ); body.INB005 = row ["INB005"].ToString( ); body.INB006 = row ["INB006"].ToString( ); body.INB007 = string.IsNullOrEmpty(row ["INB007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB007"]); body.INB008 = row ["INB008"].ToString( ); body.INB009 = row ["INB009"].ToString( ); body.INB010 = string.IsNullOrEmpty(row ["INB010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB010"]); body.INB011 = string.IsNullOrEmpty(row ["INB011"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB011"]); body.INB012 = string.IsNullOrEmpty(row ["INB012"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB012"]); body.INB013 = string.IsNullOrEmpty(row ["INB013"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB013"]); body.INB014 = row ["INB014"].ToString( ); body.INB015 = string.IsNullOrEmpty(row ["INB015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB015"]); body.INB016 = row ["INB016"].ToString( ); if (body.id <= 1) { addBody(body, SQLString); } else { editBody(body, SQLString); } } foreach (string s in strList) { deleteBody(s, SQLString); } return(SqlHelper.ExecuteSqlTran(SQLString)); }
void addHeader(MulaolaoLibrary.InvenAdSheetINAEntity model, Dictionary <object, object> SQLString) { StringBuilder strSql = new StringBuilder( ); strSql.Append("insert into R_INA("); strSql.Append("INA001,INA003,INA004,INA005)"); strSql.Append(" values ("); strSql.Append("@INA001,@INA003,@INA004,@INA005)"); SqlParameter [] parameters = { new SqlParameter("@INA001", SqlDbType.NVarChar, 20), new SqlParameter("@INA003", SqlDbType.NVarChar, 20), new SqlParameter("@INA004", SqlDbType.Date, 3), new SqlParameter("@INA005", SqlDbType.NVarChar, 20) }; parameters [0].Value = model.INA001; parameters [1].Value = model.INA003; parameters [2].Value = model.INA004; parameters [3].Value = model.INA005; SQLString.Add(strSql, parameters); }
/// <summary> /// 编辑 /// </summary> /// <param name="table"></param> /// <param name="model"></param> /// <param name="strList"></param> /// <returns></returns> public bool Edit(DataTable table, MulaolaoLibrary.InvenAdSheetINAEntity model, List <string> strList) { return(dal.Edit(table, model, strList)); }
/// <summary> /// 增加 /// </summary> /// <param name="table"></param> /// <param name="model"></param> /// <returns></returns> public bool Add(DataTable table, MulaolaoLibrary.InvenAdSheetINAEntity model) { return(dal.Add(table, model)); }