Model/生产管理/模具管理/ClsSc_MouldMaintainRuleBillSub_Item.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
Pub_Class/CustomerCls/WebClsPub.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
Pub_Class/Pub_Class.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/SBGL/Sb_EquipDotCheckBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
Model/Éú²ú¹ÜÀí/Ä£¾ß¹ÜÀí/ClsSc_MouldMaintainRuleBillSub_Item.cs
@@ -8,7 +8,7 @@ { //============ public Int64 HMaintainItemID;// int --ä¿å »é¡¹ç®ID public Int64 HMaintainItemID;// int --ä¿å »é¡¹ç®ID public string HMaintainItem;// varchar(100) --ä¿å »é¡¹ç® public string HMaintainPart;// varchar(100) --ä¿å »é¨ä½ public string HClaim;// varchar(100) --å ·ä½è¦æ± Pub_Class/CustomerCls/WebClsPub.cs
New file @@ -0,0 +1,147 @@ using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; namespace Pub_Class { public class WebClsPub { public static string ComputerName; public static string IPAddress; //夿æ¯é½å卿é,å¹¶åå ¥æ¥å¿ public static bool Security_Log(string gnsy, int LogTF, bool Msg, string CurUserName,ref string StrMessage) { //gnsy åè½ç´¢å¼,模å //usercode å½åç¨æ·ä»£ç //LogTF 1夿æé并忥å¿ï¼2åªåæ¥å¿ï¼3åªå¤ææé //Msg 没ææéæ¶ æ¯å¦æç¤ºæ¡ string UserID = CurUserName; try { ClsSqlHelper oCn = new ClsSqlHelper(); DataSet Ds = new DataSet(); DataSet DsUser = new DataSet(); DataSet DsJS = new DataSet();//è§è² long ModID = 0; bool HavRight = false; //æ¾å°æ¨¡åæé Ds = oCn.RunProcReturn("select * from xt_xtgnb where gnsy='" + gnsy.Trim() + "'", "xt_xtgnb"); if (Ds.Tables[0].Rows.Count == 0) { if (Msg == true) { StrMessage="æ²¡ææ¾å°è¯¥åè½æ¨¡åï¼"; } return false; } else { ModID = ClsPub.isLong(Ds.Tables[0].Rows[0]["ID"].ToString()); //è¿å模å } if (LogTF == 1 || LogTF == 3)//éè¦å¤ææé { //æ ¹æ®ç¨æ·åç§°å¤ææé DsUser = oCn.RunProcReturn("select * from gy_czygl where czymc='" + UserID.Trim() + "'", "gy_czygl"); if (DsUser.Tables[0].Rows.Count == 0) { if (Msg == true) { StrMessage = "æ²¡ææ¾å°å½åæä½åï¼"; } return false; } //æ ¹æ®ç¨æ·åç§°å¤ææé if ((bool)DsUser.Tables[0].Rows[0]["ManagerFlag"]) //æ¯å¦ç®¡çå { HavRight = true; } else { if (DsUser.Tables[0].Rows[0]["AuthorityID"].ToString().Trim().Substring((int)ModID - 1, 1) == "1") { HavRight = true; } else { //è·åç¨æ·ç» 并循ç¯å¤ææé //夿è§è²æ¯å¦ææé DsJS = oCn.RunProcReturn("select isnull(AuthorityID,'') AuthorityID from System_UserGroupinfo a inner join System_UserGroup b on a.GroupID=b.GroupID " + " Where a.USERID='" + UserID.Trim() + "'", "gy_czygl"); if (DsJS == null) { HavRight = false; } else { HavRight = false; for (int i = 0; i < DsJS.Tables[0].Rows.Count; i++) { if (ClsPub.isStrNull(DsJS.Tables[0].Rows[i]["AuthorityID"]).Length > ModID) { if (DsJS.Tables[0].Rows[i]["AuthorityID"].ToString().Trim().Substring((int)ModID - 1, 1) == "1") { HavRight = true; break; } } } } } } if (HavRight == false) { if (Msg == true) { StrMessage = "æ¨æ²¡ææé,请ä¸ç®¡çåèç³»ï¼"; } } } //éè¦åå ¥æ¥å¿ if ((LogTF == 1 && HavRight) || LogTF == 2) { Add_Log(Ds.Tables[0].Rows[0]["id"].ToString().Trim(), gnsy + "," + Ds.Tables[0].Rows[0]["gnmc"].ToString().Trim(), CurUserName, ref StrMessage); } return HavRight; } catch (Exception e) { if (Msg == true) { StrMessage = "夿æéæ¶åç°é误,请ä¸ç®¡çåèç³»ï¼"; } return false; } } //åå ¥æ¥å¿ /// <summary> /// åå ¥æ¥å¿ /// </summary> /// <param name="UserID">æ ç¨</param> /// <param name="WorkList">æä½æ¥å¿</param> /// <param name="CurUserName">æä½å</param> /// <returns></returns> public static bool Add_Log(string UserID, string WorkList, string CurUserName,ref string StrMessage) { ClsSqlHelper oCn = new ClsSqlHelper(); try { oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + CurUserName + "','" + ComputerName + "','" + WorkList + "','ERPç³»ç»','" + IPAddress + "','è¿å ¥')" ); return true; } catch (Exception e) { StrMessage = "åå ¥æ¥å¿æ¶åç°é,åå æ¯ï¼" + e.Message; return false; } } } } Pub_Class/Pub_Class.csproj
@@ -87,6 +87,7 @@ <Compile Include="CustomerCls\ClsPub.cs" /> <Compile Include="CustomerCls\Cell.cs" /> <Compile Include="Properties\AssemblyInfo.cs" /> <Compile Include="CustomerCls\WebClsPub.cs" /> </ItemGroup> <ItemGroup> <COMReference Include="stdole"> WebAPI/Controllers/SBGL/Sb_EquipDotCheckBillController.cs
@@ -186,6 +186,7 @@ } } #endregion #region [设å¤ç¹æ£è®°å½è¡¨å é¤åè½] /// <summary> /// æ¨¡å ·ç»´ä¿®åå é¤åè½ @@ -279,6 +280,7 @@ return new ApiResult<DataSet> { code = 1, msg = "æ¥è¯¢æå", data = dataSet }; } #endregion #region[设å¤ç¹æ£è®°å½è¡¨ç¼è¾æ¶è·åè¡¨é¢æ°æ®] [Route("Sb_EquipDotCheckBill/Sb_EquipDotCheckBillListProjectDetai")] [HttpGet] WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs
@@ -913,12 +913,13 @@ DBUtility.ClsPub.CurUserName = CurUserName; try { string StrMessage = ""; //å®¡æ ¸æé if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) if (!WebClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName,ref StrMessage)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼æ æéï¼"; objJsonResult.Message = StrMessage; objJsonResult.data = null; return objJsonResult; } WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs
@@ -2693,7 +2693,7 @@ ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainBillListItem"); //è·åé 件项ç®ç¼è¾æ°æ® string sql1 = "select HMaterID, é 件代ç HMaterNumber,é ä»¶åç§° HMaterName,è§æ ¼åå· HMaterSpec,HUnitID,åä½ä»£ç HUnitNumber,åä½åç§° HUnitName,å®é ç¨é HQty,æ åç¨é HQtyMust,HManagerID,è´è´£äººä»£ç HManagerNumber,è´è´£äºº HManagerName,表ä½å¤æ³¨ HRemark from h_v_Sc_MouldMaintainBillList where 1 = 1 " + Swhere + ""; ds1 = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainBillList"); ds1 = oCN.RunProcReturn(sql1, "h_v_Sc_MouldMaintainBillList"); list.Add(ds.Tables[0]); list.Add(ds1.Tables[0]); objJsonResult.code = "0"; WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user
@@ -18,28 +18,28 @@ <publishTime>02/22/2013 08:43:40</publishTime> </File> <File Include="bin/BLL.dll"> <publishTime>08/23/2021 12:09:10</publishTime> <publishTime>08/24/2021 15:02:10</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>08/23/2021 12:09:10</publishTime> <publishTime>08/24/2021 15:02:10</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>08/23/2021 12:09:08</publishTime> <publishTime>08/24/2021 15:02:08</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>08/23/2021 12:09:08</publishTime> <publishTime>08/24/2021 15:02:08</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 14:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> <publishTime>08/23/2021 12:09:06</publishTime> <publishTime>08/24/2021 15:02:06</publishTime> </File> <File Include="bin/DBUtility.pdb"> <publishTime>08/23/2021 12:09:06</publishTime> <publishTime>08/24/2021 15:02:06</publishTime> </File> <File Include="bin/Interop.gregn6Lib.dll"> <publishTime>08/23/2021 12:09:09</publishTime> <publishTime>08/24/2021 15:02:09</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> <publishTime>08/09/2021 09:06:25</publishTime> @@ -60,10 +60,10 @@ <publishTime>07/25/2012 11:48:56</publishTime> </File> <File Include="bin/Model.dll"> <publishTime>08/23/2021 12:09:06</publishTime> <publishTime>08/24/2021 15:02:07</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>08/23/2021 12:09:06</publishTime> <publishTime>08/24/2021 15:02:07</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>08/09/2021 09:06:27</publishTime> @@ -72,22 +72,22 @@ <publishTime>08/03/2014 20:33:56</publishTime> </File> <File Include="bin/Pub_Class.dll"> <publishTime>08/23/2021 12:09:05</publishTime> <publishTime>08/24/2021 15:02:05</publishTime> </File> <File Include="bin/Pub_Class.pdb"> <publishTime>08/23/2021 12:09:05</publishTime> <publishTime>08/24/2021 15:02:05</publishTime> </File> <File Include="bin/Pub_Control.dll"> <publishTime>08/23/2021 12:09:05</publishTime> <publishTime>08/24/2021 15:02:06</publishTime> </File> <File Include="bin/Pub_Control.pdb"> <publishTime>08/23/2021 12:09:05</publishTime> <publishTime>08/24/2021 15:02:06</publishTime> </File> <File Include="bin/SQLHelper.dll"> <publishTime>08/23/2021 12:09:05</publishTime> <publishTime>08/24/2021 15:02:06</publishTime> </File> <File Include="bin/SQLHelper.pdb"> <publishTime>08/23/2021 12:09:05</publishTime> <publishTime>08/24/2021 15:02:06</publishTime> </File> <File Include="bin/stdole.dll"> <publishTime>05/09/2021 13:35:37</publishTime> @@ -189,10 +189,10 @@ <publishTime>11/24/2014 11:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>08/23/2021 12:09:12</publishTime> <publishTime>08/24/2021 15:02:11</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>08/23/2021 12:09:12</publishTime> <publishTime>08/24/2021 15:02:11</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/17/2013 17:03:52</publishTime> @@ -363,7 +363,7 @@ <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web.config"> <publishTime>08/23/2021 12:09:20</publishTime> <publishTime>08/24/2021 15:02:18</publishTime> </File> </ItemGroup> </Project>