From 9c98f5d15e35587b7bcd9d7c8a506c467e758632 Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期三, 08 六月 2022 00:54:15 +0800
Subject: [PATCH] 客户信息导出
---
web/web/GwSp.ashx | 80 ++++++++++++++++++++++++++++++++++------
1 files changed, 68 insertions(+), 12 deletions(-)
diff --git a/web/web/GwSp.ashx b/web/web/GwSp.ashx
index 6f41e03..25423cb 100644
--- a/web/web/GwSp.ashx
+++ b/web/web/GwSp.ashx
@@ -19,6 +19,11 @@
private List<GwDiverter> _DiverterList;
private List<GwAp> _APList;
private List<GwStrategy> _StrategyList;
+ private List<GwProduct> _ProductList;
+
+ private int _userId = -1;
+ private int _userType = -1;
+ private string _account = "";
private List<GwOp> OpList
{
@@ -52,8 +57,10 @@
{
if (this._ClientList == null)
{
- using (GwClientDao gwClientDao = new GwClientDao())
- this._ClientList = gwClientDao.LoadInfoList("", "", "", "");
+ using (GwClientDao gwClientDao = new GwClientDao()) {
+ string permissionsSQL = gwClientDao.GetClientPermissions(_userId, _userType, null);
+ this._ClientList = gwClientDao.LoadInfoList("", "", "", "", permissionsSQL);
+ }
}
return this._ClientList;
}
@@ -85,6 +92,25 @@
}
}
+ private List<GwProduct> ProductList
+ {
+ get
+ {
+ if (this._ProductList == null)
+ {
+ using (GwProductDao gwProductDao = new GwProductDao())
+ {
+ GwProduct gwProduct = new GwProduct();
+ gwProduct.Classes = -1;
+ gwProduct.IsDefault = -1;
+ gwProduct.IsEnable = -1;
+ this._ProductList = gwProductDao.getAllList(gwProduct);
+ }
+ }
+ return this._ProductList;
+ }
+ }
+
private List<GwStrategy> StrategyList
{
get
@@ -101,6 +127,10 @@
public override JsonPageResult ProcessRequestInternal(PageContext<SysUser> context)
{
string @string = context.GetString("action");
+ _userId = context.SessionObject.UserID;
+ _userType = context.SessionObject.UserType;
+ _account = context.SessionObject.Account;
+
switch (@string)
{
case "updateSpStatus":
@@ -285,16 +315,20 @@
int int3 = context.GetInt("pageSize", 20);
int int4 = context.GetInt("pageIndex", 1);
int int5 = context.GetInt("resendStatus", 1);
+ string productId = context.GetString("productId")==null? "": context.GetString("productId");
if (!string.IsNullOrEmpty(string3) && int1 <= 0)
throw new ArgumentException("璇烽�夋嫨閫氶亾缁勮矾鐢辨ā寮�");
GwSpDao gwSpDao = new GwSpDao();
string apId = "0";
if (this.IsInt(string1))
apId = string1;
- if (string.IsNullOrEmpty(clientId) && !string.IsNullOrEmpty(string4))
- clientId = new GwClientDao().GetClientName(string4).ClientID;
+ //if (string.IsNullOrEmpty(clientId) && !string.IsNullOrEmpty(string4))
+ // clientId = new GwClientDao().GetClientName(string4).ClientID;
+
+ string permissionsSQL = new GwClientDao().GetClientPermissions(_userId, _userType, null);
+
//鍔犺浇璐﹀彿鍒楄〃淇℃伅
- List<GwSp> list = gwSpDao.LoadInfoList(string2, apId, clientId, int1, string3, int2, int4, int3, int5.ToString(),out recordCount);
+ List<GwSp> list = gwSpDao.LoadInfoList(string2, apId, clientId, string4, int1, string3, int2, int4, int3, int5.ToString(), productId, permissionsSQL, out recordCount);
string str1 = "";
if (list != null && list.Count > 0)
{
@@ -302,6 +336,7 @@
{
str1 = str1 + "<tr><td rowspan=\"1\" ><input type=\"checkbox\"name=\"checkbox\" value=\"" + gwSp.SpID + "\"/></td><td rowspan=\"1\">" + gwSp.SpID + "<div class=\"text-muted\">" + this.GetAPName(gwSp.ApID) + "</div><div class=\"text-muted\">" + this.GetClientName(gwSp.ClientID) + "</div>";
str1 += "</td>";
+ str1 = str1 + "<td>" + (object)this.GetProductToName(gwSp.ProductId) + "</td>";
if (gwSp.RouterType == 1)
{
str1 += "<td rowspan=\"1\"><div class=\"btn btn-primary btn-xs\">鐐硅矾鐢�</div>";
@@ -328,7 +363,10 @@
string str2 = "<div class=\"text-muted\">" + gwSp.ChargerTypeText + "</div>";
if (gwSp.ChargerTypeText == "鍚庝粯璐�")
str2 = "<div style=\"color:red\">" + gwSp.ChargerTypeText + "</div>";
- str1 = str1 + (object)"<td><div class=\"text-muted\">" + (object)(gwSp.Balance / (long)gwSp.Price) + "鏉�/" + (object)((double)gwSp.Balance / 1000.0) + "鍏�</div>";
+ //add: yangzh by 2022-03-14 start
+ //str1 = str1 + (object)"<td><div class=\"text-muted\">" + (object)(gwSp.Balance / (long)gwSp.Price) + "鏉�/" + (object)((double)gwSp.Balance / 1000.0) + "鍏�</div>";
+ str1 = str1 + (object)"<td><div class=\"text-muted\">" + (object)(gwSp.BasicNum + (long)gwSp.GivingNum) + "鏉� / " + (object)(gwSp.BasicNum) + "鏉� / " + (object)(gwSp.GivingNum) + "鏉�</div>";
+ //add: yangzh by 2022-03-14 end
str1 = str1 + (object)str2 + "<div class=\"text-muted\">" + (object)((double)gwSp.Price / 1000.0) + "鍏�/鏉�</div>";
if (context.HasRight("3021"))
str1 += string.Format(" <a class=\"btn btn-xs btn-success action-modal-charge\" data-id=\"{0}\"><i class=\"fa fa-cny\"></i> 鍏呭��</a>", (object)gwSp.SpID);
@@ -353,8 +391,9 @@
if (context.HasRight("3023"))
str1 += string.Format(" <a class=\"btn-block btn btn-primary btn-xs action-modal-edit\" data-id=\"{0}\"><i class=\"fa fa-edit\"></i> 缂栬緫</a>", (object)gwSp.SpID);
str1 += string.Format(" <a class=\"btn-block btn btn-success btn-xs action-create-summary\" data-id=\"{0}\">璐﹀彿鎽樿</a>", (object)gwSp.SpID);
- if (context.HasRight("3024"))
- str1 += string.Format(" <a class=\"btn-block btn btn-xs btn-default action-delete\" data-id=\"{0}\"><i class=\"fa fa-trash\"></i> 鍒犻櫎</a>", (object)gwSp.SpID);
+
+ //if (context.HasRight("3024"))
+ // str1 += string.Format(" <a class=\"btn-block btn btn-xs btn-default action-delete\" data-id=\"{0}\"><i class=\"fa fa-trash\"></i> 鍒犻櫎</a>", (object)gwSp.SpID);
str1 += "</td>";
str1 += "</tr>";
}
@@ -480,6 +519,18 @@
return "銆�" + gwDiverter.DiverterName + "銆戝娴佺瓥鐣�";
}
+ //浜у搧杞悕绉�
+ private string GetProductToName(string productId)
+ {
+ GwProduct gwProduct = this.ProductList.Find((Predicate<GwProduct>)(bean => productId.Equals(bean.Id) ));
+ if (gwProduct != null)
+ {
+ //return string.Format("{0}-{1}", (object)gwAp.ApID, (object)gwAp.ApName);//2021.2.24.wzp鍙樻洿,鍚庣画鍙互鍒犻櫎
+ return string.Format("{0}", (object)gwProduct.Name);
+ }
+ return string.Empty;
+ }
+
private JsonPageResult LoadGwSpPageList(PageContext<SysUser> context)
{
string string1 = context.GetString("SelectedSpID");
@@ -533,7 +584,8 @@
o.AccessCode = context.GetString("AccessCode");
o.Priority = context.GetInt("Priority", 0);
o.Price = Math.Max((int)(context.GetDecimal("Price", new Decimal(4, 0, 0, false, (byte)2)) * new Decimal(1000)), 1);
- o.ChargeType = context.GetInt("ChargeType", 0);
+ //o.ChargeType = context.GetInt("ChargeType", 0);
+ o.IsAutoReturn = context.GetInt("IsAutoReturn", 0);
o.Threshold = Math.Max(context.GetInt("Threshold", 10), 10);
o.MaxConnCount = context.GetInt("MaxConnCount", 1);
o.Remark = context.GetString("Remark");
@@ -613,8 +665,11 @@
cTPattern.SpID = context.GetString("SpID");
cTPattern.Enabled = context.GetInt("enabled");
cTPattern.Pattern = context.GetString("patternContent");
- if (!Regex.IsMatch(o.SpID, "^\\d{6}$"))
- throw new Exception("璐﹀彿蹇呴』涓�6浣嶆暟瀛楋紒");
+ string pattern = @"^[A-Za-z0-9]+$"; //鍒ゆ柇鏄瓧绗︽垨鏁板瓧
+ //if (!Regex.IsMatch(o.SpID, "^\\d{6}$"))
+ // throw new Exception("璐﹀彿蹇呴』涓�6浣嶆暟瀛楋紒");
+ if (!Regex.IsMatch(o.SpID, "^[A-Za-z0-9]{6}$"))
+ throw new Exception("璐﹀彿蹇呴』涓�6浣嶅瓧绗︽垨鏁板瓧锛�");
if (o.AccessCodeMode == 1)
{
if (o.DiverterID != 0)
@@ -654,7 +709,8 @@
o.AccessCode = context.GetString("AccessCode");
o.Priority = context.GetInt("Priority", 0);
o.Price = Math.Max((int)(context.GetDecimal("Price", new Decimal(4, 0, 0, false, (byte)2)) * new Decimal(1000)), 1);
- o.ChargeType = context.GetInt("ChargeType", 0);
+ //o.ChargeType = context.GetInt("ChargeType", 0);
+ o.IsAutoReturn = context.GetInt("IsAutoReturn", 0);
o.Threshold = Math.Max(context.GetInt("Threshold", 10), 10);
o.MaxConnCount = context.GetInt("MaxConnCount", 1);
o.Remark = context.GetString("Remark");
--
Gitblit v1.9.1