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);
}
