public void Execute(IJobExecutionContext context)
{
string JobName = "OrderProfit";
string CanRun = ConfigurationManager.AppSettings["Run" + JobName].ToString();
if (CanRun == "true")
{
if (!IsRun)
{
LokFuEntity Entity = new LokFuEntity();
IsRun = true;
try
{
Log.Write(JobName + "任务开始执行！");
//-------------------------------------------------------
#region 任务主体
IList <Orders> List = Entity.Orders.Where(n => n.RunSplit == 1).Take(50).ToList();
foreach (var p in List)
{
p.RunSplit = 2;
}
Entity.SaveChanges();
foreach (var O in List)
{
if (O.TType == 1)//银联卡支付
{
OrderRecharge OrderRecharge = Entity.OrderRecharge.FirstOrDefault(n => n.OId == O.TNum);
if (OrderRecharge != null)
{
OrderRecharge = OrderRecharge.PayAgent(Entity, 1, O.FrozenState);
O.AgentPayGet = (decimal)OrderRecharge.AgentPayGet;
O.AgentState = 1;
}
}
if (O.TType == 2)//提现
{
OrderCash OrderCash = Entity.OrderCash.FirstOrDefault(n => n.OId == O.TNum);
if (OrderCash != null)
{
OrderCash = OrderCash.PayAgent(Entity, 1);
O.AgentPayGet = (decimal)OrderCash.AgentCashGet;
}
}
if (O.TType == 3)//转帐
{
OrderTransfer OrderTransfer = Entity.OrderTransfer.FirstOrDefault(n => n.OId == O.TNum);
if (OrderTransfer != null)
{
OrderTransfer = OrderTransfer.PayAgent(Entity, 1);
O.AgentPayGet = (decimal)OrderTransfer.AgentPayGet;
}
}
if (O.TType == 5)//房租
{
OrderHouse OrderHouse = Entity.OrderHouse.FirstOrDefault(n => n.OId == O.TNum);
if (OrderHouse != null)
{
OrderHouse = OrderHouse.PayAgent(Entity, 1);
O.AgentPayGet = (decimal)OrderHouse.AgentPayGet;
}
}
if (O.TType == 6)//升级
{
VIPOrder VIPOrder = Entity.VIPOrder.FirstOrDefault(n => n.TNum == O.TNum);
if (VIPOrder != null)
{
VIPOrder = VIPOrder.PayAgent(Entity, 1);
O.AgentPayGet = (decimal)VIPOrder.SplitMoney;
O.AgentState = 1;
}
}
if (O.TType == 7 || O.TType == 8 || O.TType == 9)//扫码 NFC
{
OrderF2F OrderF2F = Entity.OrderF2F.FirstOrDefault(n => n.OId == O.TNum);
if (OrderF2F != null)
{
OrderF2F = OrderF2F.PayAgent(Entity, 1, O.FrozenState);
O.AgentPayGet = (decimal)OrderF2F.AgentPayGet;
}
}
if (O.TType == 10)//代理自助开通
{
DaiLiOrder DaiLiOrder = Entity.DaiLiOrder.FirstOrDefault(n => n.OId == O.TNum);
if (DaiLiOrder != null)
{
DaiLiOrder = DaiLiOrder.PayAgent(Entity, 1);
O.AgentPayGet = (decimal)DaiLiOrder.AgentGet;
O.AgentState = 1;
}
}
O.RunSplit = 3;
Entity.SaveChanges();
}
#endregion
//-------------------------------------------------------
Log.Write(JobName + "任务执行结束！[共计" + List.Count + "条]");
}
catch (Exception Ex)
{
Log.Write(JobName + "任务执行过程出错！", Ex);
}
IsRun = false;
}
else
{
Log.Write(JobName + "任务还在执行中！");
}
}
}
public void Post()
{
string Data = DataObj.GetData();
if (Data.IsNullOrEmpty())
{
DataObj.OutError("1000");
return;
}
JObject json = new JObject();
try
{
json = (JObject)JsonConvert.DeserializeObject(Data);
}
catch (Exception Ex)
{
Log.Write("[OrderDaiLi_3_0]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
DaiLiOrder DaiLiOrder = new DaiLiOrder();
DaiLiOrder = JsonToObject.ConvertJsonToModel(DaiLiOrder, json);
UserTrack UserTrack = new UserTrack();
UserTrack = JsonToObject.ConvertJsonToModel(UserTrack, json);
//设置开通等级
if (DaiLiOrder.Tier.IsNullOrEmpty())
{
DataObj.OutError("1000");
return;
}
if (DaiLiOrder.X.IsNullOrEmpty() || DaiLiOrder.Y.IsNullOrEmpty())
{
DataObj.OutError("1000");
return;
}
//获取用户信息
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == DaiLiOrder.Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
if (baseUsers.CardStae != 2)//未实名认证
{
DataObj.OutError("2006");
return;
}
if (baseUsers.MiBao != 1)//未设置支付密码
{
DataObj.OutError("2008");
return;
}
//获取分支机构信息
//AgentType AgentType = Entity.AgentType.FirstOrNew(n => n.Id == DaiLiOrder.Levels);
//if (AgentType.Id.IsNullOrEmpty()) {
// DataObj.OutError("1000");
// return;
//}
//if (AgentType.AgentID != baseUsers.Agent) {
// //用户代理与开通等级代理不同
// DataObj.OutError("1000");
// return;
//}
SysAgent SysAgent = Entity.SysAgent.FirstOrNew(o => o.LinkMobile == baseUsers.UserName);
if (!SysAgent.LinkMobile.IsNullOrEmpty())
{
if (SysAgent.Tier < 5 || DaiLiOrder.Tier >= SysAgent.Tier)
{
DataObj.OutError("9000");
return;
}
}
DaiLiOrder.UId = baseUsers.Id;
DaiLiOrder.UserName = baseUsers.UserName;
DaiLiOrder.TureName = baseUsers.TrueName;
DaiLiOrder.Agent = baseUsers.Agent;
DaiLiOrder.AId = baseUsers.AId;
// DaiLiOrder.Amoney = AgentType.RegisterFee;
DaiLiOrder.OrderState = 1;
DaiLiOrder.PayState = 0;
DaiLiOrder.AddTime = DateTime.Now;
DaiLiOrder.SameGet = 0;
//这里是利润计算==========
DaiLiOrder.AIdGet = Convert.ToDouble(DaiLiOrder.Amoney); //总利润
DaiLiOrder.AgentGet = 0; //分支机构佣金设置为0，待分润计算后再写入
DaiLiOrder.AgentState = 0;
//写入订单总表
Orders Orders = new Orders();
Orders.UId = DaiLiOrder.UId;
Orders.TName = "自助开通代理";
Orders.RUId = 0;
Orders.RName = string.Empty;
Orders.TType = 10;
Orders.TState = 1;
Orders.Amoney = DaiLiOrder.Amoney;
Orders.Poundage = 0;
Orders.AddTime = DateTime.Now;
Orders.PayState = 0;
Orders.PayWay = 15;
Orders.Agent = DaiLiOrder.Agent;
Orders.AgentState = 0;
Orders.AId = DaiLiOrder.AId;
Orders.FId = 0;
string OrderAddress = DaiLiOrder.OrderAddress;
if (OrderAddress.IsNullOrEmpty())
{
OrderAddress = Utils.GetAddressByGPS(DaiLiOrder.X, DaiLiOrder.Y);
}
Orders.OrderAddress = OrderAddress;
Orders.X = DaiLiOrder.X;
Orders.Y = DaiLiOrder.Y;
Entity.Orders.AddObject(Orders);
Entity.SaveChanges();
Entity.Refresh(RefreshMode.StoreWins, Orders);
DaiLiOrder.OId = Orders.TNum;
Entity.DaiLiOrder.AddObject(DaiLiOrder);
Entity.SaveChanges();
//=======================================
UserTrack.ENo = DataObj.ENo;
UserTrack.OPType = Orders.PayName;
UserTrack.UserName = Orders.TNum;
UserTrack.GPSAddress = Orders.OrderAddress;
UserTrack.GPSX = Orders.X;
UserTrack.GPSY = Orders.Y;
Orders.SeavGPSLog(UserTrack, Entity);
//=======================================
Orders.SendMsg(Entity);//发送消息类
//=======================================
Orders.Cols = "TNum,PayId,Amoney,PayState";
string TNum = Orders.TNum;
string Sign = (TNum + "NewPay").GetMD5().Substring(8, 8);
// Orders.PayId = PayPath + "/pay/" + TNum + ".html?sign=" + Sign;
Orders.PayId = PayPath + "/mobile/orders/GoPay.html?sign=" + Sign + "&tnum=" + TNum;
//=======================================
//获取最佳支付通道
#region 结算中心
//IList<PayConfig> PayConfigList = Entity.PayConfig.Where(n => n.State == 1).OrderBy(n => n.Cost).ToList();
//IList<SysControl> SysControlList = Entity.SysControl.OrderBy(n => n.Sort).ToList();//SysControl
//IList<SysControl> SCList = new List<SysControl>();
//IList<PayConfig> PCList = new List<PayConfig>();
//foreach (var p in SysControlList)
//{
// SysControl T = p.ChkState();
// if (T.State == 1)
// {
// SCList.Add(p);
// }
//}
//foreach (var p in PayConfigList)
//{
// SysControl T = SCList.FirstOrDefault(n => n.PayWay == p.Id);
// if (T != null)
// {
// if (Orders.Amoney >= (decimal)T.SNum && Orders.Amoney <= (decimal)T.ENum)
// {
// PCList.Add(p);
// }
// }
//}
//IList<PayConfig> CashList = PCList.Where(n => n.GroupType == "Cash").OrderBy(n => n.Cost).ToList();
//IList<PayConfig> BankList = PCList.Where(n => n.GroupType == "Bank").OrderBy(n => n.Cost).ToList();
//IList<PayConfig> WxList = PCList.Where(n => n.GroupType == "WeiXin").OrderBy(n => n.Cost).ToList();
//IList<PayConfig> AliList = PCList.Where(n => n.GroupType == "AliPay").OrderBy(n => n.Cost).ToList();
//IList<PayConfig> List = new List<PayConfig>();
//if (CashList.Count > 0)
//{
// PayConfig Cash = new PayConfig();
// Cash.GroupType = "Cash";
// Cash.Name = "余额支付";
// Cash.State = 1;
// Cash.Cols = "Name,GroupType,State";
// List.Add(Cash);
//}
//if (BankList.Count > 0)
//{
// PayConfig Bank = new PayConfig();
// Bank.GroupType = "Bank";
// Bank.Name = "银联支付";
// Bank.State = 1;
// Bank.Cols = "Name,GroupType,State";
// List.Add(Bank);
//}
//if (WxList.Count > 0)
//{
// PayConfig Wx = new PayConfig();
// Wx.GroupType = "WeiXin";
// Wx.Name = "微信支付";
// Wx.State = 0;
// Wx.Cols = "Name,GroupType,State";
// List.Add(Wx);
//}
//if (AliList.Count > 0)
//{
// PayConfig Ali = new PayConfig();
// Ali.GroupType = "AliPay";
// Ali.Name = "支付宝支付";
// Ali.State = 1;
// Ali.Cols = "Name,GroupType,State";
// List.Add(Ali);
//}
//string PCString = List.EntityToJson();
//JArray PCJson = (JArray)JsonConvert.DeserializeObject(PCString);
//Orders.PayConfig = PCJson;
//Orders.Cols += ",PayConfig";
#endregion
//Orders.paycon
DataObj.Data = Orders.OutJson();
DataObj.Code = "0000";
DataObj.OutString();
}
public void XLSDo(Orders Orders, EFPagingInfo <Orders> p, bool?IsShowSupAgent, int TimeType = 1)
{
if (IsShowSupAgent == null)
{
IsShowSupAgent = false;
}
p = this.Condition(Orders, p, IsShowSupAgent, TimeType);
p.PageSize = 99999999;
p.OrderByList.Add("Id", "DESC");
IPageOfItems <Orders> OrdersList = Entity.Selects <Orders>(p);
if (OrdersList.Count() > 0)
{
#region 导出
string file = Server.MapPath("/template") + "\\finorders.xlsx";
ExcelPackage package = new ExcelPackage(new FileInfo(file), true);
var sheet = package.Workbook.Worksheets[1];
var cells = sheet.Cells;
int Rows = OrdersList.Count();
//设置数据开始行
int Befor = 2;
sheet.InsertRow(Befor + 1, Rows - 1, Befor);
int i = Befor;
sheet.Row(i - 1).Height = 22;//设置行高
int maxCol = 0;
//获取机构及管理员
IList <Orders> List = OrdersList.GroupBy(n => n.UId).Select(n => n.First()).ToList();
List <int> UId = new List <int>();
foreach (var pp in List)
{
UId.Add(pp.UId);
}
IList <Users> UsersList = Entity.Users.Where(n => n.State == 1 && UId.Contains(n.Id)).ToList();
IList <PayConfig> PayConfigList = Entity.PayConfig.Where(n => n.State == 1).ToList();
IList <SysAgent> SysAgentList = Entity.SysAgent.ToList();
foreach (var item in OrdersList)
{
#region MyRegion
string AName = "--";
if (item.AId > 0)
{
SysAgent SA = SysAgentList.FirstOrNew(n => n.Id == item.Agent);
if (!SA.Name.IsNullOrEmpty())
{
AName = SA.Name;
}
}
string BName = "--";
Users OU = UsersList.FirstOrNew(n => n.Id == item.UId);
if (!OU.TrueName.IsNullOrEmpty())
{
BName = OU.TrueName;
}
PayConfig PayConfig = PayConfigList.FirstOrNew(n => n.Id == item.PayWay);
sheet.Row(i).Height = 22;//设置行高
//机构
cells["A" + i].Value = AName;
//交易号
cells["B" + i].Value = item.TNum;
//交易商户
cells["C" + i].Value = OU.NeekName + "[" + OU.TrueName + "]";
//交易类型
cells["D" + i].Value = item.GetTTName();
//交易内容
cells["E" + i].Value = item.GetPayNameWithTName();
//交易金额
cells["F" + i].Value = item.Amoney.ToString("f2");
//交易时间
cells["G" + i].Value = item.PayTime;
//入账时间
cells["H" + i].Value = (item.InTimed != null?Convert.ToDateTime(item.InTimed).ToString():"");
//支付方式
cells["I" + i].Value = PayConfig.Name;
//订单状态
cells["J" + i].Value = item.GetState();
string temp = string.Empty;
if (item.TType == 2 || item.TType == 5)
{
temp = "T+" + item.TrunType;
}
if (item.TType == 1 || item.TType == 7 || item.TType == 8 || item.TType == 9)
{
temp = "T+" + item.LagEntryDay;
}
//接收方式
cells["K" + i].Value = temp;
double I = 0, K = 0, N = 0;
decimal J = 0, L = 0, M = 0;
string Is = "";
#region MyRegion
if (item.TType == 1)
{ //银联卡支付订单
OrderRecharge OrderRecharge = Entity.OrderRecharge.FirstOrNew(n => n.OId == item.TNum);
I = OrderRecharge.UserRate; //商户费率
J = OrderRecharge.Poundage; //手续费
K = OrderRecharge.SysRate; //第三方费率
L = ((decimal)OrderRecharge.SysRate * OrderRecharge.Amoney).Ceiling(); //第三方手续费
N = OrderRecharge.AgentPayGet; //分支机构提成
M = OrderRecharge.Poundage - (decimal)OrderRecharge.SysRate * OrderRecharge.Amoney - (decimal)OrderRecharge.AgentPayGet; //利润
}
if (item.TType == 2)
{ //提现订单
OrderCash OrderCash = Entity.OrderCash.FirstOrNew(n => n.OId == item.TNum);
I = 0;
if (!OrderCash.ECash.IsNullOrEmpty() && !OrderCash.Cash.IsNullOrEmpty())
{
Is = OrderCash.ECash.ToMoney() + "+" + (OrderCash.Cash * 100).ToString("F2") + "%";
}
else if (!OrderCash.ECash.IsNullOrEmpty())
{
Is = OrderCash.ECash.ToMoney();
}
else if (!OrderCash.Cash.IsNullOrEmpty())
{
Is = (OrderCash.Cash * 100).ToString("F2") + "%";
}
else
{
Is = "0";
}
J = (decimal)OrderCash.UserRate; //手续费
K = 0; //第三方费率
L = OrderCash.CashRate; //第三方手续费
N = OrderCash.AgentCashGet; //分支机构提成
M = (decimal)OrderCash.UserRate - OrderCash.CashRate - (decimal)OrderCash.AgentCashGet; //利润
}
if (item.TType == 3)
{ //转帐订单
OrderTransfer OrderTransfer = Entity.OrderTransfer.FirstOrNew(n => n.OId == item.TNum);
I = OrderTransfer.UserRate; //商户费率
J = OrderTransfer.Poundage; //手续费
K = OrderTransfer.SysRate; //第三方费率
L = ((decimal)OrderTransfer.SysRate * OrderTransfer.Amoney).Ceiling(); //第三方手续费
N = OrderTransfer.AgentPayGet; //分支机构提成
M = OrderTransfer.Amoney - OrderTransfer.PayMoney - L - (decimal)OrderTransfer.AgentPayGet; //利润
}
if (item.TType == 5)
{ //付房租订单
OrderHouse OrderHouse = Entity.OrderHouse.FirstOrNew(n => n.OId == item.TNum);
I = OrderHouse.UserRate + (double)OrderHouse.CashRate; //商户费率
J = OrderHouse.Poundage; //手续费
K = OrderHouse.SysRate; //第三方费率
L = ((decimal)OrderHouse.SysRate * OrderHouse.Amoney).Ceiling(); //第三方手续费
N = OrderHouse.AgentPayGet; //分支机构提成
M = OrderHouse.Amoney - OrderHouse.PayMoney - L - (decimal)OrderHouse.AgentPayGet; //利润
}
if (item.TType == 6)
{ //升级订单
PayConfigOrder PayConfigOrder = Entity.PayConfigOrder.FirstOrNew(n => n.OId == item.TNum);
I = 0; //商户费率
J = PayConfigOrder.Poundage; //手续费
K = PayConfigOrder.SysRate; //第三方费率
L = ((decimal)PayConfigOrder.SysRate * PayConfigOrder.Amoney).Ceiling(); //第三方手续费
N = PayConfigOrder.AgentGet; //分支机构提成
M = PayConfigOrder.Amoney - (decimal)PayConfigOrder.AgentGet; //利润
}
if (item.TType == 7 || item.TType == 8 || item.TType == 9)
{ //当面付
OrderF2F OrderF2F = Entity.OrderF2F.FirstOrNew(n => n.OId == item.TNum);
I = OrderF2F.UserRate; //商户费率
J = OrderF2F.Poundage; //手续费
K = OrderF2F.SysRate; //第三方费率
L = ((decimal)OrderF2F.SysRate * OrderF2F.Amoney).Ceiling(); //第三方手续费
N = OrderF2F.AgentPayGet; //分支机构提成
M = OrderF2F.Poundage - (decimal)OrderF2F.SysRate * OrderF2F.Amoney - (decimal)OrderF2F.AgentPayGet; //利润
}
if (item.TType == 10)
{ //升级订单
DaiLiOrder DaiLiOrder = Entity.DaiLiOrder.FirstOrNew(n => n.OId == item.TNum);
I = 0; //商户费率
J = 0; //手续费
K = 0; //第三方费率
L = 0; //第三方手续费
N = DaiLiOrder.AgentGet; //分支机构提成
M = DaiLiOrder.Amoney - (decimal)DaiLiOrder.AgentGet; //利润
}
#endregion
//用户费率9
if (item.TType == 2)
{
cells["L" + i].Value = Is;
}
else
{
cells["L" + i].Value = I;
}
//用户手续费10
cells["M" + i].Value = J;
//支出费率11 系统费率
cells["N" + i].Value = K;
//支出手续费12
cells["O" + i].Value = L;
//利润13
cells["P" + i].Value = M;
//结算金额14
cells["Q" + i].Value = N;
i++;
#endregion
}
sheet.Row(i).Height = 40;//设置行高
//交易总额
cells["F" + i].Formula = "SUM(F" + Befor + ":F" + (i - 1) + ")";
//用户手续费10
cells["M" + i].Formula = "SUM(M" + Befor + ":M" + (i - 1) + ")";
//支出手续费12
cells["O" + i].Formula = "SUM(O" + Befor + ":O" + (i - 1) + ")";
//利润13
cells["P" + i].Formula = "SUM(P" + Befor + ":P" + (i - 1) + ")";
//结算金额14
cells["Q" + i].Formula = "SUM(Q" + Befor + ":Q" + (i - 1) + ")";
i--;
maxCol = 17;
//cells["B" + (i + 2)].Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
sheet.Cells[Befor, 1, i, maxCol].Style.Border.Left.Style = ExcelBorderStyle.Thin;
sheet.Cells[Befor, 1, i, maxCol].Style.Border.Right.Style = ExcelBorderStyle.Thin;
sheet.Cells[Befor, 1, i, maxCol].Style.Border.Top.Style = ExcelBorderStyle.Thin;
sheet.Cells[Befor, 1, i, maxCol].Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
sheet.Cells[Befor, 1, i, maxCol].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;//居中
sheet.Cells[Befor, 7, i, 7].Style.Numberformat.Format = "yyyy-mm-dd HH:mm:ss";
sheet.Cells[Befor, 8, i, 8].Style.Numberformat.Format = "yyyy-mm-dd HH:mm:ss";
sheet.Cells[Befor, 12, i, 12].Style.Numberformat.Format = "#0.00%";
sheet.Cells[Befor, 14, i, 14].Style.Numberformat.Format = "#0.00%";
i++;
sheet.Cells[Befor, 6, i, 6].Style.Numberformat.Format = "\"¥\"#,##0.00_);[Red](\"¥\"#,##0.00)";
sheet.Cells[Befor, 13, i, 13].Style.Numberformat.Format = "\"¥\"#,##0.00_);[Red](\"¥\"#,##0.00)";
sheet.Cells[Befor, 15, i, 15].Style.Numberformat.Format = "\"¥\"#,##0.00_);[Red](\"¥\"#,##0.00)";
sheet.Cells[Befor, 16, i, 16].Style.Numberformat.Format = "\"¥\"#,##0.00_);[Red](\"¥\"#,##0.00)";
sheet.Cells[Befor, 17, i, 17].Style.Numberformat.Format = "\"¥\"#,##0.00_);[Red](\"¥\"#,##0.00)";
Response.BinaryWrite(package.GetAsByteArray());
//输出
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment; filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + new Random().Next(10, 99) + ".xlsx");
#endregion
}
else
{
Response.Write("暂无符合条件数据");
}
}
