private void AddBalanceStock(SqlTransaction trans) { this.UpdateBalanceStockDataSource(); DataTable dataTable = this.ViewState["resource"] as DataTable; for (int i = 0; i < dataTable.Rows.Count; i++) { DataRow dataRow = dataTable.Rows[i]; BalanceStockModel balanceStockModel = new BalanceStockModel(); balanceStockModel.Id = Guid.NewGuid().ToString(); balanceStockModel.BalanceId = this.ViewState["BalanceId"].ToString(); balanceStockModel.PurchaseId = dataRow["psid"].ToString(); balanceStockModel.ArrivaledQuantity = Convert.ToDecimal(dataRow["ThisTimeArrivaledQuantity"].ToString()); this.balanceStockBll.Add(trans, balanceStockModel); } }
public int Add(SqlTransaction trans, BalanceStockModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into Con_Balance_Stock("); builder.Append("BalanceStockId,BalanceId,PurchaseId,ArrivaledQuantity)"); builder.Append(" values ("); builder.Append("@id,@BalanceId,@PurchaseId,@ArrivaledQuantity)"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@id", SqlDbType.NVarChar, 70), new SqlParameter("@BalanceId", SqlDbType.NVarChar, 0x40), new SqlParameter("@PurchaseId", SqlDbType.NVarChar, 70), new SqlParameter("@ArrivaledQuantity", SqlDbType.Decimal) }; commandParameters[0].Value = model.Id; commandParameters[1].Value = model.BalanceId; commandParameters[2].Value = model.PurchaseId; commandParameters[3].Value = model.ArrivaledQuantity; if (trans == null) { return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters)); } return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters)); }
public void Add(SqlTransaction trans, BalanceStockModel model) { this.dal.Add(trans, model); }
public void Add(BalanceStockModel model) { this.dal.Add(null, model); }