From 374ce4ffd0c459bb4067e8d5765f972668aff9b1 Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期四, 02 三月 2023 14:56:23 +0800
Subject: [PATCH] 变更oracle访问组件
---
web/web/GwProduct.ashx | 218 +++++++++++++++++++++++++++++++++++++----------------
1 files changed, 151 insertions(+), 67 deletions(-)
diff --git a/web/web/GwProduct.ashx b/web/web/GwProduct.ashx
index ce6f82d..b8f3d18 100644
--- a/web/web/GwProduct.ashx
+++ b/web/web/GwProduct.ashx
@@ -35,7 +35,9 @@
case "add":
return this.Add(context); //娣诲姞
case "list":
- return this.List(context); //鏌ヨ
+ return this.List(context); //浜у搧鏌ヨ
+ case "productClassesList":
+ return this.ProductClassesList(context); //浜у搧鏌ヨ
case "get":
return this.Get(context); //鑾峰彇璁板綍淇℃伅
case "updateStatus":
@@ -68,41 +70,45 @@
int num = 0;
foreach (GwProduct bean in list)
{
+
++num;
- str1 = str1 + (object) "<tr><td>" + "<img src=\"../static/images/productIcon/" + (object) bean.Icon + "\" >";
- str1 = str1 + "</td><td>" + bean.Name + "</td>";
- str1 = string.Concat(new object[4]
+ //str1 = str1 + (object) "<tr><td>" + "<img src=\"../static/images/productIcon/" + (object) bean.Icon + "\" >";
+ if (bean.Classes == 1 && !string.IsNullOrEmpty(bean.Icon))
{
- str1,
- "<td>",
- bean.Instructions,
- "</td>"
- });
- str1 = str1 + "<td>" + (object)this.ClassesToName(bean.Classes) + "</td>";
+ str1 += "<tr><td>" + "<img src=\"../static/images/productIcon/" + (object)bean.Icon + "\" >" + "</td>";
+ }
+ else
+ {
+ str1 += "<tr><td>" + (object)bean.Icon + "</td>";
+ }
+
+ str1 = str1 + "<td>" + ProductToName(bean.ParentId) + "</td>";
+ str1 += "<td>" + bean.Name + "</td>";
+ //str1 = str1 + "<td>" + (object)this.ClassesToName(bean.Classes) + "</td>";
if (bean.RouterType == 1)
{
- str1 += "<td rowspan=\"1\"><div class=\"btn btn-primary btn-xs\">鐐硅矾鐢�</div>";
- str1 += string.Format("<div>绉诲姩锛歿0}</div><div>鐢典俊锛歿1}</div><div>鑱旈�氾細{2}</div>", (object)this.GetOpName(bean.CmOpId), (object)this.GetOpName(bean.CtOpId), (object)this.GetOpName(bean.CuOpId));
+ str1 += "<td rowspan=\"1\"><span class='label label-primary'>閫氶亾</span>";
+ str1 += string.Format("<div style='margin-top:10px;'>绉诲姩锛歿0}</div><div>鐢典俊锛歿1}</div><div>鑱旈�氾細{2}</div>", (object)this.GetOpName(bean.CmOpId), (object)this.GetOpName(bean.CtOpId), (object)this.GetOpName(bean.CuOpId));
}
else if (bean.RouterType == 3)
{
- str1 += "<td rowspan=\"1\"><div class=\"btn btn-success btn-xs\">缁勮矾鐢�</div>";
- str1 += string.Format("<div>绉诲姩锛歿0}</div><div>鐢典俊锛歿1}</div><div>鑱旈�氾細{2}</div>", (object)this.GetGroupName(bean.CmGroupid), (object)this.GetGroupName(bean.CtGroupid), (object)this.GetGroupName(bean.CuGroupid));
+ str1 += "<td rowspan=\"1\"><span class='label label-success'>閫氶亾缁�</span>";
+ str1 += string.Format("<div style='margin-top:10px;'>绉诲姩锛歿0}</div><div>鐢典俊锛歿1}</div><div>鑱旈�氾細{2}</div>", (object)this.GetGroupName(bean.CmGroupid), (object)this.GetGroupName(bean.CtGroupid), (object)this.GetGroupName(bean.CuGroupid));
}
else
{
str1 += "<td rowspan=\"1\"></td>";
}
- str1 = str1 + "<td>" + ProductToName(bean.ParentId) + "</td>";
str1 = str1 + "<td>" + IsDefaultToName(bean.IsDefault) + "</td>";
str1 = str1 + "<td>" + IsEnableToName(bean.IsEnable) + "</td>";
- str1 = string.Concat(new object[4]
- {
- str1,
- "<td>",
- bean.Sort,
- "</td>"
- });
+ /**
+ str1 = string.Concat(new object[4]
+ {
+ str1,
+ "<td>",
+ bean.Sort,
+ "</td>"
+ });**/
str1 = string.Concat(new object[4]
{
str1,
@@ -111,9 +117,16 @@
"</td>"
});
- str1 += string.Format("<td>{0}鍏�/鏉�</td>", (object)(Convert.ToDecimal(bean.Price) / new Decimal(1000)));
+ str1 += string.Format("<td>{0}</td>", (object)(Convert.ToDecimal(bean.Price) / new Decimal(1000)));
str1 = str1 + "<td>" + bean.CreateTime + "</td>";
- str1 += "<td class=\"text-right\">";
+ str1 = string.Concat(new object[4]
+ {
+ str1,
+ "<td>",
+ bean.Instructions,
+ "</td>"
+ });
+ str1 += "<td class=\"text-center \">";
str1 = bean.IsEnable != 0 ? str1 + string.Format("<a href=\"javascript:;\" data-id=\"{0}\" data-is_enable=\"0\" class=\"action-update-status btn btn-primary btn-xs\"><i class=\"fa fa-toggle-off\"></i> 鍋滅敤</a> ", (object) bean.Id ) : str1 + string.Format("<a href=\"javascript:;\" data-id=\"{0}\" data-is_enable=\"1\" class=\"action-update-status btn btn-default btn-xs\"><i class=\"fa fa-toggle-on\"/></i> 鍚敤</a> ", (object) bean.Id );
str1 += string.Format("<a href=\"javascript:;\" data-id=\"{0}\" class=\"action-modal-edit btn btn-success btn-xs\"><i class=\"fa fa-edit\"></i> 缂栬緫</a> ", (object) bean.Id);
str1 += string.Format("<a href=\"javascript:;\" data-id=\"{0}\" class=\"action-delete btn btn-default btn-xs\"><i class=\"fa fa-trash\"></i> 鍒犻櫎</a> ", (object) bean.Id);
@@ -122,7 +135,57 @@
}
}
else
- str1 += "<tr><td colspan=\"13\" style=\"padding-left:5px; text-align: center;\">鏆傛棤淇℃伅</td></tr>";
+ str1 += "<tr><td colspan=\"11\" style=\"padding-left:5px; text-align: center;\">鏆傛棤淇℃伅</td></tr>";
+
+ return new JsonPageResult(true, new
+ {
+ Table = str1.ToString(),
+ TotalCount = recordCount
+ });
+ }
+
+
+
+ //鍔犺浇浜у搧鍒嗙被淇℃伅
+ private JsonPageResult ProductClassesList(PageContext<SysUser> context)
+ {
+ //Console.WriteLine("List.............[" + context.GetInt("name") + "][" + context.GetInt("classes") + "]");
+ int classes = context.GetInt("classes");
+ string name = context.GetString("name");
+
+ int recordCount = 0;
+ int pageSize = context.GetInt("pageSize", 50);
+ int pageIndex = context.GetInt("pageIndex", 1);
+
+ List<GwProduct> list = _Dao.LoadInfoList(classes, name, pageSize, pageIndex, out recordCount);
+
+ string str1 = "";
+ if (list != null && list.Count > 0)
+ {
+
+ int num = 0;
+ foreach (GwProduct bean in list)
+ {
+
+ ++num;
+
+ str1 += "<tr>";
+ str1 += "<td>" + bean.Name + "</td>";
+ str1 += "<td>" + ProductToName(bean.ParentId) + "</td>";
+ str1 = str1 + "<td>" + IsEnableToName(bean.IsEnable) + "</td>";
+ str1 = str1 + "<td>" + bean.CreateTime + "</td>";
+ str1 = str1 + "<td>" + bean.Remark + "</td>";
+
+ str1 += "<td class=\"text-center\">";
+ str1 = bean.IsEnable != 0 ? str1 + string.Format("<a href=\"javascript:;\" data-id=\"{0}\" data-is_enable=\"0\" class=\"action-update-status btn btn-primary btn-xs\"><i class=\"fa fa-toggle-off\"></i> 鍋滅敤</a> ", (object) bean.Id ) : str1 + string.Format("<a href=\"javascript:;\" data-id=\"{0}\" data-is_enable=\"1\" class=\"action-update-status btn btn-default btn-xs\"><i class=\"fa fa-toggle-on\"/></i> 鍚敤</a> ", (object) bean.Id );
+ str1 += string.Format("<a href=\"javascript:;\" data-id=\"{0}\" class=\"action-modal-edit btn btn-success btn-xs\"><i class=\"fa fa-edit\"></i> 缂栬緫</a> ", (object) bean.Id);
+ str1 += string.Format("<a href=\"javascript:;\" data-id=\"{0}\" class=\"action-delete btn btn-default btn-xs\"><i class=\"fa fa-trash\"></i> 鍒犻櫎</a> ", (object) bean.Id);
+ str1 += "</td>";
+ str1 += "</tr>";
+ }
+ }
+ else
+ str1 += "<tr><td colspan=\"11\" style=\"padding-left:5px; text-align: center;\">鏆傛棤淇℃伅</td></tr>";
return new JsonPageResult(true, new
{
@@ -203,6 +266,26 @@
int price = 0;
int givingNum = 0;
+ string parentId = context.GetString("parentId", "");
+ string path = "";
+ if (string.IsNullOrEmpty(parentId) )
+ {
+ path = "0";
+ }
+ else
+ {
+ GwProduct newProduct = _Dao.Get(parentId);
+ if(newProduct!=null)
+ {
+ path = newProduct.Path=="" ? "0" : newProduct.Path + "," + newProduct.Id ;
+ }
+ else
+ {
+ path = "0";
+ }
+
+ }
+
string info = "" ;
if (classes == -1) {
throw new ArgumentException("璇烽�夋嫨绫诲埆锛�");
@@ -215,6 +298,11 @@
if (string.IsNullOrEmpty(name))
{
throw new ArgumentException(info + "鍚嶇О涓嶈兘涓虹┖锛�");
+ }
+
+ if (string.IsNullOrEmpty(parentId))
+ {
+ throw new ArgumentException("鎵�灞炰骇鍝佺被鍒笉鑳戒负绌猴紒");
}
}
@@ -263,25 +351,7 @@
}
}
- string parentId = context.GetString("parentId", "0");
- string path = "";
- if (parentId.Equals("0"))
- {
- path = "0";
- }
- else
- {
- GwProduct newProduct = _Dao.Get(parentId);
- if(newProduct!=null)
- {
- path = newProduct.Path=="" ? "0" : newProduct.Path + "," + newProduct.Id ;
- }
- else
- {
- path = "0";
- }
- }
int isEnable = context.GetInt("isEnable", 0);
//int price = context.GetInt("price", 0);
@@ -384,6 +454,33 @@
int price = 0;
int givingNum = 0;
+ string parentId = context.GetString("parentId", "");
+ string path = "";
+
+ if (id == parentId)
+ {
+ throw new ArgumentException("鐖剁骇鍒嗙被id涓嶈兘閫夊綋鍓嶇被鍒紒璇烽噸鏂伴�夋嫨");
+ }
+
+
+ if (string.IsNullOrEmpty(parentId) )
+ {
+ path = "0";
+ }
+ else
+ {
+ GwProduct newProduct = _Dao.Get(parentId);
+ if(newProduct!=null)
+ {
+ path = newProduct.Path=="" ? "0" : newProduct.Path + "," + newProduct.Id ;
+ }
+ else
+ {
+ path = "0";
+ }
+
+ }
+
string info = "" ;
if (classes == -1) {
throw new ArgumentException("璇烽�夋嫨绫诲埆锛�");
@@ -396,6 +493,11 @@
if (string.IsNullOrEmpty(name))
{
throw new ArgumentException(info + "鍚嶇О涓嶈兘涓虹┖锛�");
+ }
+
+ if (string.IsNullOrEmpty(parentId))
+ {
+ throw new ArgumentException("鎵�灞炰骇鍝佺被鍒笉鑳戒负绌猴紒");
}
}
@@ -445,25 +547,7 @@
}
}
- string parentId = context.GetString("parentId", "0");
- string path = "";
- if (parentId.Equals("0"))
- {
- path = "0";
- }
- else
- {
- GwProduct newProduct = _Dao.Get(parentId);
- if(newProduct!=null)
- {
- path = newProduct.Path=="" ? "0" : newProduct.Path + "," + newProduct.Id ;
- }
- else
- {
- path = "0";
- }
- }
int isEnable = context.GetInt("isEnable", 0);
string remark = context.GetString("remark", "");
@@ -697,9 +781,9 @@
if (classes == -1)
return string.Empty;
else if(classes == 0)
- return "0-浜у搧鍒嗙被";
+ return "浜у搧鍒嗙被";
else if(classes == 1)
- return "1-浜у搧";
+ return "浜у搧";
return string.Empty;
}
@@ -710,9 +794,9 @@
if (isDefault == -1)
return string.Empty;
else if(isDefault == 0)
- return "0-涓�у寲";
+ return "<span class='label label-warning'>涓�у寲</span>";
else if(isDefault == 1)
- return "1-绯荤粺榛樿";
+ return "<span class='label label-success'>绯荤粺榛樿</span>";
return string.Empty;
}
@@ -723,9 +807,9 @@
if (isEnable == -1)
return string.Empty;
else if(isEnable == 0)
- return "0-鍋滅敤";
+ return "<span class='label label-default'>宸插仠鐢�</span>";
else if(isEnable == 1)
- return "1-鍚敤";
+ return "<span class='label label-primary'>宸插惎鐢�</span>";
return string.Empty;
}
--
Gitblit v1.9.1