public JsonResult AddSave(Book.Model.T_Stock_OutHead Head, Book.Model.T_Stock_OutItems[] Items)
{
Book.BLL.T_Stock_Out bll = new BLL.T_Stock_Out();
Book.Model.T_Stock_Out inStock = new Model.T_Stock_Out();
inStock.Head = Head;
inStock.Items = Items.ToList();
bll.AddSave(inStock);
return(Json(1));
}
public bool Add(Model.T_Stock_Out inStock)
{
//throw new NotImplementedException();
decimal totalMoney = 0;
foreach (Book.Model.T_Stock_OutItems item in inStock.Items)
{
totalMoney += item.Amount * item.Discount * item.Price;
}
inStock.Head.TotalMoney = totalMoney;
return(dal.Add(inStock));
}
public JsonResult AddSave(Book.Model.T_Stock_OutHead Head, Book.Model.T_Stock_OutItems[] Items)
{
Book.BLL.T_Stock_Out bll = new BLL.T_Stock_Out();
Book.Model.T_Stock_Out inStock = new Model.T_Stock_Out();
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_OutHead Head, Book.Model.T_Stock_OutItems[] Items)
{
Book.BLL.T_Stock_Out bll = new BLL.T_Stock_Out();
String[] tmp = new String[1];
tmp[0] = "" + Head.Id;
bll.Delete(tmp);
Book.Model.T_Stock_Out inStock = new Model.T_Stock_Out();
inStock.Head = Head;
inStock.Items = Items.ToList();
bool result = bll.Add(inStock);
return(Json(new Book.Model.Message()
{
Code = 1, Content = "保存成功"
}));
}
public bool Add(Model.T_Stock_Out inStock)
{
//throw new NotImplementedException();
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_Outhead (UserName,CreateTime,CustomerId,TotalMoney) values (@UserName,@CreateTime,@ProviderId,@TotalMoney); select @@identity";
cm.Parameters.AddWithValue("@UserName", inStock.Head.UserName);
cm.Parameters.AddWithValue("@ProviderId", inStock.Head.CustomerId);
cm.Parameters.AddWithValue("@CreateTime", inStock.Head.CreateTime);
cm.Parameters.AddWithValue("@TotalMoney", inStock.Head.TotalMoney);
object result = cm.ExecuteScalar();
int headId = Convert.ToInt32(result);
foreach (Book.Model.T_Stock_OutItems item in inStock.Items)
{
cm.Parameters.Clear();
cm.CommandText = "insert into T_Stock_Outitems (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 ex)
{
tran.Rollback();//遇到错误，回滚
}
finally
{
co.Close();
}
return(false);
}
public List <Book.Model.T_Stock_Out> GetList(int CurrentPage, int PageSize, String search = "")
{
SqlConnection co = new SqlConnection();
co.ConnectionString = connstring;
co.Open();
SqlCommand cm = new SqlCommand();
cm.Connection = co;
search = "'%" + search + "%'";
cm.CommandText = "select top " + PageSize + " * from [V_OutHead_Customer] where id not in (select top " + PageSize * (CurrentPage - 1) + " id from [V_OutHead_Customer] where (username like " + search + " or name like " + search + ")) and (username like " + search + " or name like " + search + ")";
SqlDataReader dr = cm.ExecuteReader();
List <Book.Model.T_Stock_Out> lst = new List <Model.T_Stock_Out>();
while (dr.Read())
{
Book.Model.T_Stock_Out outStock = new Model.T_Stock_Out();
outStock.Customer = new Model.T_Base_Customer();
Book.Model.T_Stock_OutHead head = new Model.T_Stock_OutHead();
outStock.Id = head.Id = Convert.ToInt32(dr["Id"]);
head.Customer = new Model.T_Base_Customer();
outStock.CreateTime = head.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
outStock.Customer.Id = head.Customer.Id = Convert.ToInt32(dr["CustomerId"]);
outStock.TotalMoney = head.TotalMoney = Convert.ToDecimal(dr["TotalMoney"]);
outStock.UserName = head.UserName = Convert.ToString(dr["UserName"]);
Book.Model.T_Base_Customer Customer = new Model.T_Base_Customer();
Customer.Id = Convert.ToInt32(dr["Id"]);
Customer.Name = Convert.ToString(dr["Name"]);
Customer.Tel = Convert.ToString(dr["Tel"]);
Customer.Fax = Convert.ToString(dr["Fax"]);
Customer.Memo = Convert.ToString(dr["Memo"]);
head.Customer = Customer;
outStock.Head = head;
outStock.Items = null;
lst.Add(outStock);
}
dr.Close();
co.Close();
return(lst);
}
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);
}
///分页实现过程
public List <Book.Model.T_Stock_Out> GetList(int pageNumber, int pageSize)
{
List <Book.Model.T_Stock_Out> list = new List <Model.T_Stock_Out>();
SqlConnection co = SQLServerOpen();
SqlCommand cmd = new SqlCommand();
cmd.Connection = co;
cmd.CommandText = "select top " + pageSize + " * from v_outhead_customer where Id not in(select top " + (pageNumber - 1) * pageSize + " Id from v_outhead_customer)";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Book.Model.T_Stock_Out item = new Model.T_Stock_Out();
Book.Model.T_Stock_OutHead head = new Model.T_Stock_OutHead();
Book.Model.T_Base_Customer customer = new Model.T_Base_Customer();
head.Id = Convert.ToInt32(reader["Id"]);
head.UserName = Convert.ToString(reader["UserName"]);
head.CreateTime = Convert.ToDateTime(reader["CreateTime"]);
head.TotalMoney = Convert.ToDecimal(reader["TotalMoney"]);
head.CustomerId = Convert.ToInt32(reader["CustomerId"]);
customer.Id = Convert.ToInt32(reader["CustomerId"]);
customer.CustomerName = Convert.ToString(reader["CustomerName"]);
customer.CustomerTel = Convert.ToString(reader["CustomerTel"]);
customer.CustomerPwd = Convert.ToString(reader["CustomerPwd"]);
customer.CustomerPostbox = Convert.ToString(reader["CustomerPostbox"]);
head.Customer = customer;
item.Head = head;
item.Items = null;
list.Add(item);
}
reader.Close();
co.Close();
return(list);
}
//查询全部
public List <Book.Model.T_Stock_Out> GetAll()
{
SqlConnection co = SQLServerOpen();
SqlCommand cmd = new SqlCommand();
cmd.Connection = co;
cmd.CommandText = "select * from V_InHead_Customer";
SqlDataReader reader = cmd.ExecuteReader();
List <Book.Model.T_Stock_Out> list = new List <Model.T_Stock_Out>();
while (reader.Read())
{
Book.Model.T_Stock_Out item = new Model.T_Stock_Out();
Book.Model.T_Stock_OutHead head = new Model.T_Stock_OutHead();
Book.Model.T_Base_Customer customer = new Model.T_Base_Customer();
head.Id = Convert.ToInt32(reader["Id"]);
head.UserName = Convert.ToString(reader["UserName"]);
head.CreateTime = Convert.ToDateTime(reader["CreateTime"]);
head.TotalMoney = Convert.ToDecimal(reader["TotalMoney"]);
head.CustomerId = Convert.ToInt32(reader["CustomerId"]);
customer.Id = Convert.ToInt32(reader["CustomerId"]);
customer.CustomerName = Convert.ToString(reader["CustomerName"]);
customer.CustomerTel = Convert.ToString(reader["CustomerTel"]);
customer.CustomerPwd = Convert.ToString(reader["CustomerPwd"]);
customer.CustomerPostbox = Convert.ToString(reader["CustomerPostbox"]);
head.Customer = customer;
item.Head = head;
item.Items = null;
list.Add(item);
}
reader.Close();
co.Close();
return(list);
}
