/// <summary>
/// 审核采购订单
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int CKInDepot(string id, int userid)
{
PSSEntities db = new PSSEntities();
int fg = 1;
///以下开始事务操作
using (var tx = db.Database.BeginTransaction())
{
try
{
List <OtherInDepotDetail> prolist = db.OtherInDepotDetail.Where(s => s.OIDID.Equals(id)).ToList();
OtherInDepot st = db.OtherInDepot.FirstOrDefault(s => s.OIDID.Equals(id));
ObjectParameter para = new ObjectParameter("DD", "");
db.pro_order("InOutDepot", "IODNum", "RK", para);
string IODNum = para.Value.ToString();
//添加入库记录
db.InOutDepot.Add(new InOutDepot()
{
DepotID = st.DepotID, IODType = 1, IODNum = IODNum, IODDate = DateTime.Now, IODUser = userid, IODDesc = st.OIDDesc
});
db.SaveChanges();
int inod = db.InOutDepot.Max(i => i.IODID);
// db.InOutDepot.
foreach (OtherInDepotDetail item in prolist)
{
if (db.DepotStock.FirstOrDefault(p => p.DepotID.Equals(st.DepotID) && p.ProID == item.ProID) == null)
{//如果指定的仓库中不存在该商品
//【为这个仓库添加一个新商品】
db.DepotStock.Add(new DepotStock()
{
DepotID = st.DepotID, ProID = item.ProID, DSAmount = item.OIDDAmount, DSPrice = item.OIDDPrice
});
}
else
{//如果指定仓库存在这个商品，修改这个商品的库存
DepotStock ds = db.DepotStock.FirstOrDefault(d => d.ProID == item.ProID);
ds.DSAmount = item.OIDDAmount + ds.DSAmount;
}
//添加入库记录详情
db.InOutDepotDetail.Add(new InOutDepotDetail()
{
IODID = inod, ProID = item.ProID, IODDAmount = item.OIDDAmount, IODDPrice = item.OIDDPrice
});
}
st.OIDState = 1;
db.SaveChanges();
tx.Commit();
}
catch (Exception e)
{
tx.Rollback();
throw new Exception(e.Message);
}
}
return(fg);
}
/// <summary>
/// 审核报损单
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int CKInDepot(string id, int userid)
{
PSSEntities db = new PSSEntities();
int fg = 1;
///以下开始事务操作
using (var tx = db.Database.BeginTransaction())
{
try
{
Losts st = db.Losts.FirstOrDefault(s => s.LostID.Equals(id));
st.LostState = 1;
ObjectParameter para = new ObjectParameter("DD", "");
db.pro_order("InOutDepot", "IODNum", "RK", para);
string IODNum = para.Value.ToString();
//添加出库记录
db.InOutDepot.Add(new InOutDepot()
{
DepotID = st.DepotID, IODType = 2, IODNum = IODNum, IODDate = DateTime.Now, IODUser = userid, IODDesc = st.LostDesc
});
db.SaveChanges();
int inod = db.InOutDepot.Max(i => i.IODID);
List <LostDetail> list = db.LostDetail.Where(p => p.LostID.Equals(id)).ToList();//销售出库详单
foreach (LostDetail item in list)
{
if (db.DepotStock.FirstOrDefault(p => p.DepotID.Equals(st.DepotID) && p.ProID == item.ProID) == null)
{//如果指定的仓库中不存在该商品
throw new Exception("报损仓库不存在该商品，操作失败！");
}
else
{//如果指定仓库存在这个商品，修改这个商品的库存
DepotStock ds = db.DepotStock.FirstOrDefault(d => d.ProID == item.ProID);
if (ds.DSAmount < item.LDAmount)
{
throw new Exception("商品库存小于报损数量，操作失败！");
}
ds.DSAmount = ds.DSAmount - item.LDAmount;
}
//添加入库记录详情
db.InOutDepotDetail.Add(new InOutDepotDetail()
{
IODID = inod, ProID = item.ProID, IODDAmount = item.LDAmount, IODDPrice = item.LDPrice
});
}
db.SaveChanges();
tx.Commit();
}
catch (Exception e)
{
tx.Rollback();
throw new Exception(e.Message);
}
}
return(fg);
}
/// <summary>
/// 删除供应商
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int Delete(string id)
{
PSSEntities db = new PSSEntities();
db.ProductLend.Remove(db.ProductLend.FirstOrDefault(p => p.PPID == id));
return(db.SaveChanges());
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static int EditPwd(Users user)
{
PSSEntities db = new PSSEntities();
db.Entry <Users>(user).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges());
}
/// <summary>
/// 修改【---事务---】
/// </summary>
/// <param name="dp"></param>
/// <returns></returns>
public static int EdiStocks(PayOffs dep, List <PayOffDetail> list)
{
PSSEntities db = new PSSEntities();
int fg = 1;
///以下开始事务操作
using (var tx = db.Database.BeginTransaction())
{
try
{
//将要修改的创建人找回来，避免修改时没有创建人
PayOffs st = db.PayOffs.FirstOrDefault(p => p.POID == dep.POID);
st.DepotID = dep.DepotID;
st.POState = dep.POState;
st.PODesc = dep.PODesc;
db.PayOffDetail.RemoveRange(db.PayOffDetail.Where(p => p.POID == dep.POID));
if (list != null)
{
db.PayOffDetail.AddRange(list);
}
db.SaveChanges();
tx.Commit();
}
catch (Exception e)
{
fg = 0;
tx.Rollback();
throw new Exception(e.Message);
}
}
return(fg);
}
/// <summary>
/// 删除客户信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int Delete(string id)
{
PSSEntities db = new PSSEntities();
db.Customers.Remove(db.Customers.FirstOrDefault(c => c.CusID == id));
return(db.SaveChanges());
}
/// <summary>
/// 添加
/// </summary>
/// <param name="cus"></param>
/// <returns></returns>
public static int Add(Customers cus)
{
PSSEntities db = new PSSEntities();
db.Customers.Add(cus);
return(db.SaveChanges());
}
/// <summary>
/// 修改销售退货单
/// </summary>
/// <param name="qp"></param>
/// <param name="list"></param>
/// <returns></returns>
internal static int EditStocks(SaleReturn qp, List <SaleReturnDetail> list)
{
PSSEntities db = new PSSEntities();
int fg = 1;
using (var tx = db.Database.BeginTransaction())
{
try
{
SaleReturn c = db.SaleReturn.FirstOrDefault(p => p.SRID.Equals(qp.SRID));
c.CusID = qp.CusID;
c.DepotID = qp.DepotID;
c.SDID = qp.SDID;
c.SRDate = qp.SRDate;
c.SRDesc = qp.SRDesc;
db.SaleReturnDetail.RemoveRange(db.SaleReturnDetail.Where(s => s.SRID.Equals(qp.SRID)));
if (list != null)
{
db.SaleReturnDetail.AddRange(list);
}
db.SaveChanges();
tx.Commit();
}
catch (Exception ex)
{
fg = 0;
tx.Rollback();
throw new Exception(ex.Message);
}
}
return(fg);
}
/// <summary>
/// 修改【---事务---】
/// </summary>
/// <param name="dp"></param>
/// <returns></returns>
public static int EdiStocks(Devolves dep, List <DevolveDetail> list)
{
PSSEntities db = new PSSEntities();
int fg = 1;
///以下开始事务操作
using (var tx = db.Database.BeginTransaction())
{
try
{
//将要修改的创建人找回来，避免修改时没有创建人
Devolves st = db.Devolves.FirstOrDefault(p => p.DevID == dep.DevID);
st.DevInID = dep.DevInID; //调入仓库
st.DevOutID = dep.DevOutID; //调出仓库
st.DevDesc = dep.DevDesc; //描述
st.DevDate = dep.DevDate; //操作时间
db.DevolveDetail.RemoveRange(db.DevolveDetail.Where(p => p.DevID == dep.DevID)); //删除详单
if (list != null)
{
db.DevolveDetail.AddRange(list); //如果添加的详单不为空的话，那么就添加详单
}
db.SaveChanges();
tx.Commit();
}
catch (Exception e)
{
fg = 0;
tx.Rollback();
throw new Exception(e.Message);
}
}
return(fg);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int DelDepots(string id)
{
PSSEntities db = new PSSEntities();
db.Depots.Remove(db.Depots.FirstOrDefault(d => d.DepotID.Equals(id)));
return(db.SaveChanges());
}
/// <summary>
/// 添加仓库
/// </summary>
/// <param name="dep"></param>
/// <returns></returns>
public static int AddDepots(Depots dep)
{
PSSEntities db = new PSSEntities();
db.Depots.Add(dep);
return(db.SaveChanges());
}
/// <summary>
/// 修改角色的权限
/// </summary>
/// <param name="roleid">角色ID</param>
/// <param name="pds">权限ID集合</param>
/// <returns></returns>
public static int EditRolePopedoms(int roleid, List <int?> pds)
{
PSSEntities db = new PSSEntities();
int fg = 1;
using (var tx = db.Database.BeginTransaction())
{
try
{
db.PopedomRole.RemoveRange(db.PopedomRole.Where(s => s.RoleID == roleid));
for (int i = 0; i < pds.Count; i++)
{
db.PopedomRole.Add(new PopedomRole()
{
RoleID = roleid, PopID = pds[i]
});
}
db.SaveChanges();
tx.Commit();
}
catch (Exception ex)
{
fg = 0;
tx.Rollback();
throw new Exception(ex.Message);
}
}
return(fg);
}
/// <summary>
/// 删除客户等级
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int Delete(int id)
{
PSSEntities db = new PSSEntities();
db.CustomerLevel.Remove(db.CustomerLevel.FirstOrDefault(c => c.CLID == id));
return(db.SaveChanges());
}
/// <summary>
/// 添加客户等级
/// </summary>
/// <param name="cusl"></param>
/// <returns></returns>
public static int Add(CustomerLevel cusl)
{
PSSEntities db = new PSSEntities();
db.CustomerLevel.Add(cusl);
return(db.SaveChanges());
}
/// <summary>
/// 修改【---事务---】
/// </summary>
/// <param name="dp"></param>
/// <returns></returns>
public static int EdiStocks(CheckDepot dep, List <CheckDepotDetail> list)
{
PSSEntities db = new PSSEntities();
int fg = 1;
///以下开始事务操作
using (var tx = db.Database.BeginTransaction())
{
try
{
//将要修改的创建人找回来，避免修改时没有创建人
CheckDepot st = db.CheckDepot.FirstOrDefault(p => p.CDID == dep.CDID);
st.DepotID = dep.DepotID; //盘点仓库
st.CDDate = dep.CDDate; //盘点时间
st.CDDesc = dep.CDDesc; //备注
db.CheckDepotDetail.RemoveRange(db.CheckDepotDetail.Where(p => p.CDID == dep.CDID)); //删除详单
if (list != null)
{
db.CheckDepotDetail.AddRange(list); //如果添加的详单不为空的话，那么就添加详单
}
db.SaveChanges();
tx.Commit();
}
catch (Exception e)
{
fg = 0;
tx.Rollback();
throw new Exception(e.Message);
}
}
return(fg);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public static int Edit(ProductUnit pro)
{
PSSEntities db = new PSSEntities();
db.Entry <ProductUnit>(pro).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges());
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int Delete(int id)
{
PSSEntities db = new PSSEntities();
db.ProductUnit.Remove(db.ProductUnit.FirstOrDefault(p => p.PUID == id));
return(db.SaveChanges());
}
/// <summary>
/// 修改仓库
/// </summary>
/// <param name="dp"></param>
/// <returns></returns>
public static int EditDepot(Depots dp)
{
PSSEntities db = new PSSEntities();
db.Entry <Depots>(dp).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges());
}
public void OnActionExecuted(ActionExecutedContext filterContext)
{
PSSEntities db = new PSSEntities();
//写入日志
RouteValueDictionary rvd = filterContext.RouteData.Values;
string area = rvd["area"] as string; //域名
string action = rvd["action"] as string; //action名字
string controller = rvd["controller"] as string; //控制器名字
string username = filterContext.HttpContext.Session["name"] as string;
if (area == null)
{
area = "NoArea";
}
if (username == null)
{
username = "******";
}
try
{
SystemLog sl = new SystemLog();
sl.time = DateTime.Now;
string value = "用户：" + username + "进行" + OpcrateName + "操作!";
sl.value = value;
sl.islog = 1;
db.SystemLog.Add(sl);
db.SaveChanges();
}
catch (Exception ex)
{
filterContext.HttpContext.Response.Write(ex.Message);
}
}
public static int Add(Roles r)
{
PSSEntities db = new PSSEntities();
db.Roles.Add(r);
return(db.SaveChanges());
}
/// <summary>
/// 添加销售退货单
/// </summary>
/// <param name="qp"></param>
/// <param name="list"></param>
/// <returns></returns>
internal static int AddStocks(SaleReturn qp, List <SaleReturnDetail> list)
{
PSSEntities db = new PSSEntities();
int fg = 1;
using (var tx = db.Database.BeginTransaction())
{
try
{
db.SaleReturn.Add(qp);
if (list != null)
{
db.SaleReturnDetail.AddRange(list);
}
db.SaveChanges();
tx.Commit();
}
catch (Exception ex)
{
fg = 0;
tx.Rollback();
throw new Exception(ex.Message);
}
}
return(fg);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="dep"></param>
/// <returns></returns>
public static int AddStockDetail(StockDetail dep)
{
PSSEntities db = new PSSEntities();
db.StockDetail.Add(dep);
return(db.SaveChanges());
}
/// <summary>
/// 修改客户信息
/// </summary>
/// <param name="cus"></param>
/// <returns></returns>
public static int Edit(Customers cus)
{
PSSEntities db = new PSSEntities();
db.Entry <Customers>(cus).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges());
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int DelStockDetail(int id)
{
PSSEntities db = new PSSEntities();
db.StockDetail.Remove(db.StockDetail.FirstOrDefault(d => d.SDetailID == id));
return(db.SaveChanges());
}
/// <summary>
/// 添加【---事务---】
/// </summary>
/// <param name="dep"></param>
/// <returns></returns>
public static int AddStocks(PayOffs dep, List <PayOffDetail> list)
{
PSSEntities db = new PSSEntities();
int fg = 1;
using (var tx = db.Database.BeginTransaction())
{
try
{
db.PayOffs.Add(dep);
if (list != null)
{
db.PayOffDetail.AddRange(list);
}
db.SaveChanges();
tx.Commit();
}
catch (Exception e)
{
fg = 0;
tx.Rollback();
throw new Exception(e.Message);
}
}
return(fg);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="dp"></param>
/// <returns></returns>
public static int EdiStockDetail(StockDetail dp)
{
PSSEntities db = new PSSEntities();
db.Entry <StockDetail>(dp).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges());
}
/// <summary>
/// 修改用户角色
/// </summary>
/// <returns></returns>
public static int EditUserRole(int userid, List <int?> list)
{
PSSEntities db = new PSSEntities();
int fs = 1;
using (var tx = db.Database.BeginTransaction())
{
try
{
db.UsersRole.RemoveRange(db.UsersRole.Where(s => s.UsersID == userid));
for (int i = 0; i < list.Count; i++)
{
db.UsersRole.Add(new UsersRole()
{
UsersID = userid, RoleID = list[i]
});
}
db.SaveChanges();
tx.Commit();
}
catch (Exception ex)
{
fs = 0;
tx.Rollback();
throw new Exception(ex.Message);
}
}
return(fs);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public static int Add(ProductUnit pro)
{
PSSEntities db = new PSSEntities();
db.ProductUnit.Add(pro);
return(db.SaveChanges());
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="u">用户对象</param>
/// <returns></returns>
public static int Add(Users u)
{
PSSEntities db = new PSSEntities();
db.Users.Add(u);
return(db.SaveChanges());
}
/// <summary>
/// 添加供货商
/// </summary>
/// <param name="pd"></param>
/// <returns></returns>
public static int Add(ProductLend pd)
{
PSSEntities db = new PSSEntities();
db.ProductLend.Add(pd);
return(db.SaveChanges());
}