| SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache | 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Controllers/XSGL/YS_ReceiveBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Properties/PublishProfiles/FolderProfilewtt.pubxml.user | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| sdk_dingding/TopSdk/bin/Debug/TopSdk.dll | 补丁 | 查看 | 原始文档 | blame | 历史 | |
| sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb | 补丁 | 查看 | 原始文档 | blame | 历史 | |
| sdk_dingding/TopSdk/obj/Debug/TopSdk.dll | 补丁 | 查看 | 原始文档 | blame | 历史 | |
| sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb | 补丁 | 查看 | 原始文档 | blame | 历史 |
SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cacheBinary files differ
WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs
@@ -1894,5 +1894,110 @@ } } #endregion #region 销售出库单查询列表 [Route("Kf_SellOutBill/QueryList")] [HttpGet] public object QueryList(string sWhere, string user) { try { List<object> columnNameList = new List<object>(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Kf_SellOutBillQuery", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "无权限查看!"; objJsonResult.data = null; return objJsonResult; } string sql = "select * from h_v_Kf_SellOutBillQuery where 1 = 1 "; if (sWhere == "" || sWhere == null) { ds = oCN.RunProcReturn("select * from h_v_Kf_SellOutBillQuery order by hmainid desc", "h_v_Kf_SellOutBillQuery"); } else { ds = oCN.RunProcReturn(sql + sWhere + " order by hmainid desc", "h_v_Kf_SellOutBillQuery"); } foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 销售出库单查询子列表 [Route("Kf_SellOutBill/QuerySubList")] [HttpGet] public object QuerySubList(string hmainid, string user) { try { List<object> columnNameList = new List<object>(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Kf_SellOutBillQuery", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "无权限查看!"; objJsonResult.data = null; return objJsonResult; } string sql = "select * from h_v_Kf_SellOutBillQuerySub where hmainid = " + hmainid; ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_Kf_SellOutBillQuerySub"); foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion } } WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs
@@ -8,6 +8,7 @@ using System.Data.SqlClient; using System.Web.Http; using WebAPI.Models; using SyntacticSugar.constant; namespace WebAPI.Controllers { @@ -1531,5 +1532,109 @@ } #endregion #region 应收单查询列表 [Route("Xs_ReceivableBill/QueryList")] [HttpGet] public object QueryList(string sWhere, string user) { try { List<object> columnNameList = new List<object>(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Xs_ReceivableBill_Query", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "无权限查看!"; objJsonResult.data = null; return objJsonResult; } string sql = "select * from h_v_Xs_ReceivableBillQuery where 1 = 1 "; if (sWhere == "" || sWhere == null) { ds = oCN.RunProcReturn("select * from h_v_Xs_ReceivableBillQuery order by hmainid desc", "h_v_Xs_ReceivableBillQuery"); } else { ds = oCN.RunProcReturn(sql + sWhere + " order by hmainid desc", "h_v_Xs_ReceivableBillQuery"); } foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 应收单查询子列表 [Route("Xs_ReceivableBill/QuerySubList")] [HttpGet] public object QuerySubList(string hmainid, string user) { try { List<object> columnNameList = new List<object>(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Xs_ReceivableBill_Query", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "无权限查看!"; objJsonResult.data = null; return objJsonResult; } string sql = "select * from h_v_Xs_ReceivableBillQuerySub where hmainid = " + hmainid; ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_Xs_ReceivableBillQuerySub"); foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion } } WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs
@@ -1491,7 +1491,7 @@ [HttpGet] public object AuditXs_SeOutStockBill_Flow(int HInterID, int IsAudit, string CurUserName, string CurUserID) { //string ModRightNameCheck = "Cg_POOrderBill_Check"; //string ModRightNameCheck = "Xs_SeOutStockBill_Check"; DBUtility.ClsPub.CurUserName = CurUserName; try { @@ -1597,7 +1597,7 @@ #region 审核前的相关判断 //审核前控制========================================= string sql1 = "exec h_p_Xs_SeOutStockBill_BeforeCheckCtrl " + oBill.omodel.HInterID + ",'" + CurUserName + "'"; ds = oCN.RunProcReturn(sql1, "h_p_Cg_POOrderBill_BeforeCheckCtrl"); ds = oCN.RunProcReturn(sql1, "h_p_Xs_SeOutStockBill_BeforeCheckCtrl"); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; @@ -1725,7 +1725,7 @@ { #region 反审核前的相关判断 //反审核前控制========================================= DataSet ds = oCN.RunProcReturn("Exec h_p_Xs_SeOutStockBill_BeforeUnCheckCtrl " + oBill.omodel.HInterID + ",'" + CurUserName + "'", "h_p_Cg_POOrderBill_BeforeUnCheckCtrl"); DataSet ds = oCN.RunProcReturn("Exec h_p_Xs_SeOutStockBill_BeforeUnCheckCtrl " + oBill.omodel.HInterID + ",'" + CurUserName + "'", "h_p_Xs_SeOutStockBill_BeforeUnCheckCtrl"); if (ds == null) { objJsonResult.code = "0"; @@ -1922,5 +1922,109 @@ } } #endregion #region 发货通知单查询列表 [Route("Xs_SeOutStockBill/QueryList")] [HttpGet] public object QueryList(string sWhere, string user) { try { List<object> columnNameList = new List<object>(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Xs_SeOutStockBillQuery", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "无权限查看!"; objJsonResult.data = null; return objJsonResult; } string sql = "select * from h_v_Xs_SeOutStockBillQuery where 1 = 1 "; if (sWhere == "" || sWhere == null) { ds = oCN.RunProcReturn("select * from h_v_Xs_SeOutStockBillQuery order by hmainid desc", "h_v_Xs_SeOutStockBillQuery"); } else { ds = oCN.RunProcReturn(sql + sWhere + " order by hmainid desc", "h_v_Xs_SeOutStockBillQuery"); } foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 发货通知单查询子列表 [Route("Xs_SeOutStockBill/QuerySubList")] [HttpGet] public object QuerySubList(string hmainid, string user) { try { List<object> columnNameList = new List<object>(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Xs_SeOutStockBillQuery", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "无权限查看!"; objJsonResult.data = null; return objJsonResult; } string sql = "select * from h_v_Xs_SeOutStockBillQuerySub where hmainid = " + hmainid; ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_Xs_SeOutStockBillQuerySub"); foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion } } WebAPI/Controllers/XSGL/YS_ReceiveBillController.cs
@@ -8,6 +8,7 @@ using System.Data.SqlClient; using System.Web.Http; using WebAPI.Models; using SyntacticSugar.constant; namespace WebAPI.Controllers { @@ -1651,5 +1652,110 @@ } } #endregion #region 收款单查询列表 [Route("YS_ReceiveBill/QueryList")] [HttpGet] public object QueryList(string sWhere, string user) { try { List<object> columnNameList = new List<object>(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("YS_ReceiveBillQuery", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "无权限查看!"; objJsonResult.data = null; return objJsonResult; } string sql = "select * from h_v_YS_ReceiveBillQuery where 1 = 1 "; if (sWhere == "" || sWhere == null) { ds = oCN.RunProcReturn("select * from h_v_YS_ReceiveBillQuery order by hmainid desc", "h_v_YS_ReceiveBillQuery"); } else { ds = oCN.RunProcReturn(sql + sWhere + " order by hmainid desc", "h_v_YS_ReceiveBillQuery"); } foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 收款单查询子列表 [Route("YS_ReceiveBill/QuerySubList")] [HttpGet] public object QuerySubList(string hmainid, string user) { try { List<object> columnNameList = new List<object>(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("YS_ReceiveBillQuery", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "无权限查看!"; objJsonResult.data = null; return objJsonResult; } string sql = "select * from h_v_YS_ReceiveBillQuerySub where hmainid = " + hmainid; ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_YS_ReceiveBillQuerySub"); foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion } } WebAPI/Properties/PublishProfiles/FolderProfilewtt.pubxml.user
@@ -45,28 +45,28 @@ <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/BLL.dll"> <publishTime>09/10/2024 19:04:51</publishTime> <publishTime>09/11/2024 10:37:44</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>09/10/2024 19:04:51</publishTime> <publishTime>09/11/2024 10:37:44</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>09/10/2024 19:04:48</publishTime> <publishTime>09/11/2024 10:37:40</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>09/10/2024 19:04:48</publishTime> <publishTime>09/11/2024 10:37:40</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> <publishTime>09/10/2024 19:04:41</publishTime> <publishTime>09/11/2024 10:37:33</publishTime> </File> <File Include="bin/DBUtility.pdb"> <publishTime>09/10/2024 19:04:41</publishTime> <publishTime>09/11/2024 10:37:33</publishTime> </File> <File Include="bin/Grpc.Core.Api.dll"> <publishTime>03/22/2022 13:17:26</publishTime> @@ -111,10 +111,10 @@ <publishTime>07/25/2012 19:48:56</publishTime> </File> <File Include="bin/Model.dll"> <publishTime>09/10/2024 19:04:43</publishTime> <publishTime>09/11/2024 10:37:34</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>09/10/2024 19:04:43</publishTime> <publishTime>09/11/2024 10:37:34</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>04/15/2024 12:55:45</publishTime> @@ -147,34 +147,34 @@ <publishTime>10/23/2021 17:07:54</publishTime> </File> <File Include="bin/Pub_Class.dll"> <publishTime>09/10/2024 19:04:39</publishTime> <publishTime>09/11/2024 10:37:31</publishTime> </File> <File Include="bin/Pub_Class.pdb"> <publishTime>09/10/2024 19:04:39</publishTime> <publishTime>09/11/2024 10:37:31</publishTime> </File> <File Include="bin/Pub_Control.dll"> <publishTime>09/10/2024 19:04:40</publishTime> <publishTime>09/11/2024 10:37:32</publishTime> </File> <File Include="bin/Pub_Control.pdb"> <publishTime>09/10/2024 19:04:40</publishTime> <publishTime>09/11/2024 10:37:32</publishTime> </File> <File Include="bin/RestSharp.dll"> <publishTime>08/31/2012 06:22:50</publishTime> </File> <File Include="bin/SQLHelper.dll"> <publishTime>09/10/2024 19:04:41</publishTime> <publishTime>09/11/2024 10:37:32</publishTime> </File> <File Include="bin/SQLHelper.pdb"> <publishTime>09/10/2024 19:04:41</publishTime> <publishTime>09/11/2024 10:37:32</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/16/2015 01:57:08</publishTime> </File> <File Include="bin/SyntacticSugar.dll"> <publishTime>09/10/2024 19:02:30</publishTime> <publishTime>09/11/2024 10:20:46</publishTime> </File> <File Include="bin/SyntacticSugar.pdb"> <publishTime>09/10/2024 19:02:30</publishTime> <publishTime>09/11/2024 10:20:46</publishTime> </File> <File Include="bin/System.Buffers.dll"> <publishTime>07/19/2017 18:01:28</publishTime> @@ -285,19 +285,19 @@ <publishTime>05/09/2023 10:43:40</publishTime> </File> <File Include="bin/TopSdk.dll"> <publishTime>09/10/2024 19:02:37</publishTime> <publishTime>09/11/2024 10:20:53</publishTime> </File> <File Include="bin/TopSdk.pdb"> <publishTime>09/10/2024 19:02:37</publishTime> <publishTime>09/11/2024 10:20:53</publishTime> </File> <File Include="bin/WebActivatorEx.dll"> <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>09/10/2024 19:05:26</publishTime> <publishTime>09/11/2024 10:38:26</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>09/10/2024 19:05:26</publishTime> <publishTime>09/11/2024 10:38:26</publishTime> </File> <File Include="bin/WebAPI.XmlSerializers.dll"> <publishTime>08/16/2024 16:55:28</publishTime> sdk_dingding/TopSdk/bin/Debug/TopSdk.dllBinary files differ
sdk_dingding/TopSdk/bin/Debug/TopSdk.pdbBinary files differ
sdk_dingding/TopSdk/obj/Debug/TopSdk.dllBinary files differ
sdk_dingding/TopSdk/obj/Debug/TopSdk.pdbBinary files differ
