//子表数据查询
public List <Book.Model.T_Stock_OutItems> GetModel(int headId)
{
List <Book.Model.T_Stock_OutItems> list = new List <Model.T_Stock_OutItems>();
SqlConnection co = SQLServerOpen();
SqlCommand cmd = new SqlCommand();
cmd.Connection = co;
cmd.CommandText = "select * from v_outItem_book where HeadId = " + headId;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Book.Model.T_Stock_OutItems item = new Model.T_Stock_OutItems();
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_Out GetModel(int HeadId)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = connstring;
co.Open();
Book.Model.T_Stock_Out stockIn = new Model.T_Stock_Out();
//stockIn.Head.Id = HeadId;
stockIn.Head = null;
stockIn.Items = new List <Model.T_Stock_OutItems>();
SqlCommand cm = new SqlCommand();
cm.CommandText = "select * from V_OutItem_Book where headid = @headid";
cm.Parameters.AddWithValue("@headid", HeadId);
cm.Connection = co;
SqlDataReader dr = cm.ExecuteReader();
while (dr.Read())
{
Book.Model.T_Stock_OutItems item = new Model.T_Stock_OutItems();
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);
}
