public JsonResult AddSave(Book.Model.T_Stock_InHead Head, Book.Model.T_Stock_InItems[] Items)
{
Book.BLL.T_Stock_In bll = new BLL.T_Stock_In();
Book.Model.T_Stock_In inStock = new Model.T_Stock_In();
inStock.Head = Head;
inStock.Items = Items.ToList();
bll.AddSave(inStock);
return(Json(1));
}
public ActionResult Edit(int Id)
{
int id = Id;
Book.BLL.T_Stock_In bll = new BLL.T_Stock_In();
Book.Model.T_Stock_InHead item = bll.GetHead(id);
ViewBag.item = item;
return(View());
}
public bool Add(Book.Model.T_Stock_InHead head, Book.Model.T_Stock_InItems[] items)
{
decimal totalMoney = 0;
foreach (Book.Model.T_Stock_InItems item in items)
{
totalMoney += item.Amount * item.Discount * 10;
}
head.TotalMoney = totalMoney;
return(dal.Add(head, items));
}
public JsonResult AddSave(Book.Model.T_Stock_InHead Head, Book.Model.T_Stock_InItems[] Items)
{
Book.BLL.T_Stock_In bll = new BLL.T_Stock_In();
Book.Model.T_Stock_In inStock = new Model.T_Stock_In();
inStock.Head = Head;
inStock.Items = Items.ToList();
bool result = bll.Add(inStock);
return(Json(new Book.Model.Message()
{
Code = 1, Content = "保存成功"
}));
}
public JsonResult EditSave(Book.Model.T_Stock_InHead Head, Book.Model.T_Stock_InItems[] Items)
{
Book.BLL.T_Stock_In bll = new BLL.T_Stock_In();
String [] tmp = new String[1];
tmp[0] = "" + Head.Id;
bll.Delete(tmp);
Book.Model.T_Stock_In inStock = new Model.T_Stock_In();
inStock.Head = Head;
inStock.Items = Items.ToList();
bool result = bll.Add(inStock);
return(Json(new Book.Model.Message()
{
Code = 1, Content = "保存成功"
}));
}
public bool Add(Book.Model.T_Stock_InHead head, Book.Model.T_Stock_InItems[] items)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = connstring;
co.Open();
SqlTransaction tran = co.BeginTransaction();
SqlCommand cm = new SqlCommand();
cm.Connection = co;
cm.Transaction = tran;
try
{
cm.Parameters.Clear();
cm.CommandText = "insert into t_stock_inhead(UserName,CreateTime,ProviderId,TotalMoney) values (@UserName,@CreateTime,@ProviderId,@TotalMoney);select @@identity";
cm.Parameters.AddWithValue("@UserName", head.UserName);
cm.Parameters.AddWithValue("@ProviderId", head.ProviderId);
cm.Parameters.AddWithValue("@CreateTime", head.CreateTime);
cm.Parameters.AddWithValue("@TotalMoney", head.TotalMoney);
object result = cm.ExecuteScalar();
int headId = Convert.ToInt32(result);
foreach (Book.Model.T_Stock_InItems item in items)
{
cm.Parameters.Clear();
cm.CommandText = "insert into t_stock_initems(HeadId,BookId,Amount,Discount) values (@HeadId,@BookId,@Amount,@Discount)";
cm.Parameters.AddWithValue("@HeadId", headId);
cm.Parameters.AddWithValue("@BookId", item.BookId);
cm.Parameters.AddWithValue("@Amount", item.Amount);
cm.Parameters.AddWithValue("@Discount", item.Discount);
cm.ExecuteNonQuery();
}
tran.Commit();//提交
return(true);
}
catch (Exception e)
{
tran.Rollback();
}
finally
{
co.Close();
}
return(false);
}
public JsonResult AddSave(Book.Model.T_Stock_InHead head, Book.Model.T_Stock_InItems[] items)
{
//保存
Book.BLL.T_Stock_In bll = new BLL.T_Stock_In();
bool result = bll.Add(head, items);
if (result)
{
return(Json(new Book.Model.Message()
{
Code = 1, Content = "保存成功"
}));
}
else
{
return(Json(new Book.Model.Message()
{
Code = 0, Content = "保存失败"
}));
}
}
