642 lines
29 KiB
C#
642 lines
29 KiB
C#
using CRM.Core.DTO;
|
|
using CRM.Core.DTO.Ord;
|
|
using Newtonsoft.Json;
|
|
using NPOI.HSSF.UserModel;
|
|
using NPOI.SS.UserModel;
|
|
using NPOI.XSSF.UserModel;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.IO;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Web;
|
|
using WX.CRM.BLL.Application.UserComBox;
|
|
using WX.CRM.BLL.Util;
|
|
using WX.CRM.Common;
|
|
using WX.CRM.Common.Employee;
|
|
using WX.CRM.Common.Layui;
|
|
using WX.CRM.IBLL.Wx;
|
|
using WX.CRM.Model.Entity;
|
|
using WX.CRM.Model.Enum;
|
|
using WX.CRM.Model.MAP;
|
|
|
|
namespace WX.CRM.BLL.Wx
|
|
{
|
|
public class WX_SZZYORDER_HANDGIFT_BL : IWX_SZZYORDER_HANDGIFT
|
|
{
|
|
private CACHE_BL cache_BL = new CACHE_BL();
|
|
|
|
public SecurityHelper sHelper = new SecurityHelper();
|
|
|
|
public List<Wx_SzzyOrder_HandGift_Map> GetHandGifList(ref Laypage pager, Wx_SzzyOrder_HandGift_Query param, QueryUserComboDto usercomboDto)
|
|
{
|
|
using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
|
|
{
|
|
IQueryable<WX_SZZYORDER_HANDGIFT> queryData = db.WX_SZZYORDER_HANDGIFT.AsQueryable();
|
|
|
|
if (param.ORDERSTATUS.HasValue)
|
|
{
|
|
queryData = queryData.Where(m => m.ORDERSTATUS == param.ORDERSTATUS.Value);
|
|
}
|
|
if (param.ORDERID.HasValue)
|
|
{
|
|
queryData = queryData.Where(m => m.ORDERID == param.ORDERID.Value);
|
|
}
|
|
if (param.MAINORDERID.HasValue)
|
|
{
|
|
queryData = queryData.Where(m => m.MAINORDERID == param.MAINORDERID.Value);
|
|
}
|
|
if (!string.IsNullOrEmpty(param.RESID))
|
|
{
|
|
param.RESID = param.RESID.Trim();
|
|
queryData = queryData.Where(m => m.RESID == param.RESID);
|
|
}
|
|
if (!string.IsNullOrEmpty(param.SOFTUSERNAME))
|
|
{
|
|
queryData = queryData.Where(m => m.SOFTUSERNAME == param.SOFTUSERNAME);
|
|
}
|
|
if (param.STIME.HasValue)
|
|
{
|
|
queryData = queryData.Where(m => m.CTIME >= param.STIME.Value);
|
|
}
|
|
if (param.ETIME.HasValue)
|
|
{
|
|
param.ETIME = param.ETIME.Value.AddDays(1);
|
|
queryData = queryData.Where(m => m.CTIME < param.ETIME.Value);
|
|
}
|
|
if (param.CONTRACTSTATUS.HasValue)
|
|
{
|
|
queryData = queryData.Where(m => m.CONTRACTSTATUS == param.CONTRACTSTATUS);
|
|
}
|
|
|
|
var data = from a in queryData
|
|
join b in db.WX_SZZYORDER on a.MAINORDERID equals b.ORDERID into t1
|
|
from b in t1.DefaultIfEmpty()
|
|
join c in db.WX_ORDEREXT on a.MAINORDERID equals c.ORDERID into t2
|
|
from c in t2.DefaultIfEmpty()
|
|
join d in db.BAS_INNERUSER on b.INNERUSERID equals d.PKID into t3
|
|
from d in t3.DefaultIfEmpty()
|
|
select new Wx_SzzyOrder_HandGift_Map()
|
|
{
|
|
ORDERID = a.ORDERID,
|
|
CHANNEL = c.CHANNEL,
|
|
HandGiftChannel = a.CHANNEL,
|
|
CHECKMEMO = a.CHECKMEMO,
|
|
COMPANYCODE = a.COMPANYCODE,
|
|
CREATEUSER = a.CREATEUSER,
|
|
CTIME = a.CTIME,
|
|
GIFTDAYS = a.GIFTDAYS,
|
|
MAINORDERID = a.MAINORDERID,
|
|
MAINPDAYS = b.OPENDAYS,
|
|
MAINPGIF = b.GIFTDAYS,
|
|
MAINPRODUCTNAME = b.SUBPRODUCTNAME,
|
|
MEMO = a.MEMO,
|
|
OLDOUTORDERNO = a.OLDOUTORDERNO,
|
|
OPENUSER = a.OPENUSER,
|
|
ORDERSTATUS = a.ORDERSTATUS,
|
|
OPTIME = a.OPTIME,
|
|
OTIME = a.OTIME,
|
|
OUTORDERCLOSETIME = a.OUTORDERCLOSETIME,
|
|
OUTORDERNO = a.OUTORDERNO,
|
|
PRODUCTCODE = a.PRODUCTCODE,
|
|
PRODUCTID = a.PRODUCTID,
|
|
RESID = a.RESID,
|
|
SOFTUSERNAME = a.SOFTUSERNAME,
|
|
SUBPRODUCTCODE = a.SUBPRODUCTCODE,
|
|
SUBPRODUCTNAME = a.SUBPRODUCTNAME,
|
|
SZZYORDERID = a.SZZYORDERID,
|
|
USERID = a.USERID,
|
|
CLOSEMEMO = a.CLOSEMEMO,
|
|
CLOSETIME = a.CLOSETIME,
|
|
CLOSEUSER = a.CLOSEUSER,
|
|
DEPTCODE = b.DEPTCODE,
|
|
CONTRACTCTIME = a.CONTRACTCTIME,
|
|
CONTRACTSTATUS = a.CONTRACTSTATUS,
|
|
CONTRACTCODE = a.CONTRACTCODE,
|
|
CREATEEID = a.CREATEEID,
|
|
OrderEid = d.EID
|
|
};
|
|
|
|
if (usercomboDto.txt_eid.HasValue)
|
|
{
|
|
data = data.Where(m => m.CREATEEID == usercomboDto.txt_eid.Value || m.OrderEid == usercomboDto.txt_eid.Value);
|
|
}
|
|
else if (!string.IsNullOrEmpty(usercomboDto.txt_groupIds))
|
|
{
|
|
var _groupids = OperationUtil.ConvertToDecimal(usercomboDto.txt_groupIds.Split(','));
|
|
data = (from a in data
|
|
join c in db.BAS_INNERUSER on a.CREATEEID equals c.EID
|
|
join b in db.BAS_INNERUSERGROUP on c.PKID equals b.INNERUSERID
|
|
|
|
where _groupids.Contains(b.GID.Value)
|
|
select a);
|
|
}
|
|
else if (!string.IsNullOrEmpty(usercomboDto.txt_deptId))
|
|
{
|
|
var depts = OperationUtil.ConvertToDecimal(usercomboDto.txt_deptId.Split(','));
|
|
List<decimal> ALLdeptIDS = new List<decimal>();
|
|
List<decimal> ALLgidS = new List<decimal>();
|
|
UserServices userservices = new UserServices(cache_BL);
|
|
foreach (var item in depts)
|
|
{
|
|
List<decimal> deptIDS = new List<decimal>();
|
|
List<decimal> gidS = new List<decimal>();
|
|
userservices.GetAllDeptIDOrGidByDeptId(item, ref deptIDS, ref gidS);//获取所有的组别和gid
|
|
ALLdeptIDS.AddRange(deptIDS);
|
|
ALLgidS.AddRange(gidS);
|
|
}
|
|
|
|
var deptcodes = (from a in db.BAS_BUSINESSDEPARTMENT
|
|
join b in db.BAS_SALESDEPARTMENT on a.DEPTID equals b.SALEDEPTID
|
|
where ALLdeptIDS.Contains(a.DEPTID)
|
|
select b.SALEDEPTCODE).ToArray();
|
|
data = (from a in data
|
|
join c in db.BAS_INNERUSER on a.CREATEEID equals c.EID
|
|
join x in db.BAS_INNERUSERGROUP on c.PKID equals x.INNERUSERID into tempB
|
|
from b in tempB.DefaultIfEmpty()
|
|
//join g in db.BAS_INNERGROUP on b.GID equals g.GID
|
|
where ALLdeptIDS.Contains(b.DEPTID.Value) || ALLgidS.Contains(b.GID.Value)
|
|
select a);
|
|
}
|
|
else if (usercomboDto.txt_companyId.HasValue)
|
|
{
|
|
data = (from a in data
|
|
join c in db.BAS_INNERUSER on a.CREATEEID equals c.EID
|
|
join b in db.BAS_INNERUSERGROUP on c.PKID equals b.INNERUSERID
|
|
join g in db.BAS_INNERGROUP on b.GID equals g.GID
|
|
join m in db.BAS_SALESDEPARTMENT on g.SALEDEPTID equals m.SALEDEPTID
|
|
where m.COMPANYID == usercomboDto.txt_companyId.Value
|
|
select a);
|
|
}
|
|
|
|
data = data.OrderByDescending(m => m.CTIME);
|
|
PagerUtil.SetPager<Wx_SzzyOrder_HandGift_Map>(ref data, ref pager);//分页
|
|
var res = data.ToList();
|
|
//查询事业部
|
|
var deptNameList = cache_BL.GetDeptNameMapList();
|
|
var channelList = res.Where(n => !string.IsNullOrWhiteSpace(n.CHANNEL)).Select(n => Convert.ToInt32(n.CHANNEL)).ToList();
|
|
var giftChannel = res.Where(n => n.HandGiftChannel > 0).Select(n => Convert.ToInt32(n.HandGiftChannel)).ToList();
|
|
channelList.AddRange(giftChannel);
|
|
var dicMap = cache_BL.ConvertChannelName(deptNameList, channelList);
|
|
var creatorList = res.Where(m => !string.IsNullOrEmpty(m.CREATEUSER)).Select(n => n.CREATEUSER).Distinct().ToList();
|
|
List<decimal> eidList = new List<decimal>();
|
|
foreach (var creator in creatorList)
|
|
{
|
|
decimal eid = -1;
|
|
|
|
if (decimal.TryParse(creator.Split('-').FirstOrDefault(), out eid))
|
|
{
|
|
eidList.Add(eid);
|
|
}
|
|
}
|
|
|
|
var deptEidMap = cache_BL.GetUserDeptNameByEid(eidList);
|
|
foreach (var item in res)
|
|
{
|
|
var num = 0;
|
|
|
|
if (Int32.TryParse(item.CHANNEL, out num))
|
|
{
|
|
item.DEPTCODE = dicMap.ContainsKey(num) ? dicMap[num] : "未知";
|
|
}
|
|
if (string.IsNullOrWhiteSpace(item.CHANNEL) && item.HandGiftChannel > 0)
|
|
{
|
|
num = Convert.ToInt32(item.HandGiftChannel);
|
|
item.DEPTCODE = dicMap.ContainsKey(num) ? dicMap[num] : "未知";
|
|
}
|
|
var eid = item.CREATEUSER.Split('-').FirstOrDefault();
|
|
if (string.IsNullOrEmpty(eid) && item.CREATEEID.HasValue)
|
|
{
|
|
eid = item.CREATEEID.ToString();
|
|
}
|
|
|
|
if (!string.IsNullOrWhiteSpace(eid))
|
|
{
|
|
var mapModel = deptEidMap.FirstOrDefault(n => n.Eid.ToString() == eid);
|
|
item.RequestDeptName = mapModel?.DeptName;
|
|
}
|
|
}
|
|
return res;
|
|
}
|
|
}
|
|
|
|
public WX_SZZYORDER_HANDGIFT GetHandleGifById(decimal orderid)
|
|
{
|
|
using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
|
|
{
|
|
return db.WX_SZZYORDER_HANDGIFT.FirstOrDefault(n => n.ORDERID == orderid);
|
|
}
|
|
}
|
|
|
|
public int GetAuditCount(decimal orderid)
|
|
{
|
|
var auditCount = 0;
|
|
using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
|
|
{
|
|
var order = db.WX_SZZYORDER_HANDGIFT.FirstOrDefault(n => n.ORDERID == orderid);
|
|
List<decimal> eidList = new List<decimal>();
|
|
decimal eid = -1;
|
|
if (decimal.TryParse(order.CREATEUSER.Split('-').FirstOrDefault(), out eid))
|
|
{
|
|
eidList.Add(eid);
|
|
}
|
|
var deptEidMap = cache_BL.GetUserDeptNameByEid(eidList);
|
|
int? saleDeptId = -1;
|
|
if (deptEidMap.Count > 0)
|
|
{
|
|
saleDeptId = deptEidMap.FirstOrDefault().SaleDeptId == null ? -1 : deptEidMap.FirstOrDefault().SaleDeptId;
|
|
}
|
|
if (saleDeptId == -1)
|
|
{
|
|
int curChannel = 0;
|
|
var channelSetting = Utility.GetSettingOrNullByKey("Channel");
|
|
if (!string.IsNullOrWhiteSpace(channelSetting))
|
|
{
|
|
curChannel = Convert.ToInt32(channelSetting);
|
|
}
|
|
var defaultDept = cache_BL.ConvertChannelName(new List<int> { curChannel });
|
|
if (defaultDept.FirstOrDefault() != null && defaultDept.FirstOrDefault().id > 0)
|
|
{
|
|
saleDeptId = Convert.ToInt32(defaultDept.FirstOrDefault().id);
|
|
}
|
|
}
|
|
var nowMonthDate = DateTime.Now.AddDays(1 - DateTime.Now.Day).Date;
|
|
var nowMonthList = db.WX_SZZYORDER_HANDGIFT.Where(n => n.AUDITTYPE == 1 && n.ORDERSTATUS == 1 && n.OPTIME > nowMonthDate && n.SALEDEPTID == saleDeptId).ToList();
|
|
auditCount = nowMonthList.Count();
|
|
}
|
|
return auditCount;
|
|
}
|
|
|
|
public OrderHandGiftDto GetSuProductIdByOrderId(long orderId, ref ValidationErrors errors)
|
|
{
|
|
OrderHandGiftDto dto = new OrderHandGiftDto()
|
|
{
|
|
orderid = orderId,
|
|
companycode = Utility.GetSettingOrNullByKey("DataClientCode")
|
|
};
|
|
var sHelper = new SecurityHelper();
|
|
var url = new CACHE_BL().GetValue_Parameter(Parameter.Core_ZxdService_GetSuProductIdByOrderId);
|
|
var json = sHelper.createSignEncodingStr(dto.ToJson(), SecurityHelper.OrderClientIdKey);
|
|
//url = "http://localhost:55047//OrderService.svc/Order/GetSuProductIdByOrderId";
|
|
string retmsg = Utility.PostData(url + "?" + json, Encoding.UTF8);
|
|
//retmsg = sHelper.decyptData(SecurityHelper.OrderClientIdKey, retmsg);
|
|
var retmessage = Newtonsoft.Json.JsonConvert.DeserializeObject<retMsgNew<OrderHandGiftDto>>(retmsg);
|
|
if (retmessage.result)
|
|
{
|
|
dto = retmessage.data;
|
|
}
|
|
else
|
|
{
|
|
errors.Add(retmessage.retmsg);
|
|
}
|
|
return dto;
|
|
}
|
|
|
|
public bool Save(WX_SZZYORDER_HANDGIFT model, ref ValidationErrors errors)
|
|
{
|
|
bool result = false;
|
|
|
|
#region 指定渠道
|
|
|
|
decimal curChannel = 0;
|
|
var channelSetting = Utility.GetSettingOrNullByKey("Channel");
|
|
if (!string.IsNullOrWhiteSpace(channelSetting))
|
|
{
|
|
curChannel = Convert.ToInt32(channelSetting);
|
|
}
|
|
|
|
#endregion 指定渠道
|
|
|
|
try
|
|
{
|
|
using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
|
|
{
|
|
//var orderext = db.WX_ORDEREXT.FirstOrDefault(m => m.ORDERID == model.MAINORDERID);
|
|
//if (orderext == null)
|
|
//{
|
|
// errors.Add("订单信息错误！");
|
|
// return false;
|
|
//}
|
|
//var mainorder = db.WX_SZZYORDER.FirstOrDefault(m => m.ORDERID == model.MAINORDERID);
|
|
//if (mainorder == null)
|
|
//{
|
|
// errors.Add("订单信息错误！");
|
|
// return false;
|
|
//}
|
|
//model.PRODUCTID = mainorder.SUBPRODUCTID;
|
|
//var product = db.WX_SZZYSUBPRODUCT.FirstOrDefault(m => m.SUBPRODUCTID == model.PRODUCTID);
|
|
//if (product.ISGIFT != 1)
|
|
//{
|
|
// errors.Add("此订单产品未开启赠送！");
|
|
// return false;
|
|
//}
|
|
//model.PRODUCTCODE = product.PRODUCTCODE;
|
|
//model.SOFTUSERNAME = orderext.SOFTUSERNAME;
|
|
//model.ORDERSTATUS = 0;
|
|
//model.RESID = mainorder.RESID;
|
|
//model.ORDERID = new SEQUENCES_BL().Seq_base_get();
|
|
model.CTIME = DateTime.Now;
|
|
|
|
var model2 = GetSuProductIdByOrderId(long.Parse(model.MAINORDERID.ToString()), ref errors);
|
|
model.PRODUCTID = model2.subproductid;
|
|
model.PRODUCTCODE = model2.productcode;
|
|
|
|
#region 调用中心点接口
|
|
|
|
//调用中心点赠送订单申请接口
|
|
//dto.companycode = companyCode;
|
|
OrderHandGiftDto dto = new OrderHandGiftDto()
|
|
{
|
|
channel = Convert.ToInt32(model.CHANNEL),
|
|
checkmemo = model.CHECKMEMO,
|
|
companycode = Utility.GetSettingOrNullByKey("DataClientCode"),
|
|
createuser = model.CREATEUSER,
|
|
ctime = model.CTIME,
|
|
giftdays = Convert.ToInt32(model.GIFTDAYS),
|
|
mainorderid = Convert.ToInt64(model.MAINORDERID),
|
|
memo = model.MEMO,
|
|
orderid = Convert.ToInt64(model.ORDERID),
|
|
orderstatus = Convert.ToInt32(model.ORDERSTATUS),
|
|
productcode = model.PRODUCTCODE,
|
|
productid = Convert.ToInt32(model.PRODUCTID),
|
|
resid = model.RESID,
|
|
softusername = model.SOFTUSERNAME,
|
|
subproductcode = model.SUBPRODUCTCODE,
|
|
subproductname = model.SUBPRODUCTNAME,
|
|
requireChannel = Convert.ToInt32(curChannel)
|
|
};
|
|
|
|
var sHelper = new SecurityHelper();
|
|
var url = new CACHE_BL().GetValue_Parameter(Parameter.Core_ZxdService_OrderHandleGift);
|
|
var json = sHelper.createSignEncodingStr(dto.ToJson(), SecurityHelper.OrderClientIdKey);
|
|
string retmsg = Utility.PostData(url + "?" + json, Encoding.UTF8);
|
|
//retmsg = sHelper.decyptData(SecurityHelper.OrderClientIdKey, retmsg);
|
|
|
|
var retmessage = Newtonsoft.Json.JsonConvert.DeserializeObject<retMsgNew<OrderHandGiftDto>>(retmsg);
|
|
if (retmessage.result)
|
|
{
|
|
model.ORDERID = retmessage.data.orderid;
|
|
model.SUBPRODUCTNAME = retmessage.data.subproductname;
|
|
model.SUBPRODUCTCODE = retmessage.data.subproductcode;
|
|
model.PRODUCTTYPE = retmessage.data.producttype;//0-单一产品、1-组合产品
|
|
model.SZZYORDERID = retmessage.data.szzyorderid;
|
|
//赠送订单的自动审核功能根据配置启用/禁用
|
|
var autoAuditGiftStr = cache_BL.GetValue_Parameter(Parameter.Auto_AuditGift);
|
|
if (!string.IsNullOrWhiteSpace(autoAuditGiftStr))
|
|
{
|
|
var autoAuditGift = Newtonsoft.Json.JsonConvert.DeserializeObject<AutoAuditGiftParameterDto>(autoAuditGiftStr);
|
|
if (autoAuditGift.IsAutoAudit)
|
|
{
|
|
model.ORDERSTATUS = retmessage.data.orderstatus;
|
|
model.OPTIME = retmessage.data.otime.HasValue ? retmessage.data.otime.Value.AddHours(8) : DateTime.Now;
|
|
model.CHECKMEMO = retmessage.data.checkmemo;
|
|
model.OPENUSER = retmessage.data.openuser;
|
|
}
|
|
}
|
|
|
|
model.SZZYORDERID = retmessage.data.szzyorderid;
|
|
model.SALEDEPTID = retmessage.data.saleDeptId;
|
|
db.WX_SZZYORDER_HANDGIFT.Add(model);
|
|
db.SaveChanges();
|
|
result = true;
|
|
}
|
|
else
|
|
{
|
|
errors.Add(retmessage.retmsg);
|
|
result = false;
|
|
}
|
|
|
|
#endregion 调用中心点接口
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
errors.Add(ex.Message);
|
|
}
|
|
return result;
|
|
}
|
|
|
|
public bool CheckSave(WX_SZZYORDER_HANDGIFT editmodel, ref ValidationErrors errors)
|
|
{
|
|
bool result = false;
|
|
try
|
|
{
|
|
using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
|
|
{
|
|
var model = db.WX_SZZYORDER_HANDGIFT.FirstOrDefault(n => n.ORDERID == editmodel.ORDERID);
|
|
|
|
var model2 = GetSuProductIdByOrderId(long.Parse(model.MAINORDERID.ToString()), ref errors);
|
|
model.PRODUCTID = model2.subproductid;
|
|
model.PRODUCTCODE = model2.productcode;
|
|
|
|
#region 调用中心点接口
|
|
|
|
//调用中心点赠送订单申请接口
|
|
//dto.companycode = companyCode;
|
|
AuditHandGiftDto dto = new AuditHandGiftDto()
|
|
{
|
|
orderstatus = Convert.ToInt32(editmodel.ORDERSTATUS),
|
|
OrderId = editmodel.ORDERID,
|
|
Memo = editmodel.MEMO,
|
|
OpenUser = editmodel.OPENUSER
|
|
};
|
|
var sHelper = new SecurityHelper();
|
|
var url = new CACHE_BL().GetValue_Parameter(Parameter.Core_ZxdService_AuditOrderGift);
|
|
var json = sHelper.createSignEncodingStr(dto.ToJson(), SecurityHelper.OrderClientIdKey);
|
|
//url = "http://localhost:55047/OrderService.svc/OrderHandleGift/Audit";
|
|
string retmsg = Utility.PostData(url + "?" + json, Encoding.UTF8);
|
|
//retmsg = sHelper.decyptData(SecurityHelper.OrderClientIdKey, retmsg);
|
|
var retmessage = Newtonsoft.Json.JsonConvert.DeserializeObject<retMsgNew<WX_SZZYORDER_HANDGIFT>>(retmsg);
|
|
if (retmessage.result)
|
|
{
|
|
model.CHECKMEMO = retmessage.data.CHECKMEMO;
|
|
model.OPENUSER = retmessage.data.OPENUSER;
|
|
model.OPTIME = retmessage.data.OPTIME.HasValue ? retmessage.data.OPTIME.Value.AddHours(8) : DateTime.Now;
|
|
model.ORDERSTATUS = retmessage.data.ORDERSTATUS;//0-单一产品、1-组合产品
|
|
if (model.ORDERSTATUS == 1)
|
|
{
|
|
model.AUDITTYPE = 1;
|
|
}
|
|
db.SaveChanges();
|
|
result = true;
|
|
}
|
|
else
|
|
{
|
|
errors.Add(retmessage.retmsg);
|
|
result = false;
|
|
}
|
|
|
|
#endregion 调用中心点接口
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
errors.Add(ex.Message);
|
|
}
|
|
return result;
|
|
}
|
|
|
|
public bool UpdateCheckStatus(WX_SZZYORDER_HANDGIFT model, ref ValidationErrors errors)
|
|
{
|
|
bool result = false;
|
|
try
|
|
{
|
|
using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
|
|
{
|
|
var entry = db.WX_SZZYORDER_HANDGIFT.FirstOrDefault(m => m.ORDERID == model.ORDERID);
|
|
if (entry == null)
|
|
{
|
|
LogHelper.Info("WX_SZZYORDER_HANDGIFT找不到订单号,补数据：" + model.ORDERID);
|
|
db.WX_SZZYORDER_HANDGIFT.Add(model);
|
|
db.SaveChanges();
|
|
return true;
|
|
}
|
|
entry.ORDERSTATUS = model.ORDERSTATUS;
|
|
entry.OPENUSER = model.OPENUSER;
|
|
entry.OPTIME = model.OPTIME;
|
|
entry.SZZYORDERID = model.SZZYORDERID;
|
|
entry.CHECKMEMO = model.CHECKMEMO;
|
|
entry.CLOSEMEMO = model.CLOSEMEMO;
|
|
entry.CLOSEUSER = model.CLOSEUSER;
|
|
entry.CLOSETIME = model.CLOSETIME;
|
|
entry.CONTRACTSTATUS = model.CONTRACTSTATUS;
|
|
entry.CONTRACTCODE = model.CONTRACTCODE;
|
|
entry.CONTRACTCTIME = model.CONTRACTCTIME;
|
|
entry.ISFORCE = model.ISFORCE;
|
|
db.SaveChanges();
|
|
result = true;
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
errors.Add(ex.Message);
|
|
}
|
|
return result;
|
|
}
|
|
|
|
public bool AddHandGift(WX_SZZYORDER_HANDGIFT model, ref ValidationErrors errors)
|
|
{
|
|
bool result = false;
|
|
try
|
|
{
|
|
using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
|
|
{
|
|
var entry = db.WX_SZZYORDER_HANDGIFT.FirstOrDefault(m => m.ORDERID == model.ORDERID);
|
|
if (entry == null)
|
|
{
|
|
LogHelper.Info("WX_SZZYORDER_HANDGIFT找不到订单号,补数据：" + model.ORDERID);
|
|
db.WX_SZZYORDER_HANDGIFT.Add(model);
|
|
db.SaveChanges();
|
|
return true;
|
|
}
|
|
entry.ORDERSTATUS = model.ORDERSTATUS;
|
|
entry.OPENUSER = model.OPENUSER;
|
|
entry.OPTIME = model.OPTIME;
|
|
entry.SZZYORDERID = model.SZZYORDERID;
|
|
entry.CHECKMEMO = model.CHECKMEMO;
|
|
entry.CLOSEMEMO = model.CLOSEMEMO;
|
|
entry.CLOSEUSER = model.CLOSEUSER;
|
|
entry.CLOSETIME = model.CLOSETIME;
|
|
entry.CONTRACTSTATUS = model.CONTRACTSTATUS;
|
|
entry.CONTRACTCODE = model.CONTRACTCODE;
|
|
entry.CONTRACTCTIME = model.CONTRACTCTIME;
|
|
db.SaveChanges();
|
|
result = true;
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
errors.Add(ex.Message);
|
|
}
|
|
return result;
|
|
}
|
|
|
|
public ApiResult<List<ImportGiftOrderViewModel>> ImportBasicsGift(string filename, Stream filestream)
|
|
{
|
|
try
|
|
{
|
|
var file_ext = Path.GetExtension(filename).ToLower();
|
|
var importData = ImportBasicsGiftFromExcel(filestream, file_ext);
|
|
if (importData.Count > 0)
|
|
{
|
|
var apiPath = cache_BL.GetValue_Parameter(Parameter.ZXD_CORE_WEBAPI);
|
|
//apiPath = "http://localhost:5244";
|
|
var headers = new Dictionary<string, string>();
|
|
var json = importData.ToJson();
|
|
string result = Utility.PostAjaxData($"{apiPath}/Api/Order/ImportHandGiftPreview", json, headers, Encoding.UTF8);//返回信息
|
|
|
|
var response = JsonConvert.DeserializeObject<ApiResult<List<ImportGiftOrderViewModel>>>(result);
|
|
return response;
|
|
}
|
|
else
|
|
{
|
|
return new ApiResult<List<ImportGiftOrderViewModel>>
|
|
{
|
|
code = -1,
|
|
msg = "数据不合法"
|
|
};
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
return new ApiResult<List<ImportGiftOrderViewModel>>
|
|
{
|
|
code = -1,
|
|
msg = ex.Message
|
|
};
|
|
}
|
|
return null;
|
|
}
|
|
|
|
public List<ImportGiftOrderDto> ImportBasicsGiftFromExcel(Stream filestream, string file_ext = "xls")
|
|
{
|
|
List<ImportGiftOrderDto> result = new List<ImportGiftOrderDto>();
|
|
IWorkbook workBook = null;
|
|
|
|
switch (file_ext)
|
|
{
|
|
case ".xls":
|
|
workBook = new HSSFWorkbook(filestream);
|
|
break;
|
|
|
|
case ".xlsx":
|
|
workBook = new XSSFWorkbook(filestream);
|
|
break;
|
|
|
|
default: throw new ArgumentException("非法后缀");
|
|
}
|
|
|
|
var sheet = workBook.GetSheetAt(0);
|
|
var rownum = sheet.LastRowNum;
|
|
|
|
for (int i = 1; i <= rownum; i++)
|
|
{
|
|
try
|
|
{
|
|
var row = sheet.GetRow(i);
|
|
if (row == null)
|
|
break;
|
|
var s = row.Cells[1].RichStringCellValue;
|
|
if (string.IsNullOrEmpty(s.String)) continue;
|
|
|
|
ImportGiftOrderDto bill_Account = new ImportGiftOrderDto()
|
|
{
|
|
OrderId = row.Cells[0].ToString(),
|
|
ProductName = row.Cells[1].ToString(),
|
|
ProductCode = row.Cells[2].ToString(),
|
|
DeptName = row.Cells[3].ToString(),
|
|
Day = row.Cells[4].ToString()
|
|
};
|
|
|
|
result.Add(bill_Account);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
LogHelper.Error($"异常行：{i}", ex);
|
|
throw (new Exception($"异常行：{i}", ex));
|
|
}
|
|
}
|
|
return result;
|
|
}
|
|
}
|
|
} |