From 7607bf50d30c45f51c71e7ccfad0eb95a309a1cb Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期二, 09 十一月 2021 15:28:49 +0800
Subject: [PATCH] 供应商协同登录查看权限取 用户对照供应商表
---
WebAPI/Controllers/POInStockController.cs | 19 ++++++++++---------
1 files changed, 10 insertions(+), 9 deletions(-)
diff --git a/WebAPI/Controllers/POInStockController.cs b/WebAPI/Controllers/POInStockController.cs
index 4e93d06..674312a 100644
--- a/WebAPI/Controllers/POInStockController.cs
+++ b/WebAPI/Controllers/POInStockController.cs
@@ -289,12 +289,12 @@
ListModels oListModels = new ListModels();
try
{
- DAL.ClsCg_POInStockBill oBill = new DAL.ClsCg_POInStockBill();
- List<Model.ClsCg_POInStockBillMain> lsmain = new List<Model.ClsCg_POInStockBillMain>();
+ DAL.ClsCg_POInStockBills oBill = new DAL.ClsCg_POInStockBills();
+ List<Model.ClsCg_POInStockBillMains> lsmain = new List<Model.ClsCg_POInStockBillMains>();
msg2 = msg2.Replace("\\", "");
msg2 = msg2.Replace("\n", ""); //\n
- lsmain = oListModels.getObjectByJson_POInStockMain(msg2);
- foreach (Model.ClsCg_POInStockBillMain oItem in lsmain)
+ lsmain = oListModels.getObjectByJson_POInStockMains(msg2);
+ foreach (Model.ClsCg_POInStockBillMains oItem in lsmain)
{
//oItem.HMaker = "";
UserName = oItem.HMaker;
@@ -322,10 +322,10 @@
msg3 = msg3.Replace("\\", "");
msg3 = msg3.Replace("\n", ""); //\n
//msg2 = msg2.Replace("'", "鈥�");
- List<Model.ClsCg_POInStockBillSub> ls = new List<Model.ClsCg_POInStockBillSub>();
- ls = oListModels.getObjectByJson_POInStockSub(msg3);
+ List<Model.ClsCg_POInStockBillSubs> ls = new List<Model.ClsCg_POInStockBillSubs>();
+ ls = oListModels.getObjectByJson_POInStockSubs(msg3);
int i = 0;
- foreach (Model.ClsCg_POInStockBillSub oItemSub in ls)
+ foreach (Model.ClsCg_POInStockBillSubs oItemSub in ls)
{
i++;
if (oItemSub.HQty <= 0)
@@ -423,12 +423,12 @@
//鍏朵粬杩囨护
if (msg.Trim() == "")
{
- msg = " Where hsupid in (select HItemID from h_v_IF_Supplier where hnumber=^^" + HSupNo.Trim() + "^^) " + sqlWhere;
+ msg = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 鐢ㄦ埛 =^^" + HSupNo.Trim() + "^^) " + sqlWhere;
// msg = " Where hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";
}
else
{
- msg = msg + " and hsupid in (select HItemID from h_v_IF_Supplier where hnumber=^^" + HSupNo.Trim() + "^^) " + sqlWhere;
+ msg = msg + " and hsupid in (select HSupID from h_v_Gy_UserSupplierList where 鐢ㄦ埛 =^^" + HSupNo.Trim() + "^^) " + sqlWhere;
// msg = msg + " Where hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";
}
//杞崲鐗规畩瀛楃
@@ -444,6 +444,7 @@
Int64 RowTotal = Common.GetRowTotal("H_v_SRM_POInStockBillList", VsWhere, ref DBUtility.ClsPub.sExeReturnInfo);
//鑾峰彇杩斿洖鏁版嵁
ds = oCn.RunProcReturn("exec H_p_SRM_POInStockBillList '" + PcWhere + "'", "H_p_SRM_POInStockBillList");
+ LogService.Write("exec H_p_SRM_POInStockBillList '" + PcWhere + "'");
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objjson.code = "0";
--
Gitblit v1.9.1