dengyu
/
DS7
1
0
Fork 0
Code Issues Pull Requests Projects 1 Releases Wiki Activity
You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
DS7_HYRD
ShenZhenCHJY
DS7_JinGang
dev
QDHHYT
master
临时发布20240103
DS7_JingHan
DS7Zhanhao
HuanHaiYunTong
shenzhenchjy
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
DS7/DSWebMobile/Handler/Arrearage.ashx.cs

715 lines
36 KiB
C#
Raw Permalink Blame History

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Web;
using DSWeb.MvcShipping.Controllers;
using Newtonsoft.Json;
using DSWebMobile;
using DSWebMobileService.Common;
namespace DSWebMobile.Handler
{
/// <summary>
/// Arrearage 的摘要说明
/// </summary>
public class Arrearage : IHttpHandler, System.Web.SessionState.IRequiresSessionState
{
public void ProcessRequest(HttpContext context)
{
string action = context.Request.QueryString["action"].ToString();
switch (action)
{
case "0":
GetSaleList(context);
break;
case "1":
GetClientList(context);
break;
case "2":
GetCombinationList(context);
break;
case "3":
GetSaleDetail(context);
break;
case "4":
GetClientDetail(context);
break;
case "5":
GetCombinationDetail(context);
break;
case "6":
GetSaleListByCondition(context);
break;
case "7":
GetCustListByCondition(context);
break;
case "8":
GetSaleCustListByCondition(context);
break;
}
}
private void GetSaleCustListByCondition(HttpContext context)
{
string relStartMonth = "";
string relEndMonth = "";
string relStrCondition = "";
string relBeginFrom = "";
string relBeginTo = "";
string relAccFrom = "";
string relAccTo = "";
string strCondition = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["s"].ToString());
string startMonth = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["sm"].ToString());
string endMonth = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["em"].ToString());
string bfd = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["bfd"].ToString());
string btd = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["btd"].ToString());
string afd = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["afd"].ToString());
string atd = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["atd"].ToString());
string pattern = "\0";
string replacement = "";
int start = int.Parse(context.Request.QueryString["t"].ToString());
int limit = int.Parse(context.Request.QueryString["l"].ToString());
string dc = context.Request.QueryString["dc"].ToString();
Regex rgx = new Regex(pattern);
relStrCondition = rgx.Replace(strCondition, replacement);
relStartMonth = rgx.Replace(startMonth, replacement);
relEndMonth = rgx.Replace(endMonth, replacement);
relBeginFrom = rgx.Replace(bfd, replacement);
relBeginTo = rgx.Replace(btd, replacement);
relAccFrom = rgx.Replace(afd, replacement);
relAccTo = rgx.Replace(atd, replacement);
pattern = "\t";
Regex rgx2 = new Regex(pattern);
relStrCondition = rgx2.Replace(relStrCondition, replacement);
relStartMonth = rgx.Replace(relStartMonth, replacement);
relEndMonth = rgx.Replace(relEndMonth, replacement);
relBeginFrom = rgx2.Replace(relBeginFrom, replacement);
relBeginTo = rgx2.Replace(relBeginTo, replacement);
relAccFrom = rgx2.Replace(relAccFrom, replacement);
relAccTo = rgx2.Replace(relAccTo, replacement);
if (strCondition != "")
{
if (relStrCondition[0] == ',') { relStrCondition = relStrCondition.Substring(1, relStrCondition.Length - 1); }
}
/*if (relBeginFrom != "")
{
if (relStrCondition != "")
{
relStrCondition += " and B.OPDATE>='" + relBeginFrom + " 00:00:00' ";
}
else
{
relStrCondition = " B.OPDATE>='" + relBeginFrom + " 00:00:00' ";
}
}
if (relBeginTo != "")
{
relStrCondition += " and B.OPDATE<='" + relBeginTo + " 23:59:59' ";
}
if (relStrCondition != "" && relAccFrom != "")
{
relStrCondition += " and B.ACCDATE>='" + relAccFrom.Substring(0, 7) + "' ";
}
else if (relStrCondition == "" && relAccFrom != "") { relStrCondition += " B.ACCDATE>'" + relAccFrom.Substring(0, 7) + "' "; }
if (relAccTo != "")
{
relStrCondition += " and B.ACCDATE<='" + relAccTo.Substring(0, 7) + "' ";
}*/
var listData = DSWebMobileService.MsRptNoTotalMonth.SaleCustListData(dc, 0, 0, relStrCondition, null, null, null, relBeginFrom, relBeginTo, relAccFrom, relAccTo, relStartMonth, relEndMonth);
string result = listData.Content.ToString();
StringBuilder sb = new StringBuilder();
if (listData == null) { sb.Append("[{\"SALE\":\"\"}]"); }
else { sb.AppendLine(result); }
context.Response.ContentType = "text/plain";
context.Response.Write(sb.ToString());
context.Response.End();
}
private void GetCustListByCondition(HttpContext context)
{
string relStartMonth = "";
string relEndMonth = "";
string relStrCondition = "";
string relBeginFrom = "";
string relBeginTo = "";
string relAccFrom = "";
string relAccTo = "";
string strCondition = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["s"].ToString());
string startMonth = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["sm"].ToString());
string endMonth = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["em"].ToString());
string bfd = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["bfd"].ToString());
string btd = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["btd"].ToString());
string afd = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["afd"].ToString());
string atd = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["atd"].ToString());
string pattern = "\0";
string replacement = "";
int start = int.Parse(context.Request.QueryString["t"].ToString());
int limit = int.Parse(context.Request.QueryString["l"].ToString());
string dc = context.Request.QueryString["dc"].ToString();
Regex rgx = new Regex(pattern);
relStrCondition = rgx.Replace(strCondition, replacement);
relStartMonth = rgx.Replace(startMonth, replacement);
relEndMonth = rgx.Replace(endMonth, replacement);
relBeginFrom = rgx.Replace(bfd, replacement);
relBeginTo = rgx.Replace(btd, replacement);
relAccFrom = rgx.Replace(afd, replacement);
relAccTo = rgx.Replace(atd, replacement);
pattern = "\t";
Regex rgx2 = new Regex(pattern);
relStrCondition = rgx2.Replace(relStrCondition, replacement);
relStartMonth = rgx.Replace(relStartMonth, replacement);
relEndMonth = rgx.Replace(relEndMonth, replacement);
relBeginFrom = rgx2.Replace(relBeginFrom, replacement);
relBeginTo = rgx2.Replace(relBeginTo, replacement);
relAccFrom = rgx2.Replace(relAccFrom, replacement);
relAccTo = rgx2.Replace(relAccTo, replacement);
if (strCondition != "")
{
if (relStrCondition[0] == ',') { relStrCondition = relStrCondition.Substring(1, relStrCondition.Length - 1); }
}
/*if (relBeginFrom != "")
{
if (relStrCondition != "")
{
relStrCondition += " and B.OPDATE>='" + relBeginFrom + " 00:00:00' ";
}
else
{
relStrCondition = " B.OPDATE>='" + relBeginFrom + " 00:00:00' ";
}
}
if (relBeginTo != "")
{
relStrCondition += " and B.OPDATE<='" + relBeginTo + " 23:59:59' ";
}
if (relStrCondition != "" && relAccFrom != "")
{
relStrCondition += " and B.ACCDATE>='" + relAccFrom.Substring(0, 7) + "' ";
}
else if (relStrCondition == "" && relAccFrom != "") { relStrCondition += " B.ACCDATE>'" + relAccFrom.Substring(0, 7) + "' "; }
if (relAccTo != "")
{
relStrCondition += " and B.ACCDATE<='" + relAccTo.Substring(0, 7) + "' ";
}*/
var listData = DSWebMobileService.MsRptNoTotalMonth.CustListData(dc, 0, 0, relStrCondition, null, null, null, relBeginFrom, relBeginTo, relAccFrom, relAccTo, relStartMonth, relEndMonth);
string result = listData.Content.ToString();
StringBuilder sb = new StringBuilder();
if (listData == null) { sb.Append("[{\"CUSTNAME\":\"\"}]"); }
else { sb.AppendLine(result); }
context.Response.ContentType = "text/plain";
context.Response.Write(sb.ToString());
context.Response.End();
}
private void GetSaleListByCondition(HttpContext context)
{
string relStartMonth = "";
string relEndMonth = "";
string relBeginFrom = "";
string relBeginTo = "";
string relAccFrom = "";
string relAccTo = "";
string relStrCondition = "";
string strCondition = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["s"].ToString());
string startMonth = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["sm"].ToString());
string endMonth = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["em"].ToString());
string bfd = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["bfd"].ToString());
string btd = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["btd"].ToString());
string afd = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["afd"].ToString());
string atd = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["atd"].ToString());
string pattern = "\0";
string replacement = "";
int start = int.Parse(context.Request.QueryString["t"].ToString());
int limit = int.Parse(context.Request.QueryString["l"].ToString());
string dc = context.Request.QueryString["dc"].ToString();
Regex rgx = new Regex(pattern);
relStrCondition = rgx.Replace(strCondition, replacement);
relStartMonth = rgx.Replace(startMonth, replacement);
relEndMonth = rgx.Replace(endMonth, replacement);
relBeginFrom = rgx.Replace(bfd, replacement);
relBeginTo = rgx.Replace(btd, replacement);
relAccFrom = rgx.Replace(afd, replacement);
relAccTo = rgx.Replace(atd, replacement);
pattern = "\t";
Regex rgx2 = new Regex(pattern);
relStrCondition = rgx2.Replace(relStrCondition, replacement);
relStartMonth = rgx2.Replace(relStartMonth, replacement);
relEndMonth = rgx2.Replace(relEndMonth, replacement);
relBeginFrom = rgx2.Replace(relBeginFrom, replacement);
relBeginTo = rgx2.Replace(relBeginTo, replacement);
relAccFrom = rgx2.Replace(relAccFrom, replacement);
relAccTo = rgx2.Replace(relAccTo, replacement);
if (strCondition != "")
{
if (relStrCondition[0] == ',') { relStrCondition = relStrCondition.Substring(1, relStrCondition.Length - 1); }
}
/*if (relBeginFrom != "")
{
if (relStrCondition != "")
{
relStrCondition += " and B.OPDATE>='" + relBeginFrom + " 00:00:00' ";
}
else
{
relStrCondition = " B.OPDATE>='" + relBeginFrom + " 00:00:00' ";
}
}
if (relBeginTo != "")
{
relStrCondition += " and B.OPDATE<='" + relBeginTo + " 23:59:59' ";
}
if (relStrCondition != "" && relAccFrom != "")
{
relStrCondition += " and B.ACCDATE>='" + relAccFrom.Substring(0, 7) + "' ";
}
else if (relStrCondition == "" && relAccFrom != "") { relStrCondition += " B.ACCDATE>='" + relAccFrom.Substring(0, 7) + "' "; }
if (relAccTo != "")
{
relStrCondition += " and B.ACCDATE<='" + relAccTo.Substring(0, 7) + "' ";
}*/
var listData = DSWebMobileService.MsRptNoTotalMonth.SaleListData(dc, 0, 0, relStrCondition, null, null, null, relBeginFrom, relBeginTo, relAccFrom, relAccTo, relStartMonth, relEndMonth);
string result = listData.Content.ToString();
StringBuilder sb = new StringBuilder();
if (listData == null) { sb.Append("[{\"SALE\":\"\"}]"); }
else { sb.AppendLine(result); }
context.Response.ContentType = "text/plain";
context.Response.Write(sb.ToString());
context.Response.End();
}
private void GetSaleDetail(HttpContext context)
{
string relCodeName = "";
string relBSFromDate = "";
string relBSToDate = "";
string relACCFromDate = "";
string relACCToDate = "";
string codeName = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["u"].ToString());
string bsFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["bf"].ToString());
string bsToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["bt"].ToString());
string accFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["af"].ToString());
string accToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["at"].ToString());
string pattern = "\0";
string replacement = "";
string returnValue = "";
Regex rgx = new Regex(pattern);
relCodeName = rgx.Replace(codeName, replacement);
relBSFromDate = rgx.Replace(bsFromDate, replacement);
relBSToDate = rgx.Replace(bsToDate, replacement);
relACCFromDate = rgx.Replace(accFromDate, replacement);
relACCToDate = rgx.Replace(accToDate, replacement);
pattern = "\t";
Regex rgx2 = new Regex(pattern);
relCodeName = rgx2.Replace(relCodeName, replacement);
relBSFromDate = rgx2.Replace(relBSFromDate, replacement);
relBSToDate = rgx2.Replace(relBSToDate, replacement);
relACCFromDate = rgx2.Replace(relACCFromDate, replacement);
relACCToDate = rgx2.Replace(relACCToDate, replacement);
/*if (Common.HsTable.HasItem("ArrearageAnalysisSale|" + relCodeName))
{
returnValue = Common.HsTable.GetHsTableItem("ArrearageAnalysisSale|" + relCodeName);
}*/
string[] valueArray = returnValue.Split(',');
string relGID = valueArray[0].ToString();
string relCompanyID = valueArray[1].ToString();
//string relCodeName = "";
string relPassword = valueArray[3].ToString();
string relCacheKey = valueArray[4].ToString();
string relStrCondition = valueArray[5].ToString();
string relSale = valueArray[6].ToString();
/*Module.UserInfomationModule _user = new UserInfomationModule();
_user.GID = relGID;
_user.CompanyID = relCompanyID;
_user.CodeName = relCodeName;
_user.Password = relPassword;
//DataTable dt = BaseInfo.PaymentAuditingListDBServer.PaymentAuditingList(cacheKey, _user, pageIndex, pageCount, ref TotalCount, strCondition, IsAudit);
DataTable dt = BaseInfo.ArrearageAnalysisList.ArrearageAnalysisForSaleListInfo(relCacheKey, _user, relSale, relStrCondition, relBSFromDate, relBSToDate, relACCFromDate, relACCToDate);
*/
StringBuilder sb = new StringBuilder();
/*if (dt == null || dt.Rows.Count == 0) { sb.Append("[{\"SALE\":\"\"}]"); }
else { sb.Append(JsonClass.DataTable2JsonNoneTotalCount(dt)); }*/
context.Response.ContentType = "text/plain";
context.Response.Write(sb.ToString());
context.Response.End();
}
private void GetClientDetail(HttpContext context)
{
string relCodeName = "";
string relBSFromDate = "";
string relBSToDate = "";
string relACCFromDate = "";
string relACCToDate = "";
string codeName = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["u"].ToString());
string bsFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["bf"].ToString());
string bsToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["bt"].ToString());
string accFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["af"].ToString());
string accToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["at"].ToString());
string pattern = "\0";
string replacement = "";
string returnValue = "";
Regex rgx = new Regex(pattern);
relCodeName = rgx.Replace(codeName, replacement);
relBSFromDate = rgx.Replace(bsFromDate, replacement);
relBSToDate = rgx.Replace(bsToDate, replacement);
relACCFromDate = rgx.Replace(accFromDate, replacement);
relACCToDate = rgx.Replace(accToDate, replacement);
pattern = "\t";
Regex rgx2 = new Regex(pattern);
relCodeName = rgx2.Replace(relCodeName, replacement);
relBSFromDate = rgx2.Replace(relBSFromDate, replacement);
relBSToDate = rgx2.Replace(relBSToDate, replacement);
relACCFromDate = rgx2.Replace(relACCFromDate, replacement);
relACCToDate = rgx2.Replace(relACCToDate, replacement);
/*if (Common.HsTable.HasItem("ArrearageAnalysisClient|" + relCodeName))
{
returnValue = Common.HsTable.GetHsTableItem("ArrearageAnalysisClient|" + relCodeName);
}*/
string[] valueArray = returnValue.Split(',');
string relGID = valueArray[0].ToString();
string relCompanyID = valueArray[1].ToString();
//string relCodeName = "";
string relPassword = valueArray[3].ToString();
string relCacheKey = valueArray[4].ToString();
string relStrCondition = valueArray[5].ToString();
string relClient = valueArray[6].ToString();
/*Module.UserInfomationModule _user = new UserInfomationModule();
_user.GID = relGID;
_user.CompanyID = relCompanyID;
_user.CodeName = relCodeName;
_user.Password = relPassword;
//DataTable dt = BaseInfo.PaymentAuditingListDBServer.PaymentAuditingList(cacheKey, _user, pageIndex, pageCount, ref TotalCount, strCondition, IsAudit);
DataTable dt = BaseInfo.ArrearageAnalysisList.ArrearageAnalysisForClientListInfo(relCacheKey, _user, relClient, relStrCondition, relBSFromDate, relBSToDate, relACCFromDate, relACCToDate);
*/
StringBuilder sb = new StringBuilder();
/*if (dt == null || dt.Rows.Count == 0) { sb.Append("[{\"CLIENT\":\"\"}]"); }
else { sb.Append(JsonClass.DataTable2JsonNoneTotalCount(dt)); }*/
context.Response.ContentType = "text/plain";
context.Response.Write(sb.ToString());
context.Response.End();
}
private void GetCombinationDetail(HttpContext context)
{
string relCodeName = "";
string relBSFromDate = "";
string relBSToDate = "";
string relACCFromDate = "";
string relACCToDate = "";
string codeName = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["u"].ToString());
string bsFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["bf"].ToString());
string bsToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["bt"].ToString());
string accFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["af"].ToString());
string accToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.QueryString["at"].ToString());
string pattern = "\0";
string replacement = "";
string returnValue = "";
Regex rgx = new Regex(pattern);
relCodeName = rgx.Replace(codeName, replacement);
relBSFromDate = rgx.Replace(bsFromDate, replacement);
relBSToDate = rgx.Replace(bsToDate, replacement);
relACCFromDate = rgx.Replace(accFromDate, replacement);
relACCToDate = rgx.Replace(accToDate, replacement);
pattern = "\t";
Regex rgx2 = new Regex(pattern);
relCodeName = rgx2.Replace(relCodeName, replacement);
relBSFromDate = rgx2.Replace(relBSFromDate, replacement);
relBSToDate = rgx2.Replace(relBSToDate, replacement);
relACCFromDate = rgx2.Replace(relACCFromDate, replacement);
relACCToDate = rgx2.Replace(relACCToDate, replacement);
/*if (Common.HsTable.HasItem("ArrearageAnalysisSaleClient|" + relCodeName))
{
returnValue = Common.HsTable.GetHsTableItem("ArrearageAnalysisSaleClient|" + relCodeName);
}*/
string[] valueArray = returnValue.Split(',');
string relGID = valueArray[0].ToString();
string relCompanyID = valueArray[1].ToString();
//string relCodeName = "";
string relPassword = valueArray[3].ToString();
string relCacheKey = valueArray[4].ToString();
string relStrCondition = valueArray[5].ToString();
string relSale = valueArray[6].ToString();
string relClient = valueArray[7].ToString();
/*Module.UserInfomationModule _user = new UserInfomationModule();
_user.GID = relGID;
_user.CompanyID = relCompanyID;
_user.CodeName = relCodeName;
_user.Password = relPassword;
//DataTable dt = BaseInfo.PaymentAuditingListDBServer.PaymentAuditingList(cacheKey, _user, pageIndex, pageCount, ref TotalCount, strCondition, IsAudit);
DataTable dt = BaseInfo.ArrearageAnalysisList.ArrearageAnalysisForCombinationListInfo(relCacheKey, _user, relSale, relClient, relStrCondition, relBSFromDate, relBSToDate, relACCFromDate, relACCToDate);
*/
StringBuilder sb = new StringBuilder();
/*if (dt == null || dt.Rows.Count == 0) { sb.Append("[{\"SALE\":\"\"}]"); }
else { sb.Append(JsonClass.DataTable2JsonNoneTotalCount(dt)); }*/
context.Response.ContentType = "text/plain";
context.Response.Write(sb.ToString());
context.Response.End();
}
private void GetSaleList(HttpContext context)
{
string relStartMonth = "";
string relEndMonth = "";
string relStrCondition = "";
string relBusinessFromDate = "";
string relBusinessToDate = "";
string relAccFromDate = "";
string relAccToDate = "";
string strCondition = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["s"].ToString());
string startMonth = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["sm"].ToString());
string endMonth = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["em"].ToString());
string businessFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["bfd"].ToString());
string businessToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["btd"].ToString());
string accFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["afd"].ToString());
string accToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["atd"].ToString());
string pattern = "\0";
string replacement = "";
int start = int.Parse(context.Request.QueryString["t"].ToString());
int limit = int.Parse(context.Request.QueryString["l"].ToString());
Regex rgx = new Regex(pattern);
relStrCondition = rgx.Replace(strCondition, replacement);
relStartMonth = rgx.Replace(startMonth, replacement);
relEndMonth = rgx.Replace(endMonth, replacement);
relBusinessFromDate = rgx.Replace(businessFromDate, replacement);
relBusinessToDate = rgx.Replace(businessToDate, replacement);
relAccFromDate = rgx.Replace(accFromDate, replacement);
relAccToDate = rgx.Replace(accToDate, replacement);
pattern = "\t";
Regex rgx2 = new Regex(pattern);
relStrCondition = rgx2.Replace(relStrCondition, replacement);
relStartMonth = rgx.Replace(relStartMonth, replacement);
relEndMonth = rgx.Replace(relEndMonth, replacement);
relBusinessFromDate = rgx.Replace(relBusinessFromDate, replacement);
relBusinessToDate = rgx.Replace(relBusinessToDate, replacement);
relAccFromDate = rgx.Replace(relAccFromDate, replacement);
relAccToDate = rgx.Replace(relAccToDate, replacement);
if (strCondition != "")
{
if (relStrCondition[0] == ',') { relStrCondition = relStrCondition.Substring(1, relStrCondition.Length - 1); }
}
if (relStrCondition != "")
{
relStrCondition += " and B.OPDATE>='" + relBusinessFromDate + " 00:00:00'";
}
else
{
relStrCondition += " B.OPDATE>='" + relBusinessFromDate + " 00:00:00'";
}
if (relBusinessToDate != "") { relStrCondition += " and B.OPDATE<='" + relBusinessToDate + " 23:59:59'"; }
if (relStrCondition != "" && relAccFromDate != "") { relStrCondition += " and B.ACCDATE>='" + relAccFromDate.Substring(0, 7) + "'"; }
else if (relStrCondition == "" && relAccFromDate != "") { relStrCondition += " B.ACCDATE>='" + relAccFromDate.Substring(0,7) + "'"; }
if (relAccToDate != "") { relStrCondition += " and B.ACCDATE<='" + relAccToDate + " 23:59:59'"; }
relStrCondition += " and F.AMOUNT<>F.SETTLEMENT ";
relStrCondition += " and (F.FEESTATUS=0 or F.FEESTATUS=8 or F.FEESTATUS=9) ";
/*MsRptNoTotalMonthController _saleList = new MsRptNoTotalMonthController();
var listData = _saleList.SaleListData(start, limit, relStrCondition, null, null, null, relStartMonth, relEndMonth);*/
var dataList = DSWebMobileService.MsRptOpProfitMonth.SaleListData(start, limit, relStrCondition, null, null, null, relStartMonth, relEndMonth);
string result = dataList.Content;
result = result.Replace("\r\n", "");
context.Response.ContentType = "text/plain";
context.Response.Write(result);
context.Response.End();
}
private void GetClientList(HttpContext context)
{
string relStartMonth = "";
string relEndMonth = "";
string relStrCondition = "";
string relBusinessFromDate = "";
string relBusinessToDate = "";
string relAccFromDate = "";
string relAccToDate = "";
string strCondition = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["s"].ToString());
string startMonth = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["sm"].ToString());
string endMonth = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["em"].ToString());
string businessFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["bfd"].ToString());
string businessToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["btd"].ToString());
string accFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["afd"].ToString());
string accToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["atd"].ToString());
string pattern = "\0";
string replacement = "";
int start = int.Parse(context.Request.QueryString["t"].ToString());
int limit = int.Parse(context.Request.QueryString["l"].ToString());
Regex rgx = new Regex(pattern);
relStrCondition = rgx.Replace(strCondition, replacement);
relStartMonth = rgx.Replace(startMonth, replacement);
relEndMonth = rgx.Replace(endMonth, replacement);
relBusinessFromDate = rgx.Replace(businessFromDate, replacement);
relBusinessToDate = rgx.Replace(businessToDate, replacement);
relAccFromDate = rgx.Replace(accFromDate, replacement);
relAccToDate = rgx.Replace(accToDate, replacement);
pattern = "\t";
Regex rgx2 = new Regex(pattern);
relStrCondition = rgx2.Replace(relStrCondition, replacement);
relStartMonth = rgx.Replace(relStartMonth, replacement);
relEndMonth = rgx.Replace(relEndMonth, replacement);
relBusinessFromDate = rgx.Replace(relBusinessFromDate, replacement);
relBusinessToDate = rgx.Replace(relBusinessToDate, replacement);
relAccFromDate = rgx.Replace(relAccFromDate, replacement);
relAccToDate = rgx.Replace(relAccToDate, replacement);
if (strCondition != "")
{
if (relStrCondition[0] == ',') { relStrCondition = relStrCondition.Substring(1, relStrCondition.Length - 1); }
}
if (relStrCondition != "")
{
relStrCondition += " and B.OPDATE>='" + relBusinessFromDate + " 00:00:00' and B.OPDATE<='" + relBusinessToDate + " 23:59:59'";
}
else
{
relStrCondition += " B.OPDATE>='" + relBusinessFromDate + " 00:00:00' and B.OPDATE<='" + relBusinessToDate + " 23:59:59'";
}
if (relAccFromDate != "") { relStrCondition += " and B.ACCDATE>='" + relAccFromDate.Substring(0, 7) + "'"; }
if (relAccToDate != "") { relStrCondition += " and B.ACCDATE<='" + relAccToDate.Substring(0, 7) + "'"; }
relStrCondition += " and F.AMOUNT<>F.SETTLEMENT ";
relStrCondition += " and (F.FEESTATUS=0 or F.FEESTATUS=8 or F.FEESTATUS=9) ";
/*MsRptNoTotalMonthController _custList = new MsRptNoTotalMonthController();
var listData = _custList.CustListData(start, limit, relStrCondition, null, null, null, relStartMonth, relEndMonth);*/
var dataList=DSWebMobileService.MsRptOpProfitMonth.CustListData(start, limit, relStrCondition, null, null, null, relStartMonth, relEndMonth);
string result = dataList.Content;
result = result.Replace("\r\n", "");
context.Response.ContentType = "text/plain";
context.Response.Write(result);
context.Response.End();
}
private void GetCombinationList(HttpContext context)
{
string relStartMonth = "";
string relEndMonth = "";
string relStrCondition = "";
string relBusinessFromDate = "";
string relBusinessToDate = "";
string relAccFromDate = "";
string relAccToDate = "";
string strCondition = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["s"].ToString());
string startMonth = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["sm"].ToString());
string endMonth = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["em"].ToString());
string businessFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["bfd"].ToString());
string businessToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["btd"].ToString());
string accFromDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["afd"].ToString());
string accToDate = Encrypt.DesDecrypt("#7c&e@63", context.Request.Form["atd"].ToString());
string pattern = "\0";
string replacement = "";
int start = int.Parse(context.Request.QueryString["t"].ToString());
int limit = int.Parse(context.Request.QueryString["l"].ToString());
Regex rgx = new Regex(pattern);
relStrCondition = rgx.Replace(strCondition, replacement);
relStartMonth = rgx.Replace(startMonth, replacement);
relEndMonth = rgx.Replace(endMonth, replacement);
relBusinessFromDate = rgx.Replace(businessFromDate, replacement);
relBusinessToDate = rgx.Replace(businessToDate, replacement);
relAccFromDate = rgx.Replace(accFromDate, replacement);
relAccToDate = rgx.Replace(accToDate, replacement);
pattern = "\t";
Regex rgx2 = new Regex(pattern);
relStrCondition = rgx2.Replace(relStrCondition, replacement);
relStartMonth = rgx.Replace(relStartMonth, replacement);
relEndMonth = rgx.Replace(relEndMonth, replacement);
relBusinessFromDate = rgx.Replace(relBusinessFromDate, replacement);
relBusinessToDate = rgx.Replace(relBusinessToDate, replacement);
relAccFromDate = rgx.Replace(relAccFromDate, replacement);
relAccToDate = rgx.Replace(relAccToDate, replacement);
if (strCondition != "")
{
if (relStrCondition[0] == ',') { relStrCondition = relStrCondition.Substring(1, relStrCondition.Length - 1); }
}
if (relStrCondition != "")
{
relStrCondition += " and B.OPDATE>='" + relBusinessFromDate + " 00:00:00' and B.OPDATE<='" + relBusinessToDate + " 23:59:59'";
}
else
{
relStrCondition += " B.OPDATE>='" + relBusinessFromDate + " 00:00:00' and B.OPDATE<='" + relBusinessToDate + " 23:59:59'";
}
if (relAccFromDate != "") { relStrCondition += " and B.ACCDATE>='" + relAccFromDate.Substring(0, 7) + "'"; }
if (relAccToDate != "") { relStrCondition += " and B.ACCDATE<='" + relAccToDate.Substring(0, 7) + "'"; }
relStrCondition += " and F.AMOUNT<>F.SETTLEMENT ";
relStrCondition += " and (F.FEESTATUS=0 or F.FEESTATUS=8 or F.FEESTATUS=9) ";
/*MsRptNoTotalMonthController _saleCustList = new MsRptNoTotalMonthController();
var listData = _saleCustList.SaleCustListData(start, limit, relStrCondition, null, null, null, relStartMonth, relEndMonth);*/
var dataList = DSWebMobileService.MsRptOpProfitMonth.SaleCustListData(start, limit, relStrCondition, null, null, null, relStartMonth, relEndMonth);
string result = dataList.Content;
result = result.Replace("\r\n", "");
context.Response.ContentType = "text/plain";
context.Response.Write(result);
context.Response.End();
}
public bool IsReusable
{
get
{
return false;
}
}
}
}
Reference in New Issue View Git Blame Copy Permalink