From 338a7ef46eddc9f2f0f8f40d17a37a9ef4a844bb Mon Sep 17 00:00:00 2001
From: YL <YL@LAPTOP-SE03PLUR>
Date: 星期五, 31 十二月 2021 01:08:59 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/SRM-WEBAPI
---
WebAPI/Controllers/WebAPIController.cs | 92 ++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 89 insertions(+), 3 deletions(-)
diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs
index 70a9d0c..df1ca51 100644
--- a/WebAPI/Controllers/WebAPIController.cs
+++ b/WebAPI/Controllers/WebAPIController.cs
@@ -1,4 +1,5 @@
锘縰sing DAL;
+using DBUtility;
using Microsoft.AspNet.SignalR;
using Model;
using SQLHelper;
@@ -132,6 +133,38 @@
}
}
+
+ /// <summary>
+ /// 鑾峰彇鐧诲綍椤电粍缁囧垪
+ /// </summary>
+ /// <returns></returns>
+ [Route("GetOrganizations")]
+ [HttpGet]
+ public object GetOrganizations()
+ {
+ try
+ {
+ ClsCN oCn = new ClsCN();
+ DataSet oDs = new DataSet();
+ //==========
+ oDs = oCn.RunProcReturn("select HItemID ID,Hname Name,HStopflag Stopflag from Xt_ORGANIZATIONS", "Xt_ORGANIZATIONS");
+ objjson.code = "1";
+ objjson.count = 1;
+ objjson.Message = "鑾峰彇鎴愬姛锛�";
+ objjson.data = oDs.Tables[0];
+ return objjson; ;
+ }
+ catch (Exception e)
+ {
+
+ objjson.code = "0";
+ objjson.count = 0;
+ objjson.Message = "鑾峰彇澶辫触锛佸紓甯�" + e.ToString();
+ objjson.data = null;
+ return objjson; ;
+ }
+ }
+
/// <summary>
/// 鐧诲綍
/// </summary>
@@ -147,7 +180,15 @@
DataSet ds = null;
ClsCNSRM oCnLoc = new ClsCNSRM();
DAL.ClsUser oUser = new DAL.ClsUser();
- ds = oUser.CheckCzymc(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim()));
+ Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
+ string sReturn = "娴嬭瘯";
+ string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref sReturn);
+ //LogService.Write(sReturn);
+ //LogService.Write(FCusName);
+ if (FCusName == "澶忓疂鐢靛櫒")
+ ds = oUser.CheckMainID(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim()));
+ else
+ ds = oUser.CheckCzymc(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim()));
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
@@ -200,7 +241,7 @@
return objJsonResult; ;
}
//===========
- oDs = oCn.RunProcReturn("select Czmm from Gy_Czygl where Czybm='" + UserName + "'", "Gy_Czygl");
+ oDs = oCn.RunProcReturn("select Czmm from Gy_Czygl where Czymc='" + UserName + "'", "Gy_Czygl");
if (oDs == null || oDs.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
@@ -211,7 +252,7 @@
}
else
{
- oCn.RunProc("update Gy_Czygl set Czmm='" + DBUtility.ClsPub.StrToPsd(PassWord.Trim()) + "' where Czybm='" + UserName.Trim() + "'");
+ oCn.RunProc("update Gy_Czygl set Czmm='" + DBUtility.ClsPub.StrToPsd(PassWord.Trim()) + "' where Czymc='" + UserName.Trim() + "'");
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "* 瀵嗙爜淇敼鎴愬姛锛�";
@@ -725,5 +766,50 @@
return objJsonResult; ;
}
+
+ #region [鍏憡鏁版嵁鏌ヨ]
+ [Route("MsgData")]
+ [HttpGet]
+ public object MsgData(string sWhere)
+ {
+ ClsCNSRM oCn = new ClsCNSRM();
+ DataSet oDs = new DataSet();
+ var sql = "select A.HInterID,b.HEntryID,A.HContext,A.HDeptID,D.HName HDeptName, A.HSendMan, B.HReceiveMan,A.HLevel,A.HDescription,case when B.HReadFlag=0 then '鏈槄' when B.HReadFlag=1 then '宸查槄' end HReadFlag,A.HDate" +
+ " from OA_InformBillMain A inner join OA_InformBillSub B on A.HInterID=B.HInterID left join Gy_Department D on A.HDeptID=D.HItemID where 1=1 " + sWhere;
+ oDs = oCn.RunProcReturn(sql, "OA_InformBillMain");
+ if (oDs.Tables[0].Rows.Count > 0)
+ {
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "杩斿洖鏁版嵁鎴愬姛锛�";
+ objJsonResult.data = oDs;
+ }
+ else
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "杩斿洖鏁版嵁澶辫触锛�";
+ objJsonResult.data = oDs;
+ }
+ return objJsonResult; ;
+ }
+ #endregion
+
+ #region[鏇存敼鍏憡鐘舵�乚
+ [Route("UpdateMessage")]
+ [HttpGet]
+ public object UpdateMessage(string UserName, string HInterID, string HEntryID)
+ {
+ ClsCNSRM oCn = new ClsCNSRM();
+ oCn.BeginTran();
+ oCn.RunProc("Update OA_InformBillSub set HReadFlag=1 HUpDater='" + UserName + "',HUpDateDate=getdate() where HInterID='" + HInterID + "' and HEntryID='" + HEntryID + "'", ref ClsPub.sExeReturnInfo);
+ oCn.Commit();
+ objjson.code = "1";
+ objjson.count = 1;
+ objjson.Message = ClsPub.sExeReturnInfo;
+ objjson.data = null;
+ return objjson; ;
+ }
+ #endregion
}
}
--
Gitblit v1.9.1