public bool AddSave(Book.Model.T_Stock_Out inStock)
{
decimal totalMoney = 0;
foreach (Book.Model.T_Stock_OutItems item in inStock.Items)
{
totalMoney += item.Amount * item.Discount * item.Price;
}
inStock.Head.TotalMoney = totalMoney;
DAL.T_Stock_Out dal = new DAL.T_Stock_Out();
return(dal.AddSave(inStock));
}
public bool AddSave(Book.Model.T_Stock_Out outStock)
{
SqlConnection co = SQLServerOpen();
SqlTransaction tran = co.BeginTransaction();
SqlCommand cmd = new SqlCommand();
cmd.Connection = co;
cmd.Transaction = tran;
try
{
cmd.Parameters.Clear();
cmd.CommandText = "insert into t_stock_outhead (UserName,CreateTime,TotalMoney,CustomerId) "
+ "values (@UserName,@CreateTime,@TotalMoney,@CustomerId);select @@identity";
cmd.Parameters.AddWithValue("@UserName", outStock.Head.UserName);
cmd.Parameters.AddWithValue("@CreateTime", outStock.Head.CreateTime);
cmd.Parameters.AddWithValue("@CustomerId", outStock.Head.CustomerId);
cmd.Parameters.AddWithValue("@TotalMoney", outStock.Head.TotalMoney);
object result = cmd.ExecuteScalar();
int headId = Convert.ToInt32(result);
foreach (Book.Model.T_Stock_OutItems item in outStock.Items)
{
cmd.Parameters.Clear();
cmd.CommandText = "insert into t_stock_outitems (HeadId,BookId,Amount,Discount) " +
"values (@HeadId,@BookId,@Amount,@Discount)";
cmd.Parameters.AddWithValue("@HeadId", headId);
cmd.Parameters.AddWithValue("@BookId", item.BookId);
cmd.Parameters.AddWithValue("@Amount", item.Amount);
cmd.Parameters.AddWithValue("@Discount", item.Discount);
cmd.ExecuteNonQuery();
}
tran.Commit();
return(true);
}
catch (Exception ex)
{
tran.Rollback();
}
finally
{
co.Close();
}
return(false);
}
public JsonResult GetModel2(int HeadId)
{
Book.BLL.T_Stock_Out bll = new BLL.T_Stock_Out();
Book.Model.T_Stock_Out stockIn = bll.GetModel(HeadId);
List <Book.Model.T_Stock_OutItems> lst = stockIn.Items;
List <Book.Model.EditItem> l = new List <Book.Model.EditItem>();
foreach (Book.Model.T_Stock_OutItems it in lst)
{
Book.Model.EditItem ed = new Model.EditItem();
ed.Id = it.Id;
ed.Amount = it.Amount;
ed.BookId = it.BookId;
ed.BookName = it.Book.BookName;
ed.Discount = it.Discount;
ed.Price = it.Book.Price;
ed.SN = it.Book.SN;
ed.PressName = it.Book.PressName;
l.Add(ed);
}
return(Json(l));
}
public JsonResult GetModel(int HeadId)
{
Book.BLL.T_Stock_Out bll = new BLL.T_Stock_Out();
Book.Model.T_Stock_Out stockIn = bll.GetModel(HeadId);
return(Json(stockIn));
}
