public BaseDataPackage <string> DelSupplierProdPrice(List <DelThreePrimarykeys> data)
{
var result = new BaseDataPackage <string>();
erpsEntities db = new erpsEntities();
for (int i = 0; i < data.Count; i++)
{
var PdtID = data[i].Primary1.ToString();
var SupID = data[i].Primary2.ToString();
var Model = data[i].Primary3.ToString();
var list = db.msupplierprodprice.Where(c => c.PdtID == PdtID && c.SupID == SupID && c.Model == Model).FirstOrDefault();
db.msupplierprodprice.Remove(list);
}
try
{
db.SaveChanges();
result.Status = ApiStatusCode.OK;
result.Message = "删除成功";
return(result);
}
catch (Exception ex)
{
result.Message = "发生异常=>" + ex.Message;
result.Status = ApiStatusCode.EXCEPTION;
return(result);
}
}
public BaseDataPackage <mcustomer> GetCustomer()
{
var result = new BaseDataPackage <mcustomer>();
try
{
erpsEntities db = new erpsEntities();
var list = db.mcustomer.ToList();
if (list.Count > 0)
{
result.DataList = list;
result.Status = ApiStatusCode.OK;
result.Message = "查询成功";
return(result);
}
else
{
result.DataList = null;
result.Status = ApiStatusCode.FAIL;
result.Message = "暂无客户数据";
return(result);
}
}
catch (Exception ex)
{
result.Status = ApiStatusCode.EXCEPTION;
result.Message = "发生异常=>" + ex.Message;
return(result);
}
}
public IHttpActionResult GetPurOrderDtl_PurOrderNOList()
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
JavaScriptSerializer js = new JavaScriptSerializer();
string purOrder = request.Params["purOrderNOList"];
String[] purOrderArray = purOrder.Split(',');
List <Object> saleorderdtls = new List <object>();
try
{
erpsEntities db = new erpsEntities();
foreach (string id in purOrderArray)
{
var list = (from dtl in db.tpurorderdtl
join pur in db.tpurorder on dtl.PurOrderNO equals pur.PurOrderNO
join s in db.msupplier on dtl.SupID equals s.SupID
join p in db.mproduct on dtl.PdtID equals p.PdtID
where dtl.PurOrderNO == id
let p1 = new
{
dtl.PurOrderNO, //订单号
dtl.SupID, //供应商编号
s.SupName, //供应商名称
pur.AppointDate, //约定日期
dtl.PdtID, //产品编号
p.PdtName, //产品名称
p.Spec, //产品规格
p.Unit, //单位
p.MakeIn, //产地
dtl.UnitPrice, //价格
dtl.OrderNum, //合同数量
dtl.LftNum, //剩余数量
dtl.DelDate, //纳期
dtl.Remark //备注
}
select p1);
saleorderdtls.AddRange(list);
}
}
catch (Exception ex)
{
return(new PageResult(ex.ToString(), Request));
}
return(new PageResult(saleorderdtls, Request));
}
public BaseDataPackage <string> WholePurOrderWriteOff(string PurOrderNO)
{
var result = new BaseDataPackage <string>();
try
{
erpsEntities db = new erpsEntities();
int ret = 0;
var purorder = db.tpurorder.Where(w => w.PurOrderNO == PurOrderNO).FirstOrDefault <tpurorder>();
purorder.State = "F";
var entitys = db.tpurorderdtl.Where(w => w.PurOrderNO == PurOrderNO);
entitys.ToList().ForEach(item =>
{
item.LftNum = 0;
item.State = "F";
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
});
ret = db.SaveChanges();
if (ret > 0)
{
result.Status = ApiStatusCode.OK;
result.Message = "冲销成功";
return(result);
}
else
{
result.DataList = null;
result.Status = ApiStatusCode.FAIL;
result.Message = "冲销失败";
return(result);
}
}
catch (Exception ex)
{
result.Status = ApiStatusCode.EXCEPTION;
result.Message = "发生异常=>" + ex.Message;
return(result);
}
}
public BaseDataPackage <string> EditSupplierProdPrice(string id, msupplierprodprice msupplier)
{
var result = new BaseDataPackage <string>();
erpsEntities db = new erpsEntities();
msupplier.UpdateDate = DateTime.Now;
db.Entry(msupplier).State = EntityState.Modified;
try
{
db.SaveChanges();
result.Status = ApiStatusCode.OK;
result.Message = "修改成功";
return(result);
}
catch (Exception ex)
{
result.Message = "发生异常=>" + ex.Message;
result.Status = ApiStatusCode.EXCEPTION;
return(result);
}
}
public BaseDataPackage <string> AddSupplierProdPrice(msupplierprodprice msupplier)
{
var result = new BaseDataPackage <string>();
erpsEntities db = new erpsEntities();
if (!ModelState.IsValid)
{
result.Status = ApiStatusCode.FAIL;
result.Message = "无效数据";
return(result);
}
msupplier.CreateDate = DateTime.Now;
db.msupplierprodprice.Add(msupplier);
try
{
db.SaveChanges();
result.Status = ApiStatusCode.OK;
result.Message = "提交成功";
return(result);
}
catch (Exception ex)
{
if (db.msupplierprodprice.Count(e => e.SupID == msupplier.SupID && e.PdtID == msupplier.PdtID && e.Model == msupplier.Model) > 0)
{
result.Message = "发生异常=>" + "已存在该供应商编号+产品编号+车型组合";
}
else
{
result.Message = "发生异常=>" + ex.Message;
}
result.Status = ApiStatusCode.EXCEPTION;
return(result);
}
}
public MProduct()
{
erpsEntities = new erpsEntities();
}
public WhInventory()
{
erpsEntities = new erpsEntities();
}
public PurOrder()
{
erpsEntities = new erpsEntities();
}
public MSupplier()
{
erpsEntities = new erpsEntities();
}
public BaseDataPackage <string> SelPurOrderDtlWriteOff()
{
var result = new BaseDataPackage <string>();
try
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context
HttpRequestBase request = context.Request; //定义传统request对象
JavaScriptSerializer js = new JavaScriptSerializer();
List <SterilizationSel> list = js.Deserialize <List <SterilizationSel> >(request.Params["List"]);
erpsEntities db = new erpsEntities();
db.Database.Log = (log) => { System.Diagnostics.Debug.WriteLine(log); };
int ret = 0;
//for (int i = 0; i < list.Count; i++)
//{
// string PurOrderNO = list[i].saleFocaNO;
// int SeqNo = list[i].seqNo;
// float LftNum = list[i].lftNum;
// var entitys = db.tpurorderdtl.Where(w => w.PurOrderNO == PurOrderNO && w.SeqNo == SeqNo);
// entitys.ToList().ForEach(item =>
// {
// item.LftNum = LftNum;
// item.State = "F";
// db.Entry(item).State = System.Data.Entity.EntityState.Modified;
// });
//}
string PurOrderNO2 = list.Count > 0? list[0].saleFocaNO:"";
//var unFunishOrderDtls = db.tpurorderdtl.Where(w => w.PurOrderNO == PurOrderNO2 && (!w.State.Equals("F") || w.State == null)).ToList<tpurorderdtl>();
int fNum = 0; //所有已经冲销的明细数量
var unFunishOrderDtls = db.tpurorderdtl.Where(w => w.PurOrderNO == PurOrderNO2).ToList <tpurorderdtl>();
for (int i = 0; i < unFunishOrderDtls.Count; i++)
{
if (unFunishOrderDtls[i].State == "F")
{
fNum++;
}
else
{
for (int j = 0; j < list.Count; j++)
{
if (unFunishOrderDtls[i].PurOrderNO == list[j].saleFocaNO && unFunishOrderDtls[i].SeqNo == list[j].seqNo)
{
unFunishOrderDtls[i].LftNum = list[j].lftNum;
unFunishOrderDtls[i].State = "F";
fNum++;
}
}
}
}
//如果所有明细的状态都是"F"完成，把整体订单的状态都改成完成
if (fNum == unFunishOrderDtls.Count)
{
var purOrder = db.tpurorder.Where(w => w.PurOrderNO == PurOrderNO2).FirstOrDefault <tpurorder>();
purOrder.State = "F";
}
ret = db.SaveChanges();
if (ret > 0)
{
result.Status = ApiStatusCode.OK;
result.Message = "冲销成功";
return(result);
}
else
{
result.DataList = null;
result.Status = ApiStatusCode.FAIL;
result.Message = "冲销失败";
return(result);
}
}
catch (Exception ex)
{
result.Status = ApiStatusCode.EXCEPTION;
result.Message = "发生异常=>" + ex.Message;
return(result);
}
}
public BaseDataPackage <v_supplierprodprice> GetSupplierProdPrice(string pagesize, string currentPage, string orderby, string order, string SupID, string SupName, string PdtID, string PdtName)
{
var result = new BaseDataPackage <v_supplierprodprice>();
erpsEntities db = new erpsEntities();
try
{
List <v_supplierprodprice> list = new List <v_supplierprodprice>();
int pageSize = int.Parse(pagesize);
int CurrentPage = int.Parse(currentPage);
Dictionary <string, string> ob = new Dictionary <string, string>();
var tem = from f in db.v_supplierprodprice.AsNoTracking()
select f;
if (!string.IsNullOrEmpty(SupID))
{
tem = tem.Where(w => w.SupID.Contains(SupID));
}
if (!string.IsNullOrEmpty(SupName))
{
tem = tem.Where(w => w.SupName.Contains(SupName));
}
if (!string.IsNullOrEmpty(PdtID))
{
tem = tem.Where(w => w.PdtID.Contains(PdtID));
}
if (!string.IsNullOrEmpty(PdtName))
{
tem = tem.Where(w => w.PdtName.Contains(PdtName));
}
if (string.IsNullOrEmpty(orderby) || string.IsNullOrEmpty(order)) // 没有排序信息，直接按预警排序
{
tem = tem.OrderByDescending(o => o.CreateDate);
}
else
{
string orderPhase = "ASC";
if (order.ToLower() == "descending")
{
orderPhase = "DESC";
}
tem = Tool.SetQueryableOrder(tem, orderby, orderPhase);
}
int total = tem.Count();
tem = tem
.Skip(pageSize * (CurrentPage - 1))
.Take(pageSize);
list = tem.ToList();
if (list.Count > 0)
{
ob.Add("total", total.ToString());
result.DataList = list;
result.Keys = ob;
result.Status = ApiStatusCode.OK;
result.Message = "查询成功";
return(result);
}
else
{
result.DataList = null;
result.Status = ApiStatusCode.FAIL;
result.Message = "暂无数据";
return(result);
}
}
catch (Exception ex)
{
result.Status = ApiStatusCode.EXCEPTION;
result.Message = "发生异常=>" + ex.Message;
return(result);
}
}
public SaleForcast()
{
erpsEntities = new erpsEntities();
}
public StockRecord()
{
erpsEntities = new erpsEntities();
}
public MCustomer()
{
erpsEntities = new erpsEntities();
}