/// <summary>
/// 后台话费补充
/// </summary>
/// <param name="accid"></param>
/// <param name="orderId"></param>
/// <returns></returns>
public string RechargeMobile(int accid, int orderId)
{
ManageUserModel uM = (ManageUserModel)Session["logUser"];
int uid = uM.UserID;
return(OrderInfoList.RechargeProc(accid, orderId, uid));
}
public void SendOrderToUI()
{
OrderInfoList orderInfo = GameObject.FindGameObjectWithTag("OrderList").GetComponent <OrderInfoList>();
for (int i = 0; i < myOrderList.Count; i++)
{
orderInfo.AppendOrder(myOrderList[i]);
}
myOrderList.Clear();
}
//public ActionResult Invoice(int pageIndex = 1, int pageSize = 20, string strWhere = "", string orderWhere = "")
//{
// ViewBag.Page = pageIndex;
// OrderInvoiceList invoice = OrderInfoList.GetInovicePage(pageIndex, pageSize, strWhere, orderWhere);
// ViewBag.AllPage = invoice.RowCount / pageSize + 1;
// List<OrderInvoiceModel> list = invoice.Data;
// return View(list);
//}
/// <summary>
/// 获取单条发票信息
/// </summary>
/// <param name="oid"></param>
/// <returns></returns>
public string GetInvoiceInfo(int id)
{
InvoiceSimple invoice = OrderInfoList.GetInvoiceInfo(id);
if (invoice != null)
{
return(CommonLib.Helper.JsonSerializeObject(invoice));
}
else
{
return("");
}
}
public string TakeInvoice(string number = "", string remark = "", string express = "", int inId = 0)
{
if (inId <= 0 || string.IsNullOrEmpty(number))
{
return("获取信息失败");
}
else
{
bool status = OrderInfoList.UpdateInvoiceNumber(inId, number, remark, express, Convert.ToInt32(Session["adminid"]));
if (status)
{
return("更新成功");
}
else
{
return("更新发票信息失败");
}
}
}
public string GetInvoiceList(DateTime stDate, DateTime edDate, int pageIndex = 1, int pageSize = 15, int invoiceStatus = -1, string accId = "")
{
string returnJson = "";
string strWhere = "";
if (invoiceStatus != -1)
{
strWhere += " invoiceStatus=" + invoiceStatus;
}
if (accId != "")
{
int accid = 0;
if (int.TryParse(accId, out accid))
{
strWhere += (strWhere.Length > 0 ? " and " : "") + " o.accId=" + accid.ToString();
}
}
if (stDate.ToShortDateString() == edDate.ToShortDateString() && edDate.ToShortDateString() == DateTime.Now.ToShortDateString())
{
edDate = DateTime.Now;
stDate = edDate.AddMonths(-2);
}
strWhere += (strWhere.Length > 0 ? " and " : "") + " o.createDate between '" + stDate + "' and '" + edDate +
"'";
OrderInvoiceList invoice = OrderInfoList.GetInovicePage(pageIndex, pageSize, strWhere, "createDate desc");
//OrderInvoiceList invoiceForLoop = OrderInfoList.GetInovicePage(pageIndex, pageSize, strWhere, "createDate desc")
returnJson = CommonLib.Helper.JsonSerializeObject(invoice, "yyyy-MM-dd");
return(returnJson);
}
public string GetRechargeList(int page, string phoneNum, string orderNo)
{
return(OrderInfoList.GetRechargeOrderList(page, phoneNum, orderNo));
}
public string GetOrderList(int pageIndex = 1, int pageSize = 15, string Column = "", string strWhere = "",
int orderStatus = -99, int payType = -99, string orderNo = "", string accId = "", string busName = "", string remark = "", string start = "", string end = "", int zeroRemark = 0, int exchange = 0, int noRecharge = 0)
{
Dictionary <string, string> dic = new Dictionary <string, string>()
{
{ "RowCount", "" },
{ "PageCount", "" },
{ "list", "" },
{ "sum", "" },
{ "integral", "" },
{ "coupon", "" }
};
if ((!string.IsNullOrEmpty(start)) && (!string.IsNullOrEmpty(end)))
{
if (Convert.ToDateTime(end) > Convert.ToDateTime(start))
{
if (start != "")
{
DateTime stTime = Convert.ToDateTime(start);
strWhere += " createDate >='" + stTime.ToString("yyyy-MM-dd") + "' and";
}
if (end != "")
{
DateTime edTime = Convert.ToDateTime(end);
strWhere += " createDate <'" + edTime.AddDays(1).Date.ToString("yyyy-MM-dd") + "' and";
}
}
else if ((Convert.ToDateTime(end) == Convert.ToDateTime(start)) && Convert.ToDateTime(start).ToShortDateString() != DateTime.Now.ToShortDateString())
{
DateTime time = Convert.ToDateTime(start);
strWhere += " datediff(day,createDate,'" + time.Date.ToString("yyyy-MM-dd") + "')=0 and";
}
else if ((Convert.ToDateTime(end) == Convert.ToDateTime(start)) && Convert.ToDateTime(start).ToShortDateString() == DateTime.Now.ToShortDateString())
{
DateTime time = Convert.ToDateTime(start);
strWhere += " datediff(day,createDate,getdate())=0 and ";
}
}
if (orderStatus != -99)
{
strWhere += " orderStatus=" + orderStatus.ToString() + " and ";
}
if (payType != -99)
{
if (payType == 7)//安卓内购处理
{
strWhere += " oFlag=2 and ";
}
else
{
strWhere += " orderPayType=" + payType.ToString() + " and ";
}
}
if (orderNo != "")
{
strWhere += " orderNo=" + orderNo + " and ";
}
if (accId != "")
{
strWhere += " accId=" + accId + " and ";
}
if (busName != "")
{
//添加京东商品筛选逻辑
strWhere += " ( ";
if (busName.Contains("京东") || busName.Contains("供货") || busName.Contains("日百"))
{
strWhere += " orderTypeId=3 or ";
}
strWhere += " (dbo.GetOrderProjectName(busId) like '%" + busName + "%' and orderTypeId=1) or (dbo.GetMaterialProjectName(busId) like '%" + busName + "%' and orderTypeId=2)) and ";
}
if (remark != "")
{
strWhere += " remark like '%" + remark + "%' and ";
}
if (zeroRemark == 1)
{
strWhere += " (RealPayMoney>0 or commuteIntegral>0) and ";
}
if (exchange == 1)
{
strWhere += " commuteIntegral>0 and ";
}
if (noRecharge == 1)
{
strWhere += " busId not in (56,58,59) and ";
}
if (strWhere.Length > 0)
{
strWhere = strWhere.Substring(0, strWhere.LastIndexOf('a'));
}
int pageCount = OrderInfoList.GetPageCount(strWhere);
if (pageCount != 0)
{
dic["RowCount"] = pageCount.ToString();
}
else
{
dic["RowCount"] = "0";
}
if (pageCount > 0)
{
dic["PageCount"] = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(pageCount) / Convert.ToDecimal(pageSize))).ToString();
}
else
{
dic["PageCount"] = "0";
}
List <OrderInfoModel> orderList = OrderInfoList.GetPage(pageIndex, pageSize, Column, strWhere);
foreach (var item in orderList)
{
if (item.oFlag == 2)
{
item.orderPayDesc = "安卓内购";
}
}
decimal sum = OrderInfoList.GetSumByCondition(strWhere);
decimal integral = OrderInfoList.GetIntegralByCondition(strWhere);
decimal integralSum = OrderInfoList.GetIntegralSumByCondition(strWhere);
decimal coupon = OrderInfoList.GetCouponByCondition(strWhere);
dic["list"] = CommonLib.Helper.JsonSerializeObject(orderList, "yyyy-MM-dd HH:mm:ss");
dic["sum"] = sum.ToString();
dic["integral"] = integral.ToString();
dic["coupon"] = coupon.ToString();
dic["integralSum"] = integralSum.ToString();
return(CommonLib.Helper.JsonSerializeObject(dic));
}
public string GetBalance()
{
return(OrderInfoList.GetJuheAccountBalance());
}
public BaseFood()
{
CustomerOrder = OrderInfoList.CreateInstance()._orderModel;
}
