731 lines
31 KiB
C#
731 lines
31 KiB
C#
using Ninject;
|
||
using System;
|
||
using System.Collections.Generic;
|
||
using System.Data;
|
||
using System.Data.SqlClient;
|
||
using System.Globalization;
|
||
using System.IO;
|
||
using System.Web;
|
||
using System.Web.Mvc;
|
||
using WX.CRM.BLL;
|
||
using WX.CRM.BLL.Base;
|
||
using WX.CRM.BLL.Util;
|
||
using WX.CRM.Common;
|
||
using WX.CRM.IBLL.Base;
|
||
using WX.CRM.IBLL.Res;
|
||
using WX.CRM.IBLL.weapp;
|
||
using WX.CRM.IBLL.Wx;
|
||
using WX.CRM.Model.Entity;
|
||
using WX.CRM.WebHelper;
|
||
|
||
namespace WX.CRM.WEB.Controllers.WeiXin
|
||
{
|
||
public class SzzyOrderSHController : BaseController
|
||
{
|
||
private IWX_SZZYORDER wx_SzzyOrder_BL;
|
||
|
||
private IWX_SZZYPRODUCT wx_SzzyProduct_BL;
|
||
|
||
private IWX_SZZYSUBPRODUCT wx_SzzySubProduct_BL;
|
||
|
||
private IRES_CUSTOMERDETAIL res_CustomerDetail_BL;
|
||
|
||
private IRES_CUSTOMER_Q res_Customer_Q_BL;
|
||
|
||
private IRES_CUSTOMER res_Customer_BL;
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
[Inject]
|
||
public CACHE_BL cache_BL { get; set; }
|
||
|
||
[Inject]
|
||
public IWX_RCONTACT wx_Rcontact_BL { get; set; }
|
||
|
||
[Inject]
|
||
public IWX_COMMISSIONRULE wx_CommissionRule_BL { get; set; }
|
||
|
||
[Inject]
|
||
public IWX_ARRIVALPAYLOG wx_ArrivalPayLog_BL { get; set; }
|
||
|
||
[Inject]
|
||
public IWX_SZZYORDER_REFUND wx_szzyorder_refund_bl { get; set; }
|
||
|
||
[Inject]
|
||
public IWEAPP_USERINFO weapp_UserInfo_BL { get; set; }
|
||
|
||
[Inject]
|
||
public IRES_RESOURCEMOBILE_Q res_ResourceMobile_Q_BL { get; set; }
|
||
|
||
[Inject]
|
||
public IBAS_INNERUSER_Q bas_InnerUser_Q_BL { get; set; }
|
||
|
||
[Inject]
|
||
public IBAS_SALESDEPARTMENT_Q bas_SalesDept_Q_BL { get; set; }
|
||
|
||
[Inject]
|
||
public IWX_COMMISSIONRULE _wxCommissionrule { get; set; }
|
||
|
||
private ValidationErrors errors = new ValidationErrors();
|
||
|
||
|
||
|
||
public SzzyOrderSHController(IWX_SZZYORDER wx_SzzyOrder_BL, IWX_SZZYPRODUCT wx_SzzyProduct_BL, IWX_SZZYSUBPRODUCT wx_SzzySubProduct_BL, IRES_CUSTOMERDETAIL res_CustomerDetail_BL, IRES_CUSTOMER_Q res_Customer_Q_BL, IRES_CUSTOMER res_Customer_BL)
|
||
{
|
||
this.wx_SzzyOrder_BL = wx_SzzyOrder_BL;
|
||
this.wx_SzzyProduct_BL = wx_SzzyProduct_BL;
|
||
this.wx_SzzySubProduct_BL = wx_SzzySubProduct_BL;
|
||
this.res_CustomerDetail_BL = res_CustomerDetail_BL;
|
||
this.res_Customer_Q_BL = res_Customer_Q_BL;
|
||
this.res_Customer_BL = res_Customer_BL;
|
||
}
|
||
|
||
|
||
|
||
#region 订单列表
|
||
|
||
[AuthorizeRedirect(Roles = InitRights.CONST_订单列表_上海分部)]
|
||
public ActionResult OrderList()
|
||
{
|
||
//ToolBar
|
||
ToolBar tool = new ToolBar();
|
||
string[] toolbtn = new ToolButtonView().ToolButtonRight(InitRights.订单列表_上海分部, userRightId);
|
||
tool.AllowButton(toolbtn);
|
||
tool.AddOtherButton("Other1", "补单", "icon-edit", "SupplementOrder_Click", true);
|
||
tool.AddOtherButton("Other2", "导出", "icon-export", "export_Click", true);
|
||
tool.AddOtherButton("Other3", "上传到账信息", "icon-export", "upload_Click", true);
|
||
tool.AddOtherButton("Other4", "定金支付", "icon-edit", "Prepayment_Click", true);
|
||
ViewBag.ToolBar = tool;
|
||
//table
|
||
Pager pager = new Pager() { page = 1, rows = 20 };
|
||
string tableId = "tablist";
|
||
Table tab = new Table(tableId);
|
||
//tab.AddHiddenHeadCol("ORDERID", "编号");
|
||
//tab.AddHeadCol("RESID", "10%", "客户ID");
|
||
//tab.AddHeadCol("INNERUSERID", "4%", "工号");
|
||
//tab.AddHeadCol("SUBPRODUCTNAME", "7%", "产品");
|
||
//tab.AddHeadCol("NEEDPAY", "5%", "应付金额");
|
||
//tab.AddHeadCol("FINALPAY", "5%", "实付金额");
|
||
//tab.AddHeadCol("ARRIVALPAY", "5%", "到账金额");
|
||
//tab.AddHeadCol("ARRIVALTIME", "9%", "到账时间");
|
||
//tab.AddHeadCol("SZZYORDERID", "7%", "上证综研订单ID");
|
||
//tab.AddHeadCol("ORDERTYPE", "4%", "订单类型");
|
||
//tab.AddHeadCol("ORDERSTATUS", "4%", "订单状态");
|
||
//tab.AddHeadCol("CTIME", "9%", "下单时间");
|
||
//tab.AddHeadCol("OTIME", "9%", "开通时间");
|
||
//tab.AddHeadCol("FCTEXT", "8%", "订单分成");
|
||
//tab.AddHeadCol("SOURCE", "4%", "客户来源");
|
||
//tab.AddHeadCol("CUSTOMERUSERNAME", "8%", "客户微信用户名");
|
||
|
||
tab.AddHiddenHeadCol("ORDERID", "编号");
|
||
tab.AddHeadCol("RESID", "", "客户ID");
|
||
tab.AddHeadCol("INNERUSERID", "", "工号");
|
||
tab.AddHeadCol("SUBPRODUCTNAME", "", "产品");
|
||
tab.AddHeadCol("NEEDPAY", "", "应付金额");
|
||
tab.AddHeadCol("FINALPAY", "", "实付金额");
|
||
tab.AddHeadCol("ARRIVALPAY", "", "到账金额");
|
||
tab.AddHeadCol("ARRIVALTIME", "", "到账时间");
|
||
tab.AddHeadCol("SZZYORDERID", "", "订单ID");
|
||
tab.AddHeadCol("CNAME", "", "客户姓名");
|
||
tab.AddHeadCol("ORDERTYPE", "", "订单类型");
|
||
tab.AddHeadCol("ORDERSTATUS", "", "订单状态");
|
||
tab.AddHeadCol("CTIME", "", "下单时间");
|
||
tab.AddHeadCol("OTIME", "", "开通时间");
|
||
//tab.AddHeadCol("FCTEXT", "", "订单分成");
|
||
//tab.AddHeadCol("SOURCE", "", "客户来源");
|
||
//tab.AddHeadCol("CUSTOMERUSERNAME", "", "客户微信用户名");
|
||
//tab.AddHeadCol("ISOPEN", "", "参与分成");
|
||
|
||
tab.AddHeadRow();
|
||
ViewBag.gridTable = tab.GetHead() + Pagination.GetPage(pager, tableId, "5,10,15,20");
|
||
ViewBag.productList = getAllProductList();
|
||
ViewBag.inneruserid = UserId;
|
||
ViewBag.userGroupId = userGroupId;
|
||
ViewBag.saleDeptId = saleDeptId;
|
||
ViewBag.roleCodes = DataCacheHelper.GetCache().Get_RoleCodes(userRoleId);
|
||
return View();
|
||
}
|
||
|
||
[HttpPost]
|
||
[AuthorizeRedirect(Roles = InitRights.CONST_订单列表_上海分部)]
|
||
public JsonResult GetOrderList(Pager pager, string resId, string contractCode, string szzyOrderId, decimal productId, decimal subProductId, decimal orderType, string stime, string etime, string orderStatus, string ostime, string oetime, string fcText, string cname, bool? smallorder, string columns)
|
||
{
|
||
decimal p_saleDeptId = Request["saleDeptId"].GetDecimal(0);
|
||
string groupId = Request["groupId"];
|
||
decimal innerUserId = Request["userId"].GetDecimal(0);
|
||
decimal? teamEid = null;
|
||
List<WX_SZZYORDER> list = wx_SzzyOrder_BL.GetList_SH(ref pager, resId, contractCode, szzyOrderId, productId, subProductId, orderType, stime, etime, null, 0, orderStatus, ostime, oetime, fcText, cname, 1619629758);
|
||
Table table = new Table(columns, true);
|
||
table.gridPager = pager;
|
||
foreach (var model in list)
|
||
{
|
||
table.AddHiddenCol(model.ORDERID);
|
||
var linkUrl = string.Format("<a href=\"javascript:parent.ChildAddTab('{0}', '{1}', '')\">{2}</a>"
|
||
, "客户详细"
|
||
, "/Csvr/CustomerInfo/CustomerDetail?resid=" + model.RESID
|
||
, model.RESID);
|
||
if (model.RESID == "合计")
|
||
table.AddCol(model.RESID);
|
||
else
|
||
table.AddCol(model.RESID);
|
||
table.AddCol(InnerUserHelper.Instance.GetEid(model.INNERUSERID));
|
||
table.AddCol(model.SUBPRODUCTNAME);
|
||
table.AddCol(model.NEEDPAY);
|
||
table.AddCol(model.FINALPAY);
|
||
table.AddCol(model.ARRIVALPAY);
|
||
table.AddCol(model.ARRIVALTIME);
|
||
table.AddCol(model.SZZYORDERID);
|
||
var subName = model.CNAME;
|
||
if (!string.IsNullOrEmpty(subName) && subName.Length > 3)
|
||
subName = string.Format("<span title=\"{0}\">{1}</span>", model.CNAME, model.CNAME.Substring(0, 3) + "...");
|
||
table.AddCol(subName);
|
||
//table.AddCol(model.ORDERID);
|
||
table.AddCol(getOrderTypeStr(model.ORDERTYPE.Value));
|
||
table.AddCol(getOrderStatusStr(model.ORDERSTATUS));
|
||
table.AddCol(model.CTIME);
|
||
table.AddCol(model.OTIME);
|
||
//var payInfoUrl = string.Format("<a href=\"javascript:GetWxPayInfo('{0}')\">获取二维码</a>", model.ORDERID);
|
||
//table.AddCol(payInfoUrl);
|
||
//table.AddCol(model.FCTEXT);
|
||
//table.AddCol(getSourceText(model.SOURCE));
|
||
//table.AddCol(model.CUSTOMERUSERNAME);
|
||
//table.AddCol(model.ISOPEN == 1 ? "是" : "");
|
||
table.AddRow();
|
||
}
|
||
var json = new
|
||
{
|
||
totalPages = pager.totalPages,
|
||
totalRows = pager.totalRows,
|
||
rowsList = table.GetRows()
|
||
};
|
||
return Json(json, JsonRequestBehavior.AllowGet);
|
||
}
|
||
public FileResult Export(string resId, string contractCode, string szzyOrderId, decimal productId, decimal subProductId, decimal orderType, string stime, string etime, string orderStatus, string ostime, string oetime, string fcText, string cname, bool? smallorder)
|
||
{
|
||
decimal p_saleDeptId = Request["saleDeptId"].GetDecimal(0);
|
||
string groupId = Request["groupId"];
|
||
decimal innerUserId = Request["userId"].GetDecimal(0);
|
||
decimal? teamEid = null;
|
||
|
||
string checkedFilds = PageRequest.GetQueryString("checkedFilds");
|
||
checkedFilds = checkedFilds.Replace("[]", "");
|
||
string checkedTitles = PageRequest.GetQueryString("checkedTitles");
|
||
Pager pager = new Pager() { page = 1, rows = int.MaxValue };
|
||
List<WX_SZZYORDER> list = wx_SzzyOrder_BL.GetList_SH(ref pager, resId, contractCode, szzyOrderId, productId, subProductId, orderType, stime, etime, null, 0, orderStatus, ostime, oetime, fcText, cname, 1619629758);
|
||
return File(ExcelHelper.ExportListModelToExcel<WX.CRM.Model.Entity.WX_SZZYORDER>(list, "订单列表", 10000, checkedFilds, checkedTitles, DataFormart), "application/ms-excel", PageRequest.GetDlownLoadName("订单列表.xls"));
|
||
}
|
||
//用作委托传递
|
||
public string DataFormart(string key, object value)
|
||
{
|
||
string formartValue = string.Empty;
|
||
switch (key)
|
||
{
|
||
case "SOURCE":
|
||
formartValue = value != null ? Utility.getSourceText(value.ToString()) : ""; break;
|
||
case "INNERUSERID":
|
||
formartValue = InnerUserHelper.Instance.GetEidByUserId(Convert.ToDecimal(value)).ToString(); break;
|
||
case "ORDERTYPE":
|
||
formartValue = getOrderTypeStr(Convert.ToDecimal((value ?? "0").ToString())); break;
|
||
case "ORDERSTATUS":
|
||
formartValue = getOrderStatusStr((value ?? "0").ToString()).Replace("<font style=\"color:red\">", "").Replace("</span>", ""); break;
|
||
case "FCTEXT":
|
||
formartValue = "";
|
||
if (value != null && !string.IsNullOrWhiteSpace(value.ToString()))
|
||
{
|
||
string[] strs = value.ToString().Split(new string[] { " " }, StringSplitOptions.None);
|
||
foreach (var s in strs)
|
||
{
|
||
string[] strs2 = s.Split(':');
|
||
decimal eid = 0;
|
||
decimal.TryParse(strs2[0], out eid);
|
||
formartValue += InnerUserHelper.Instance.GetGroupName(InnerUserHelper.Instance.GetGroupId(InnerUserHelper.Instance.GetUserIdByEid(eid))) + "-" + strs2[0] + ":" + (strs2.Length > 1 ? strs2[1] : "") + " ";
|
||
}
|
||
}
|
||
break;
|
||
default: formartValue = string.Format("{0}", value); break;
|
||
}
|
||
return formartValue;
|
||
}
|
||
|
||
[HttpGet]
|
||
[AuthorizeToolBar(InitRights.CONST_订单列表_上海分部, InitToolBar.CONST_Other1)]
|
||
public ActionResult SupplementOrder()
|
||
{
|
||
var saleDeptList = bas_SalesDept_Q_BL.GetList();
|
||
List<SelectListItem> saleDeptItemList = new List<SelectListItem>();
|
||
if (saleDeptList != null)
|
||
{
|
||
foreach (var m in saleDeptList)
|
||
{
|
||
saleDeptItemList.Add(new SelectListItem { Value = m.SALEDEPTID.ToString(), Text = m.DEPTNAME, Selected = m.SALEDEPTID == saleDeptId });
|
||
}
|
||
}
|
||
ViewBag.SaleDeptList = saleDeptItemList;
|
||
ViewBag.productList = getProductList();
|
||
return View(new WX_SZZYORDER());
|
||
}
|
||
|
||
//[HttpPost]
|
||
//[AuthorizeToolBar(InitRights.CONST_订单列表_上海分部, InitToolBar.CONST_Other1)]
|
||
//public JsonResult SupplementOrder(WX_SZZYORDER model, string mobile, string eid, string szzyOrderId,string cname)
|
||
//{
|
||
// if (!ModelState.IsValid)
|
||
// {
|
||
// return JsonHandler.ValidateFailMessage();
|
||
// }
|
||
|
||
// if (!Utility.ChekMobile(mobile))
|
||
// {
|
||
// errors.Add("请填写正确的手机号!");
|
||
// return JsonHandler.UpdateMessage(errors, false);
|
||
// }
|
||
|
||
// if (model.ORDERTYPE == 3)
|
||
// {
|
||
// if (string.IsNullOrWhiteSpace(model.UPGRADEORDERIDS) || !model.TOTALUPGRADEVALUE.HasValue || model.TOTALUPGRADEVALUE <= 0)
|
||
// {
|
||
// errors.Add("升级订单，请输入源订单号和源订单剩余金额！");
|
||
// return JsonHandler.UpdateMessage(errors, false);
|
||
// }
|
||
// if (!ValidateHelper.IsNumber(model.UPGRADEORDERIDS.Replace(",", "")))
|
||
// {
|
||
// errors.Add("输入源订单号格式有误，只能输入数字订单号！");
|
||
// return JsonHandler.UpdateMessage(errors, false);
|
||
// }
|
||
// var upgradeOrderList = model.UPGRADEORDERIDS.Split(',').Select(m => Convert.ToDecimal(m)).ToList();
|
||
// foreach (var orderid in upgradeOrderList)
|
||
// {
|
||
// if (wx_SzzyOrder_BL.Get(m => m.ORDERID == orderid) == null)
|
||
// {
|
||
// errors.Add(string.Format("升级订单，原CRM订单：{0}不存在，请确认后再输入！", orderid.ToString()));
|
||
// return JsonHandler.UpdateMessage(errors, false);
|
||
// }
|
||
// }
|
||
// }
|
||
// decimal convertEid = 0;
|
||
// decimal convertSzzyOrderId = 0;
|
||
// if (!Decimal.TryParse(eid, out convertEid))
|
||
// {
|
||
// errors.Add("请填写正确的员工编号!");
|
||
// return JsonHandler.UpdateMessage(errors, false);
|
||
// }
|
||
// if (!Decimal.TryParse(szzyOrderId, out convertSzzyOrderId))
|
||
// {
|
||
// errors.Add("请填写正确的上证综研订单编号!");
|
||
// return JsonHandler.UpdateMessage(errors, false);
|
||
// }
|
||
|
||
// var userId = InnerUserHelper.Instance.GetUserIdByEid(convertEid);
|
||
// if (userId < 2)
|
||
// {
|
||
// errors.Add("员工编号不存在");
|
||
// return JsonHandler.UpdateMessage(errors, false);
|
||
// }
|
||
|
||
|
||
// if (string.IsNullOrWhiteSpace(cname))
|
||
// {
|
||
// errors.Add("请填写客户姓名");
|
||
// return JsonHandler.UpdateMessage(errors, false);
|
||
// }
|
||
|
||
|
||
// model.EMPLOYEEID = System.Configuration.ConfigurationManager.AppSettings["SzzyEmployeeID"];
|
||
// model.PASSWORD = System.Configuration.ConfigurationManager.AppSettings["SzzyPassword"];
|
||
// var szzyOrder = wx_SzzyOrder_BL.GetSzzyOrder(model.EMPLOYEEID, model.PASSWORD, convertSzzyOrderId);
|
||
// //if (szzyOrder == null || szzyOrder.ret != 0 || (szzyOrder.data.OrderStatus != "4" && szzyOrder.data.OrderStatus != "5" && szzyOrder.data.OrderStatus != "6"))
|
||
// if (szzyOrder == null || szzyOrder.ret != 0)
|
||
// {
|
||
// errors.Add("上证综研没查询到此订单");
|
||
// return JsonHandler.UpdateMessage(errors, false);
|
||
// }
|
||
|
||
// //if (szzyOrder.data.NeedPay >3000 && model.SOURCE != "4")
|
||
|
||
|
||
// string resid = WX.CRM.Common.ResUtil.CreateResId(mobile);
|
||
// //bool isExistResId = wx_SzzyOrder_BL.Get(m => m.RESID == resid && m.ISOPEN == 1) != null;
|
||
// //if (!isExistResId)
|
||
// //{
|
||
// // errors.Add("此手机号还没有下过订单，不能下单");
|
||
// // return JsonHandler.UpdateMessage(errors, false);
|
||
// //}
|
||
// if (res_Customer_Q_BL.getResCustomerByResId(resid) == null)
|
||
// {
|
||
// res_Customer_BL.ResgisterCustomer(mobile, resid, "orderres");
|
||
// }
|
||
|
||
// //var zxUserId = "161230020007514155"; //正式用户
|
||
// //var zxUserId = "161228020773326204";// 测试用户
|
||
// var zxUserId = getZxUserId(resid, cname);
|
||
// if (string.IsNullOrWhiteSpace(zxUserId))
|
||
// {
|
||
// errors.Add("注册上证综研用户失败，请稍后再试！");
|
||
// return JsonHandler.UpdateMessage(errors, false);
|
||
// }
|
||
|
||
// model.USERID = zxUserId;
|
||
// model.ORDERID = new SEQUENCES_BL().Seq_base_get();
|
||
// model.OPERATETIME = DateTime.Now;
|
||
// model.INNERUSERID = userId;
|
||
// if (!model.SALEDEPTID.HasValue)
|
||
// {
|
||
// model.SALEDEPTID = saleDeptId;
|
||
// }
|
||
|
||
// model.RESID = resid;
|
||
// model.ISFINANCEPAY = 0;
|
||
// model.OPENORDER = 0;
|
||
// if(szzyOrder.data.OrderStatus=="4" || szzyOrder.data.OrderStatus == "5")
|
||
// {
|
||
// model.ISOPEN = 1;
|
||
// }
|
||
// else
|
||
// {
|
||
// model.ISOPEN = 0;
|
||
// }
|
||
|
||
// model.PRODUCTNAME = szzyOrder.data.ProductName;
|
||
// model.SUBPRODUCTNAME = szzyOrder.data.SubProductName;
|
||
// model.PRODUCTID = szzyOrder.data.ProductID;
|
||
// model.SUBPRODUCTID = szzyOrder.data.SubProductID;
|
||
// model.CONTRACTCODE = szzyOrder.data.ContractCode;
|
||
// model.CTIME = Convert.ToDateTime(szzyOrder.data.CTime);
|
||
// model.OTIME = !string.IsNullOrEmpty(szzyOrder.data.OTime) ? Convert.ToDateTime(szzyOrder.data.OTime) : new Nullable<DateTime>();
|
||
// model.NEEDPAY = szzyOrder.data.NeedPay;
|
||
// model.RETURNNEEDPAY = szzyOrder.data.NeedPay;
|
||
// model.FINALPAY = szzyOrder.data.FinalPay;
|
||
// model.ORDERSTATUS = szzyOrder.data.OrderStatus;
|
||
// model.ORDERSTATUSNAME = szzyOrder.data.OrderStatusName;
|
||
// model.RET = szzyOrder.ret;
|
||
// model.ARRIVALPAY = model.FINALPAY;
|
||
// model.ARRIVALTIME = model.OTIME;
|
||
// model.SZZYORDERID = szzyOrder.data.OrderID;
|
||
// if (szzyOrder.data.TeamServe.HasValue)
|
||
// {
|
||
// model.TEAMSERVE = szzyOrder.data.TeamServe;
|
||
// }
|
||
// model.CNAME = cname;
|
||
// var subProduct = wx_SzzySubProduct_BL.Get(m => m.SUBPRODUCTID == model.SUBPRODUCTID);
|
||
// if (subProduct == null)
|
||
// {
|
||
// errors.Add(szzyOrder.data.SubProductName+",该产品分类在系统不存在！");
|
||
// return JsonHandler.UpdateMessage(errors, false);
|
||
// }
|
||
// model.OPENDAYS = subProduct.RIGHTPERIOD;
|
||
|
||
// if (!model.TOTALUPGRADEVALUE.HasValue)
|
||
// {
|
||
// model.TOTALUPGRADEVALUE = 0;
|
||
// }
|
||
// model.REQUESTSTATUS = 1;
|
||
// var result = wx_SzzyOrder_BL.Add(model) > 0;
|
||
// //本地订单库写入成功，然后调用上证综研订单接口
|
||
// if (!result)
|
||
// {
|
||
// errors.Add("补单操作写库失败");
|
||
// }
|
||
// else
|
||
// {
|
||
// if (!string.IsNullOrWhiteSpace(model.CUSTOMERUSERNAME))
|
||
// {
|
||
// wx_szzyorder_refund_bl.UpdateResIsTuiGuang(resid, model.ORDERID);//修改是否为线下资源
|
||
// if (model.SOURCE != "5")
|
||
// {
|
||
// wx_SzzyOrder_BL.UpdateResIdByWxUserName(resid, model.CUSTOMERUSERNAME); //修改微信好友对应的客户ID
|
||
// }
|
||
// else
|
||
// {
|
||
// wx_SzzyOrder_BL.UpdateResIdByOpenId(resid, model.CUSTOMERUSERNAME); //修改工作号好友对应的客户ID
|
||
// }
|
||
// }
|
||
|
||
// }
|
||
// return JsonHandler.ManageMessage(errors.Error, result, model.ORDERID.ToString());
|
||
|
||
//}
|
||
#endregion
|
||
|
||
|
||
#region 上传到账金额文件
|
||
|
||
[AuthorizeRedirect(Roles = InitRights.CONST_我的订单)]
|
||
public ActionResult ArrivalUpload()
|
||
{
|
||
|
||
return View();
|
||
}
|
||
|
||
[AcceptVerbs(HttpVerbs.Post)]
|
||
public JsonResult Upload(HttpPostedFileBase fileData)
|
||
{
|
||
if (fileData != null)
|
||
{
|
||
try
|
||
{
|
||
//文件上传后的保存路径
|
||
string filePath = Server.MapPath("~/UploadFile/ArrivalPay/");
|
||
if (!Directory.Exists(filePath))
|
||
{
|
||
Directory.CreateDirectory(filePath);
|
||
}
|
||
string fileName = Path.GetFileName(fileData.FileName);//原始文件名称
|
||
string fileExtension = Path.GetExtension(fileName); //文件扩展名
|
||
string saveName = Guid.NewGuid() + fileExtension; //保存文件名称
|
||
|
||
fileData.SaveAs(filePath + saveName);
|
||
bool timeIsEmpty = false;
|
||
handleArrivalUpload(saveName, ref timeIsEmpty);
|
||
if (!timeIsEmpty)
|
||
{
|
||
return Json(new
|
||
{
|
||
Success = true,
|
||
Message = "上传成功"
|
||
});
|
||
}
|
||
else
|
||
{
|
||
return Json(new
|
||
{
|
||
Success = false,
|
||
Message = "更新失败，文件中到账时间格式有误"
|
||
});
|
||
}
|
||
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
LogHelper.Error(ex);
|
||
return Json(new { Success = false, Message = ex.Message }, JsonRequestBehavior.AllowGet);
|
||
}
|
||
}
|
||
return Json(new { Success = false, Message = "请选择要上传的文件！" }, JsonRequestBehavior.AllowGet);
|
||
}
|
||
|
||
public void handleArrivalUpload(string file, ref bool timeIsEmpty)
|
||
{
|
||
string str = "";
|
||
DataTable dt = null;
|
||
try
|
||
{
|
||
NPOIHelper.InitializeWorkbook_xls(AppDomain.CurrentDomain.BaseDirectory + "UploadFile\\ArrivalPay\\" + file);
|
||
dt = NPOIHelper.ConvertToDataTable();
|
||
|
||
//TempData["uploadtable"] = dt;
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
LogHelper.Error(ex);
|
||
}
|
||
|
||
if (dt.Rows.Count > 0 || dt.Columns.Count == 3)
|
||
{
|
||
for (int i = 0; i < dt.Rows.Count; i++)
|
||
{
|
||
DataRow model = dt.Rows[i];
|
||
decimal orderId = Convert.ToDecimal(model[0]);
|
||
decimal arrivalPay = Convert.ToDecimal(model[1]);
|
||
DateTime arrivalTime = DateTime.MinValue;
|
||
if (model[2] != null && !string.IsNullOrWhiteSpace(model[2].ToString()))
|
||
{
|
||
if (!DateTime.TryParse(model[2].ToString(), out arrivalTime))
|
||
{
|
||
DateTime.TryParseExact(model[2].ToString(), "dd/MM/yy hh:mm", new CultureInfo("en-US"), DateTimeStyles.None, out arrivalTime);
|
||
}
|
||
}
|
||
if (arrivalTime == null || arrivalTime == DateTime.MinValue)
|
||
{
|
||
timeIsEmpty = true;
|
||
continue;
|
||
|
||
}
|
||
|
||
WX_SZZYORDER order = wx_SzzyOrder_BL.Get(m => m.SZZYORDERID == orderId);
|
||
|
||
if (order != null && arrivalTime != null && arrivalTime != DateTime.MinValue)
|
||
{
|
||
if (order.ARRIVALPAY == null || order.ARRIVALTIME == null || order.ARRIVALPAY == 0 || order.ARRIVALPAY != arrivalPay || order.ARRIVALTIME.Value.ToShortDateString() != arrivalTime.ToShortDateString())
|
||
{
|
||
order.ARRIVALPAY = arrivalPay;
|
||
order.ARRIVALTIME = arrivalTime != DateTime.MinValue ? arrivalTime : new DateTime?();
|
||
wx_SzzyOrder_BL.Update(order);
|
||
|
||
WX_ARRIVALPAYLOG arrivalPayLog = new WX_ARRIVALPAYLOG();
|
||
arrivalPayLog.PKID = new SEQUENCES_BL().Seq_base_get();
|
||
arrivalPayLog.SZZYORDERID = orderId;
|
||
arrivalPayLog.ARRIVALPAY = arrivalPay;
|
||
arrivalPayLog.ARRIVALTIME = arrivalTime != DateTime.MinValue ? arrivalTime : new DateTime?();
|
||
arrivalPayLog.CTIME = DateTime.Now;
|
||
wx_ArrivalPayLog_BL.Add(arrivalPayLog);
|
||
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
|
||
public ActionResult GetQRCode(string url)
|
||
{
|
||
//QRCodeOperate qrCode = new QRCodeOperate();
|
||
QRCodeHelper.qrCodeScale = 8;
|
||
QRCodeHelper.encode = System.Text.Encoding.UTF8;
|
||
byte[] bytes = QRCodeHelper.Create(url);
|
||
return File(bytes, @"image/jpeg");
|
||
}
|
||
|
||
private List<SelectListItem> getProductList()
|
||
{
|
||
List<SelectListItem> selectList = new List<SelectListItem>();
|
||
var where = PredicateExtensionses.True<WX_SZZYPRODUCT>();
|
||
where = where.And(m => m.ISVALID == 1);
|
||
Pager pager = new Pager() { page = 1, rows = int.MaxValue };
|
||
var list = wx_SzzyProduct_BL.GetList(where, m => m.PRODUCTID, pager, SortOrder.Ascending);
|
||
foreach (var szzyProduct in list)
|
||
{
|
||
selectList.Add(new SelectListItem() { Text = szzyProduct.PRODUCTNAME, Value = szzyProduct.PRODUCTID.ToString() });
|
||
}
|
||
return selectList;
|
||
}
|
||
|
||
private List<SelectListItem> getAllProductList()
|
||
{
|
||
List<SelectListItem> selectList = new List<SelectListItem>();
|
||
var where = PredicateExtensionses.True<WX_SZZYPRODUCT>();
|
||
Pager pager = new Pager() { page = 1, rows = int.MaxValue };
|
||
var list = wx_SzzyProduct_BL.GetList(where, m => m.PRODUCTID, pager, SortOrder.Ascending);
|
||
foreach (var szzyProduct in list)
|
||
{
|
||
selectList.Add(new SelectListItem() { Text = szzyProduct.PRODUCTNAME, Value = szzyProduct.PRODUCTID.ToString() });
|
||
}
|
||
return selectList;
|
||
}
|
||
|
||
private List<SelectListItem> getSubProductListByProductId(int productId, int isValid)
|
||
{
|
||
List<SelectListItem> selectList = new List<SelectListItem>();
|
||
var where = PredicateExtensionses.True<WX_SZZYSUBPRODUCT>();
|
||
if (productId > 0)
|
||
{
|
||
where = where.And(m => m.PRODUCTID == productId);
|
||
}
|
||
if (isValid == 1)
|
||
{
|
||
where = where.And(m => m.ISVALID == 1);
|
||
}
|
||
|
||
Pager pager = new Pager() { page = 1, rows = int.MaxValue };
|
||
var list = wx_SzzySubProduct_BL.GetList(where, m => m.SUBPRODUCTID, pager, SortOrder.Ascending);
|
||
foreach (var szzySubProduct in list)
|
||
{
|
||
selectList.Add(new SelectListItem() { Text = szzySubProduct.SUBPRODUCTNAME, Value = szzySubProduct.SUBPRODUCTID.ToString() });
|
||
}
|
||
return selectList;
|
||
}
|
||
|
||
private string getOrderTypeStr(decimal orderType)
|
||
{
|
||
if (orderType == 1)
|
||
{
|
||
return "普通订单";
|
||
}
|
||
else if (orderType == 2)
|
||
{
|
||
return "续费订单";
|
||
}
|
||
else if (orderType == 3)
|
||
{
|
||
return "升级订单";
|
||
}
|
||
else
|
||
{
|
||
return "";
|
||
}
|
||
}
|
||
|
||
private string getOrderStatusStr(string orderStatus)
|
||
{
|
||
if (orderStatus == "0")
|
||
{
|
||
return string.Format("<font style=\"color:red\">下单失败</span>");
|
||
}
|
||
else if (orderStatus == "1")
|
||
{
|
||
return "未开通";
|
||
}
|
||
else if (orderStatus == "2")
|
||
{
|
||
return "部分支付";
|
||
}
|
||
else if (orderStatus == "3")
|
||
{
|
||
return "已支付";
|
||
}
|
||
else if (orderStatus == "4")
|
||
{
|
||
return "已开通";
|
||
}
|
||
else if (orderStatus == "5")
|
||
{
|
||
return "已到期";
|
||
}
|
||
else if (orderStatus == "6")
|
||
{
|
||
return "已升级";
|
||
}
|
||
else if (orderStatus == "7")
|
||
{
|
||
return "已退款";
|
||
}
|
||
else if (orderStatus == "8")
|
||
{
|
||
return "已取消";
|
||
}
|
||
else if (orderStatus == "9")
|
||
{
|
||
return "已关闭";
|
||
}
|
||
else if (orderStatus == "10")
|
||
{
|
||
return "隐藏";
|
||
}
|
||
else
|
||
{
|
||
return "";
|
||
}
|
||
}
|
||
|
||
public JsonResult GetSubProductList(int productId)
|
||
{
|
||
return Json(this.getSubProductListByProductId(productId, 1), JsonRequestBehavior.AllowGet);
|
||
}
|
||
|
||
public JsonResult GetAllSubProductList(int productId)
|
||
{
|
||
return Json(this.getSubProductListByProductId(productId, 0), JsonRequestBehavior.AllowGet);
|
||
}
|
||
|
||
public JsonResult GetSubProductPriceById(int subProductId)
|
||
{
|
||
var subProduct = wx_SzzySubProduct_BL.Get(m => m.SUBPRODUCTID == subProductId);
|
||
if (subProduct != null)
|
||
{
|
||
return Json(new { result = true, price = subProduct.PRICE }, JsonRequestBehavior.AllowGet);
|
||
}
|
||
else
|
||
{
|
||
return Json(new { result = false, price = 0 }, JsonRequestBehavior.AllowGet);
|
||
}
|
||
|
||
}
|
||
|
||
}
|
||
|
||
|
||
} |