public BaseDataPackage <string> CancelPurOrder(string PurOrderNO, string UserID, string NegativeInventory)
{
var result = new BaseDataPackage <string>();
try
{
int ret = purOrder.CancelPurOrderStockIn(PurOrderNO, UserID, NegativeInventory, out string errPdtID, out string errWHID);
if (ret == 1)
{
result.Status = ApiStatusCode.OK;
result.Message = "取消成功";
return(result);
}
else
{
result.Status = ApiStatusCode.FAIL;
result.Message = "取消失败";
if (ret == -9)
{
Dictionary <string, string> ob = new Dictionary <string, string>();
ob.Add("ret", "-9");
result.Keys = ob;
result.Message = string.Format("{0} 仓库下的 {1} 产品库存不足", errWHID, errPdtID);
}
return(result);
}
}
catch (Exception ex)
{
result.Status = ApiStatusCode.EXCEPTION;
result.Message = "发生异常=>" + ex.Message;
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 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 <string> DelPurOrderAtt(string PurOrderNO, string AttFileName)
{
var result = new BaseDataPackage <string>();
try
{
int ret = purOrder.DelPurOrderAtt(PurOrderNO, AttFileName);
if (ret == 1)
{
//删除文件
File.Delete(HttpContext.Current.Server.MapPath(AttFileName));
result.Status = ApiStatusCode.OK;
result.Message = "删除成功";
return(result);
}
else
{
result.Status = ApiStatusCode.FAIL;
result.Message = "删除失败";
return(result);
}
}
catch (Exception ex)
{
result.Status = ApiStatusCode.EXCEPTION;
result.Message = "发生异常=>" + ex.Message;
return(result);
}
}
public BaseDataPackage <v_purorderdtl> GetPurOrderDtl_PurOrderNO(string purOrderNO)
{
var result = new BaseDataPackage <v_purorderdtl>();
try
{
List <v_purorderdtl> list;
list = purOrder.GetPurOrderDtlAndAtt(purOrderNO, out List <tpurorderatt> tpurorderatts);
if (list.Count > 0)
{
result.DataList = list;
result.ObjList = tpurorderatts.Cast <object>().ToList();
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);
}
}
/// <summary>
/// 注册
/// </summary>
/// <param name="context"></param>
public void Register(HttpContext context)
{
string username = context.Request["username"];
string mobile = context.Request["mobile"];
string departid = context.Request["departid"];
UserInfo user = new UserInfo();
user.username = username;
user.mobile = mobile;
user.departid = departid;
int num = DbHelperSQL.ExecuteSql("insert into sys_UserInfo(username,mobile,departid) values('" + username + "','" + mobile + "','" + departid + "')");
var result = new BaseDataPackage <UserInfo>();
if (num != 0)
{
result.code = ApiStatusCode.OK;
result.data = user;
result.msg = "注册成功";
}
else
{
result.code = ApiStatusCode.FAIL;
result.data = user;
result.msg = "注册失败";
}
string jsonData = JsonConvert.SerializeObject(result);
context.Response.Write(jsonData);
}
public BaseDataPackage <string> DelPurOrder()
{
var result = new BaseDataPackage <string>();
try
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context
HttpRequestBase request = context.Request; //定义传统request对象
JavaScriptSerializer js = new JavaScriptSerializer();
List <DelList> list = js.Deserialize <List <DelList> >(request.Params["delList"]);
int ret = purOrder.DelPurOrder(list);
if (ret == 1)
{
result.Status = ApiStatusCode.OK;
result.Message = "删除成功";
return(result);
}
else
{
result.Status = ApiStatusCode.FAIL;
result.Message = "删除失败";
return(result);
}
}
catch (Exception ex)
{
result.Status = ApiStatusCode.EXCEPTION;
result.Message = "发生异常=>" + ex.Message;
return(result);
}
}
/// <summary>
/// send data to all connected clients
/// </summary>
/// <param name="data">Data will be added to a queue</param>
public void SendToAll(BaseDataPackage data)
{
lock (_groupDataQueue)
{
_groupDataQueue.Enqueue(data);
}
}
/// <summary>
/// send a specific client data
/// </summary>
/// <param name="data">Data that will be sent to one client</param>
/// <param name="clientId">ID of client</param>
public void SendClient(BaseDataPackage data, Guid clientId)
{
KeyValuePair <ClientReference, BaseDataPackage> kvp =
new KeyValuePair <ClientReference, BaseDataPackage>(GetClientById(clientId), data);
lock (_clientDataQueue)
{
_clientDataQueue.Enqueue(kvp);
}
}
//发布消息
public void SendMessage(HttpContext context)
{
var result = new BaseDataPackage <UserMessage>();
string AcceptUserID = "";
string AcceptUserName = context.Request["AcceptUserName"];
string SendUserID = context.Request["SendUserID"];
string SendUserName = context.Request["SendUserName"];
string MsgTitle = context.Request["MsgTitle"];
string MsgText = context.Request["MsgText"];
string SendToList = "";
string MessageType = "";
string[] sArray = AcceptUserName.Split(',');
string AcceptUserName2 = "";
foreach (string i in sArray)
{
AcceptUserName2 += "'" + i + "'" + ",";
}
SqlDataReader dr = DbHelperSQL.ExecuteReader("select id from sys_UserInfo where username in (" + AcceptUserName2.TrimEnd(',') + ")");
while (dr.Read())
{
AcceptUserID += dr["id"].ToString() + ",";
}
UserMessage UserMessage = new UserMessage();
UserMessage.AcceptUserID = AcceptUserID;
UserMessage.AcceptUserName = AcceptUserName;
UserMessage.SendUserID = SendUserID;
UserMessage.SendUserName = SendUserName;
UserMessage.MsgTitle = MsgTitle;
UserMessage.MsgText = MsgText;
UserMessage.SendToList = SendToList;
UserMessage.MessageType = MessageType;
UserMessage.bRead = false;
UserMessage.SendDateTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
int num = DbHelperSQL.ExecuteSql("insert into sys_UserMessage (AcceptUserID, AcceptUserName, SendUserID, SendUserName, MsgTitle, MsgText, SendToList, MessageType, bRead, SendDateTime) values('" + AcceptUserID + "', '" + AcceptUserName + "', '" + SendUserID + "', '" + SendUserName + "', '" + MsgTitle + "' , '" + MsgText + "', '" + SendToList + "', '" + MessageType + "', '" + false + "', '" + UserMessage.SendDateTime + "' )");
if (num != 0)
{
result.code = ApiStatusCode.OK;
result.msg = "发送成功！";
result.data = UserMessage;
}
else
{
result.code = ApiStatusCode.OK;
result.msg = "发送失败！";
result.data = UserMessage;
}
string jsonData = JsonConvert.SerializeObject(result);
context.Response.Write(jsonData);
}
public BaseDataPackage <v_purorder> GetPurOrder()
{
var result = new BaseDataPackage <v_purorder>();
try
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context
HttpRequestBase request = context.Request; //定义传统request对象
string pagesize = request.Params["pagesize"];
string currentPage = request.Params["currentPage"];
string SupID = request.Params["SupID"];
string UpdateID = request.Params["UpdateID"];
string PurOrderNo = request.Params["PurOrderNo"];
string SDate = request.Params["SDate"];
string EDate = request.Params["EDate"];
string status = request.Params["Status"];
//SaleForcast sale = new SaleForcast();
List <v_purorder> list;
int pageSize = int.Parse(pagesize);
int CurrentPage = int.Parse(currentPage);
Dictionary <string, string> ob = new Dictionary <string, string>();
list = purOrder.GetPurOrder(PurOrderNo, SupID, UpdateID, SDate, EDate, status, pageSize, CurrentPage, out int total);
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 void CallMethod(SynchronizationContext context, BaseDataPackage data)
{
//Functions[data.GetType()].Invoke(data, default(Guid));
try
{
//dispatch call into the proper thread
context.Post(s =>
{
Functions[data.GetType()].Invoke(data, default(Guid));
}, null);
//ConnectionClosed?.Invoke();
}
catch (Exception ex)
{
//dont trust user code
Console.WriteLine("Calling client CallMethod data handler threw an exception");
}
}
public BaseDataPackage <vwhinventorywarning> GetWhInventoryWarning()
{
var result = new BaseDataPackage <vwhinventorywarning>();
try
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context
HttpRequestBase request = context.Request; //定义传统request对象
string pagesize = request.Params["pagesize"];
string currentPage = request.Params["currentPage"];
string pdtID = request.Params["pdtID"];
string orderby = request.Params["orderby"];
string order = request.Params["order"];
List <vwhinventorywarning> list;
int pageSize = int.Parse(pagesize);
int CurrentPage = int.Parse(currentPage);
Dictionary <string, string> ob = new Dictionary <string, string>();
list = whInv.GetWhInventoryWarning(pageSize, CurrentPage, pdtID, orderby, order, out int total);
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 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 void SendData(BaseDataPackage data)
{
MemoryStream msend = new MemoryStream();
try
{
_bf.Serialize(msend, data);
}
catch (Exception ex)
{
Console.WriteLine("SendData: Serialize");
msend.Dispose();
return;
}
try
{
_socket.Send(msend.GetBuffer(), 0, (int)msend.Length, SocketFlags.None);
}
catch (Exception ex)
{
Console.WriteLine("SendData: Send");
}
}
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 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 void CommitSuggest(HttpContext context)
{
string fileNewName = string.Empty;
string filePath = string.Empty;
var result = new BaseDataPackage <UserSuggest>();
HttpPostedFile file = context.Request.Files["file1"];
HttpPostedFile file2 = context.Request.Files["file2"];
HttpPostedFile file3 = context.Request.Files["file3"];
string Title = context.Request["Title"];
string Suggest = context.Request["Suggest"];
string UserID = context.Request["UserID"];
string paths = context.Request["paths"];
string pathsNew = "";
if (paths != "")
{
string[] sArray = paths.Split(',');
foreach (string pathSplit in sArray)
{
if (pathSplit != "")
{
fileNewName = DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + System.IO.Path.GetFileName(pathSplit);
string virtualPath = String.Format("/File/{0}", fileNewName); //上传到指定文件夹
string path = virtualPath; //相对获取文件路径
pathsNew += path + ",";
}
}
}
if (file != null)
{
file.SaveAs(context.Server.MapPath("~/File/" + DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + System.IO.Path.GetFileName(file.FileName)));
}
if (file2 != null)
{
file2.SaveAs(context.Server.MapPath("~/File/" + DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + System.IO.Path.GetFileName(file2.FileName)));
}
if (file3 != null)
{
file3.SaveAs(context.Server.MapPath("~/File/" + DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + System.IO.Path.GetFileName(file3.FileName)));
}
result.code = ApiStatusCode.OK;
result.msg = "";
result.data = null;
UserSuggest userSuggest = new UserSuggest();
userSuggest.commitUserID = int.Parse(UserID);
userSuggest.title = Title;
userSuggest.suggest = Suggest;
userSuggest.commitDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
userSuggest.files = pathsNew;
int num = DbHelperSQL.ExecuteSql("insert into sys_UserSuggest(commitUserID,title,suggest,commitDate,files) values('" + userSuggest.commitUserID + "','" + userSuggest.title + "','" + userSuggest.suggest + "','" + userSuggest.commitDate + "','" + userSuggest.files + "')");
if (num != 0)
{
result.code = ApiStatusCode.OK;
result.msg = "提交成功！";
result.data = userSuggest;
}
else
{
result.code = ApiStatusCode.OK;
result.msg = "提交失败！";
result.data = userSuggest;
}
string jsonData = JsonConvert.SerializeObject(result);
context.Response.Write(jsonData);
}
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);
}
}
private void serverDataHandler(BaseDataPackage data, Guid id)
{
ButtonClickData d = data.Unbox();
tbServerData.Text = d.ButtonClicked;
}
private void clientDataHandler(BaseDataPackage data)
{
ButtonClickData d = data.Unbox();
tbClientData.Text = d.ButtonClicked;
}
public BaseDataPackage <mcustomer> McustomerImport()
{
var result = new BaseDataPackage <mcustomer>();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context
HttpRequestBase request = context.Request; //定义传统request对象
string UserID = request.Form["UserID"];
HttpFileCollection filelist = HttpContext.Current.Request.Files;
if (filelist != null && filelist.Count > 0)
{
HttpPostedFile file = filelist[0];
string Tpath = "/Import/" + DateTime.Now.ToString("yyyy-MM-dd") + "/";
string filename = file.FileName;
string FileName = DateTime.Now.ToString("yyyyMMddHHmmssfff");
string FilePath = HttpContext.Current.Server.MapPath("~/" + Tpath);
string type = System.IO.Path.GetExtension(filename);
DirectoryInfo di = new DirectoryInfo(FilePath);
if (!di.Exists)
{
di.Create();
}
List <mcustomer> list = null;
//Dictionary<string, string> ob = new Dictionary<string, string>();
try
{
string tmpFileName = FilePath + FileName + type;
file.SaveAs(tmpFileName);
MCustomer sche = new MCustomer();
list = this.ExcelToMCustomerList(tmpFileName, UserID);
if (list.Count > 0)
{
int ret = sche.ImportList(list, out int addNum, out int updNum, out int cfNum);
//result.Keys = ob;
result.Status = ApiStatusCode.OK;
if (cfNum > 0)
{
result.Message = string.Format("数据导入成功,新增数据： {0}条, 修改数据： {1}条, Excel中有 {2} 条重复数据未导入", addNum, updNum, cfNum);
}
else
{
result.Message = string.Format("数据导入成功,新增数据： {0}条, 修改数据： {1}条", addNum, updNum);
}
}
else
{
result.Status = ApiStatusCode.FAIL;
result.Message = "导入数据失败,请确认所选文件是否正确";
}
return(result);
}
catch (Exception ex)
{
result.DataList = null;
result.Status = ApiStatusCode.FAIL;
result.Message = "导入数据失败：" + ex.Message;
return(result);
}
}
else
{
result.Status = ApiStatusCode.EXCEPTION;
result.Message = "上传导入文件出现异常!";
return(result);
}
}
public IHttpActionResult GetWhProduct()
{
var result = new BaseDataPackage <mproduct>();
try
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context
HttpRequestBase request = context.Request; //定义传统request对象
string pagesize = request.Params["pagesize"];
string currentpage = request.Params["currentPage"];
string whID = request.Params["whID"];
string pdtID = request.Params["pdtID"];
string pdtName = request.Params["pdtName"];
string spec = request.Params["spec"];
string unit = request.Params["unit"];
string pdtType = request.Params["pdtType"];
string startDate = request.Params["startDate"];
string endDate = request.Params["endDate"];
int pageSize = int.Parse(pagesize);
int currentPage = int.Parse(currentpage);
List <mproduct> list = new List <mproduct>();
var tem = from p in db.mproduct
join t in db.mproducttype on p.PdtType equals t.PdtTypeID
join w in db.twhinventory on p.PdtID equals w.PdtID
where w.WHID.Equals(whID) && w.InvNum > 0
select new
{
p.CreateDate,
p.CreateID,
p.MakeIn,
p.MgrInfo,
p.PdtID,
p.PdtName,
p.PdtType,
p.PurPrice,
p.Remark,
p.SalPrice,
p.Spec,
p.Unit,
p.UpdateDate,
p.UpdateID,
w.WHID,
w.InvNum
};
if (!string.IsNullOrEmpty(pdtID))
{
tem = tem.Where(w => w.PdtID.Contains(pdtID));
}
if (!string.IsNullOrEmpty(pdtName))
{
tem = tem.Where(p => p.PdtName.Contains(pdtName));
}
if (!string.IsNullOrEmpty(spec))
{
tem = tem.Where(p => p.Spec.Contains(spec));
}
if (!string.IsNullOrEmpty(unit))
{
tem = tem.Where(p => p.Unit.Contains(unit));
}
if (!string.IsNullOrEmpty(pdtType))
{
tem = tem.Where(p => p.PdtType == pdtType);
}
if (!string.IsNullOrEmpty(startDate))
{
DateTime date = Convert.ToDateTime(startDate);
tem = tem.Where(p => p.CreateDate >= date);
}
if (!string.IsNullOrEmpty(endDate))
{
DateTime date = Convert.ToDateTime(endDate);
date = date.AddDays(1);
tem = tem.Where(p => p.CreateDate < date);
}
if (tem == null)
{
return(NotFound());
}
tem = tem.OrderBy(p => p.PdtID);
var oData = new { total = tem.Count(), rows = tem.Skip(pageSize * (currentPage - 1)).Take(pageSize).ToList() };
return(Ok(oData));
}
catch (Exception ex)
{
return(NotFound());
}
}
public BaseDataPackage <string> EditPurOrderDtl()
{
var result = new BaseDataPackage <string>();
try
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context
HttpRequestBase request = context.Request; //定义传统request对象
string PurOrderNO = request.Form["PurOrderNO"];
string SupID = request.Form["SupID"];
string UserID = request.Form["UserID"];
string CreDate = request.Form["CreDate"];
tpurorder tpurorder = new tpurorder();
tpurorder.PurOrderNO = PurOrderNO;
tpurorder.SupID = request.Form["SupID"];
tpurorder.CreDate = Convert.ToDateTime(CreDate);
tpurorder.TotalNum = float.Parse(request.Form["TotalNum"]);
tpurorder.TotalAmount = float.Parse(request.Form["TotalAmount"]);
tpurorder.AppointDate = Convert.ToDateTime(request.Form["AppointDate"]);
tpurorder.UpdateID = UserID;
tpurorder.UpdateDate = DateTime.Now;
JavaScriptSerializer js = new JavaScriptSerializer();
List <v_purorderdtl> list = js.Deserialize <List <v_purorderdtl> >(request.Params["list"]);
list.RemoveAll(r => string.IsNullOrEmpty(r.PdtID));
List <tpurorderdtl> tpurorderdtls = new List <tpurorderdtl>();
for (int i = 0; i < list.Count; i++)
{
tpurorderdtl tpurorderdtl = new tpurorderdtl();
tpurorderdtl.PurOrderNO = PurOrderNO;
tpurorderdtl.SeqNo = i + 1;
tpurorderdtl.SupID = SupID;
tpurorderdtl.PdtID = list[i].PdtID;
tpurorderdtl.DelDate = list[i].DelDate;
tpurorderdtl.OrderNum = Convert.ToSingle(list[i].OrderNum);
tpurorderdtl.LftNum = Convert.ToSingle(list[i].LftNum);
tpurorderdtl.UnitPrice = list[i].UnitPrice;
tpurorderdtl.TotalAmount = list[i].TotalAmount;
tpurorderdtl.State = list[i].State == null ? "N" : list[i].State;
tpurorderdtl.Remark = list[i].Remark;
tpurorderdtl.UpdateID = UserID;
tpurorderdtl.UpdateDate = DateTime.Now;
tpurorderdtls.Add(tpurorderdtl);
}
List <tpurorderatt> tpurorderatts = new List <tpurorderatt>();
HttpFileCollection files = HttpContext.Current.Request.Files;
string url = "/upload/" + PurOrderNO + "/";
string basePath = HttpContext.Current.Server.MapPath(url);
List <string> tmpPath = new List <string>();
if (files.Count > 0)
{
//如果目录不存在，则创建目录
if (!Directory.Exists(basePath))
{
Directory.CreateDirectory(basePath);
}
for (int i = 0; i < files.Count; i++)
{
tpurorderatt tpurorderatt = new tpurorderatt();
string path = basePath + files[i].FileName;
tpurorderatt.PurOrderNO = PurOrderNO;
tpurorderatt.AttFileName = url + files[i].FileName;
tpurorderatt.UpdateID = UserID;
tpurorderatt.UpdateDate = DateTime.Now;
tpurorderatts.Add(tpurorderatt);
tmpPath.Add(path);
}
}
int ret = purOrder.EditPurOrderDtl(PurOrderNO, tpurorder, tpurorderdtls, tpurorderatts);
if (ret == 1)
{
for (int i = 0; i < files.Count; i++)
{
files[i].SaveAs(tmpPath[i]);
}
result.Status = ApiStatusCode.OK;
result.Message = "修改成功";
return(result);
}
else
{
result.Status = ApiStatusCode.FAIL;
result.Message = "修改失败";
return(result);
}
}
catch (Exception ex)
{
result.Status = ApiStatusCode.EXCEPTION;
result.Message = "发生异常=>" + ex.Message;
return(result);
}
}
