From 722ef8094b4357f01e08ff8984f679454aecf447 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期一, 25 三月 2024 13:12:19 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
---
WebAPI/Controllers/BLL/Xt_UserController.cs | 101 ++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 81 insertions(+), 20 deletions(-)
diff --git a/WebAPI/Controllers/BLL/Xt_UserController.cs b/WebAPI/Controllers/BLL/Xt_UserController.cs
index 4c60ad0..44ada4e 100644
--- a/WebAPI/Controllers/BLL/Xt_UserController.cs
+++ b/WebAPI/Controllers/BLL/Xt_UserController.cs
@@ -3218,12 +3218,26 @@
}
}
- //鍒ゅ畾璇ョ敤鎴蜂笌瀹㈡埛鏄惁宸茬粡鍏宠仈
- sql = "select * from Gy_UserCustomerRelation where HUserID = '" + HUserID + "' and HCusID = " + HCusID;
+ //鍒ゅ畾瀹㈡埛鏄惁宸茬粡鍏宠仈鐢ㄦ埛
+ sql = "select a.HItemID,a.HCusID,c.HName HCusName,a.HUserID,b.Czymc " +
+ " from Gy_UserCustomerRelation as a" +
+ " left join Gy_Czygl as b on a.HUserID = b.Czybm " +
+ " left join Gy_Customer as c on a.HCusID = c.HItemID " +
+ " where a.HCusID = " + HCusID;
ds = oCN.RunProcReturn(sql, "Gy_UserCustomerRelation");
- if (ds.Tables[0].Rows.Count > 0)
+ if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows[0]["HUserID"].ToString()!= HUserID)
{
- err += "鐢ㄦ埛宸茬粡鍏宠仈璇ュ鎴凤紱";
+ err += "鐢ㄦ埛銆�" + ds.Tables[0].Rows[0]["Czymc"].ToString() + "銆戝凡缁忓叧鑱斿鎴枫��" + ds.Tables[0].Rows[0]["HCusName"].ToString() + "銆戯紱";
+ }
+ else
+ {
+ //鍒ゅ畾璇ョ敤鎴蜂笌瀹㈡埛鏄惁宸茬粡鍏宠仈
+ sql = "select * from Gy_UserCustomerRelation where HUserID = '" + HUserID + "' and HCusID = " + HCusID;
+ ds = oCN.RunProcReturn(sql, "Gy_UserCustomerRelation");
+ if (ds.Tables[0].Rows.Count > 0)
+ {
+ err += "鐢ㄦ埛宸茬粡鍏宠仈璇ュ鎴凤紱";
+ }
}
tb2.Rows[i - 1]["鍒ゅ畾缁撴灉"] = err;
@@ -3305,12 +3319,26 @@
ds = oCN.RunProcReturn(sql, "Gy_UserCustomerRelation");
if (ds.Tables[0].Rows.Count == 0)
{
- sql = "insert into Gy_UserCustomerRelation(HUserID,HCusID)" +
+ sql = "select a.HItemID,a.HCusID,c.HName HCusName,a.HUserID,b.Czymc " +
+ " from Gy_UserCustomerRelation as a" +
+ " left join Gy_Czygl as b on a.HUserID = b.Czybm " +
+ " left join Gy_Customer as c on a.HCusID = c.HItemID " +
+ " where a.HCusID = " + HCusID;
+ ds = oCN.RunProcReturn(sql, "Gy_UserCustomerRelation");
+ if (ds.Tables[0].Rows.Count == 0)
+ {
+ sql = "insert into Gy_UserCustomerRelation(HUserID,HCusID)" +
"values(" +
"'" + HUserID + "'" +
"," + HCusID + "" +
")";
- oCN.RunProc(sql);
+ oCN.RunProc(sql);
+ }
+ else
+ {
+ err += "绗�" + i + "琛岋細鐢ㄦ埛銆�" + ds.Tables[0].Rows[0]["Czymc"].ToString() + "銆戝凡缁忓叧鑱斿鎴枫��" + ds.Tables[0].Rows[0]["HCusName"].ToString() + "銆�,瀹㈡埛涓嶅彲琚涓敤鎴峰叧鑱旓紒";
+ }
+ i++;
}
else
{
@@ -3318,7 +3346,18 @@
}
i++;
}
- }else if(saveType == "2")
+ //鍒ゆ柇鏄惁瀛樺湪閿欒
+ if (err.Length > 0)
+ {
+ oCN.RollBack();
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "瀵煎叆閿欒锛�" + err;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ else if(saveType == "2")
{
oCN.BeginTran();
string err = "";
@@ -3334,20 +3373,34 @@
string HOrgNumber = item["缁勭粐浠ｇ爜"].ToString();
string HOrgName = item["缁勭粐鍚嶇О"].ToString();
- sql = "select * from Gy_UserCustomerRelation where HUserID = '" + HUserID + "' and HCusID = " + HCusID;
+
+ sql = "select a.HItemID,a.HCusID,c.HName HCusName,a.HUserID,b.Czymc " +
+ " from Gy_UserCustomerRelation as a" +
+ " left join Gy_Czygl as b on a.HUserID = b.Czybm " +
+ " left join Gy_Customer as c on a.HCusID = c.HItemID " +
+ " where a.HCusID = " + HCusID;
ds = oCN.RunProcReturn(sql, "Gy_UserCustomerRelation");
- if (ds.Tables[0].Rows.Count == 0)
+ if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows[0]["HUserID"].ToString()!=HUserID)
{
- sql = "insert into Gy_UserCustomerRelation(HUserID,HCusID)" +
- "values(" +
- "'" + HUserID + "'" +
- "," + HCusID + "" +
- ")";
- oCN.RunProc(sql);
+ err += "绗�" + i + "琛岋細鐢ㄦ埛銆�" + ds.Tables[0].Rows[0]["Czymc"].ToString() + "銆戝凡缁忓叧鑱斿鎴枫��" + ds.Tables[0].Rows[0]["HCusName"].ToString() + "銆�,瀹㈡埛涓嶅彲琚涓敤鎴峰叧鑱旓紒";
}
else
{
- err += "绗�" + i + "琛岋細鐢ㄦ埛宸茬粡鍏宠仈璇ュ鎴�!";
+ sql = "select * from Gy_UserCustomerRelation where HUserID = '" + HUserID + "' and HCusID = " + HCusID;
+ ds = oCN.RunProcReturn(sql, "Gy_UserCustomerRelation");
+ if (ds.Tables[0].Rows.Count == 0)
+ {
+ sql = "insert into Gy_UserCustomerRelation(HUserID,HCusID)" +
+ "values(" +
+ "'" + HUserID + "'" +
+ "," + HCusID + "" +
+ ")";
+ oCN.RunProc(sql);
+ }
+ else
+ {
+ err += "绗�" + i + "琛岋細鐢ㄦ埛宸茬粡鍏宠仈璇ュ鎴�!";
+ }
}
i++;
}
@@ -3594,7 +3647,11 @@
string HCusName = item["HCusName"].ToString(); //瀹㈡埛鍚嶇О
- sql = "select * from Gy_UserCustomerRelation where HUserID = '" + HUserID + "' and HCusID = " + HCusID;
+ sql = "select a.HItemID,a.HCusID,c.HName HCusName,a.HUserID,b.Czymc " +
+ " from Gy_UserCustomerRelation as a" +
+ " left join Gy_Czygl as b on a.HUserID = b.Czybm " +
+ " left join Gy_Customer as c on a.HCusID = c.HItemID " +
+ " where a.HCusID = " + HCusID;
ds = oCN.RunProcReturn(sql, "Gy_UserCustomerRelation");
if (ds.Tables[0].Rows.Count == 0)
{
@@ -3607,7 +3664,7 @@
}
else
{
- err += "绗�" + i + "琛岋細鐢ㄦ埛銆�" + HUserName + "銆戝凡缁忓叧鑱斿鎴枫��" + HCusName + "銆�";
+ err += "绗�" + i + "琛岋細鐢ㄦ埛銆�" + ds.Tables[0].Rows[0]["Czymc"].ToString() + "銆戝凡缁忓叧鑱斿鎴枫��" + ds.Tables[0].Rows[0]["HCusName"].ToString() + "銆�,瀹㈡埛涓嶅彲琚涓敤鎴峰叧鑱旓紒";
}
i++;
}
@@ -3641,7 +3698,11 @@
ds = oCN.RunProcReturn(sql, "Gy_UserCustomerRelation");
if (ds.Tables[0].Rows.Count > 0)
{
- sql = "select * from Gy_UserCustomerRelation where HUserID = '" + HUserID + "' and HCusID = " + HCusID + " and HItemID <> " + HItemID;
+ sql = "select a.HItemID,a.HCusID,c.HName HCusName,a.HUserID,b.Czymc " +
+ " from Gy_UserCustomerRelation as a" +
+ " left join Gy_Czygl as b on a.HUserID = b.Czybm " +
+ " left join Gy_Customer as c on a.HCusID = c.HItemID " +
+ " where a.HCusID = " + HCusID + " and a.HItemID <> " + HItemID;
ds = oCN.RunProcReturn(sql, "Gy_UserCustomerRelation");
if(ds.Tables[0].Rows.Count == 0)
{
@@ -3653,7 +3714,7 @@
}
else
{
- err += "绗�" + i + "琛岋細鐢ㄦ埛銆�" + HUserName + "銆戝凡缁忓叧鑱斿鎴枫��" + HCusName + "銆�";
+ err += "绗�" + i + "琛岋細鐢ㄦ埛銆�" + ds.Tables[0].Rows[0]["Czymc"].ToString() + "銆戝凡缁忓叧鑱斿鎴枫��" + ds.Tables[0].Rows[0]["HCusName"].ToString() + "銆�,瀹㈡埛涓嶅彲琚涓敤鎴峰叧鑱旓紒";
}
}
else
--
Gitblit v1.9.1