//子表数据查询
public List <Book.Model.T_Stock_InItems> GetModel(int headId)
{
List <Book.Model.T_Stock_InItems> list = new List <Model.T_Stock_InItems>();
SqlConnection co = SQLServerOpen();
SqlCommand cmd = new SqlCommand();
cmd.Connection = co;
cmd.CommandText = "select * from V_InItem_Book where HeadId = " + headId;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Book.Model.T_Stock_InItems item = new Model.T_Stock_InItems();
Book.Model.T_Base_Book book = new Model.T_Base_Book();
book.id = Convert.ToInt32(reader["BookId"]);
book.BookName = Convert.ToString(reader["BookName"]);
book.Author = Convert.ToString(reader["Author"]);
book.PressName = Convert.ToString(reader["PressName"]);
book.ISBN = Convert.ToString(reader["ISBN"]);
book.Price = Convert.ToDecimal(reader["Price"]);
book.Version = Convert.ToInt32(reader["Version"]);
item.Book = book;
item.HeadId = headId;
item.Discount = Convert.ToDecimal(reader["Discount"]);
item.Amount = Convert.ToInt32(reader["Amount"]);
list.Add(item);
}
co.Close();
return(list);
}
public Book.Model.T_Stock_In GetModel(int HeadId)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = connstring;
co.Open();
Book.Model.T_Stock_In stockIn = new Model.T_Stock_In();
//stockIn.Head.Id = HeadId;
stockIn.Head = null;
stockIn.Items = new List <Model.T_Stock_InItems>();
SqlCommand cm = new SqlCommand();
cm.CommandText = "select * from V_InItem_Book where headid = @headid";
cm.Parameters.AddWithValue("@headid", HeadId);
cm.Connection = co;
SqlDataReader dr = cm.ExecuteReader();
while (dr.Read())
{
Book.Model.T_Stock_InItems item = new Model.T_Stock_InItems();
item.HeadId = HeadId;
item.Id = Convert.ToInt32(dr["Id"]);
item.Discount = Convert.ToDecimal(dr["Discount"]);
Book.Model.T_Base_Book book = new Model.T_Base_Book();
book.Author = Convert.ToString(dr["Author"]);
book.BookName = Convert.ToString(dr["BookName"]);
book.Id = Convert.ToInt32(dr["BookId"]);
book.PressName = Convert.ToString(dr["PressName"]);
book.Price = Convert.ToDecimal(dr["Price"]);
book.SN = Convert.ToString(dr["SN"]);
book.Version = Convert.ToInt32(dr["Version"]);
item.BookId = book.Id;
item.Book = book;
item.Amount = Convert.ToInt32(dr["Amount"]);
stockIn.Items.Add(item);
}
dr.Close();
co.Close();
return(stockIn);
}
public ActionResult AddSave()
{
Model.T_Stock_In in_stock = new Model.T_Stock_In();
//获得表头数据
in_stock.Head = new book.Model.T_Stock_InHead();
in_stock.Head.Creater = Request.Form["StockName"];
in_stock.Head.CreateTime = Convert.ToDateTime(Request.Form["StockTime"]);
in_stock.Head.ProviderId = Convert.ToInt16(Request.Form["Provider.Id"]);
//获取详细内容表数据
in_stock.items = new List <Model.T_Stock_InItems>();
int i = 0;
while (Request.Form["items[" + i + "].item.BookName"] != null)
{
Model.T_Stock_InItems item = new Model.T_Stock_InItems();
item.BookId = Convert.ToInt32(Request.Form["items[" + i + "].item.Id"].Replace(",", ""));
item.Discount = Convert.ToDecimal(Request.Form["items[" + i + "].item.Discount"]);
item.Amount = Convert.ToInt32(Request.Form["items[" + i + "].item.Amount"]);
in_stock.items.Add(item);
i++;
}
BLL.T_Stock_InBLL bllIn = new BLL.T_Stock_InBLL();
bool result = bllIn.Add(in_stock);
if (result)
{
Response.Write("{\"statusCode\":\"200\",\"message\":\"操作成功\",\"navTabId\":\"bookmanager\",\"rel\":\"bookmanager\",\"callbackType\":\"closeCurrent\",\"forwardUrl\":\"\"}");
}
else
{
Response.Write("{\"statusCode\":\"300\",\"message\":\"操作失败\",\"navTabId\":\"bookmanager\",\"rel\":\"bookmanager\",\"callbackType\":\"closeCurrent\",\"forwardUrl\":\"\"}");
}
return(null);
}
