MES-WEB-API.git

parent: 8abb4749 | 补丁 | 提交 | ignore whitespace

duhe

2023-07-20 d5d18d1308a426b0215e62388101aaf1fae276ca

工资结算单(其它)：添加审核、反审核、关闭、反关闭、作废、反作废功能

2个文件已修改

	WebAPI/Controllers/工资管理/Pay_OtherBalBillController.cs	327 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user	34 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 WebAPI/Controllers/¹¤×Ê¹ÜÀí/Pay_OtherBalBillController.cs

@@ -7,6 +7,7 @@
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
using Newtonsoft.Json;

namespace WebAPI.Controllers
{
@@ -19,6 +20,7 @@
        public DataSet ds = new DataSet();
        public WebServer webserver = new WebServer();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        public DAL.ClsSc_ICMOBill BillOld = new DAL.ClsSc_ICMOBill();
        //DataSet ds;
        public DLL.ClsPay_OtherBalBill BillNew0 = new DLL.ClsPay_OtherBalBill();   // 
        public DLL.ClsPay_OtherBalBill BillOld0 = new DLL.ClsPay_OtherBalBill();   //    
@@ -381,5 +383,330 @@
            }
        }
        //


        #region å·¥èµç»ç®å(å¶å®) å®¡æ ¸/åå®¡æ ¸
        /// <summary>
        /// 
        /// </summary>
        /// <param name="HInterID">åæ®ID</param>
        /// <param name="IsAudit">å®¡æ ¸(0),åå®¡æ ¸(1)</param>
        /// <param name="CurUserName">å®¡æ ¸äºº</param>
        /// <returns></returns>
        [Route("Pay_OtherBalBill/AuditPay_OtherBalBill")]
        [HttpGet]
        public object AuditPay_OtherBalBill(string HInterID, int Type, string user)
        {
            try
            {
                //å¤ææ¯å¦æå®¡æ ¸æé
                if (!DBUtility.ClsPub.Security_Log("Pay_OtherBalBill_Check", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "æ æéå®¡æ ¸!";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (string.IsNullOrWhiteSpace(HInterID))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "HInterIDä¸ºç©ºï¼";
                    objJsonResult.data = null;
                    return objJsonResult;
                }


                ClsPub.CurUserName = user;
                BillOld.MvarItemKey = "Pay_OtherBalBillMain";
                oCN.BeginTran();//å¼å§äºå¡

                //Type 1 å®¡æ ¸  2  åå®¡æ ¸
                if (Type == 1)
                {
                    //å¤æåæ®æ¯å¦å·²ç»å®¡æ ¸
                    DataSet ds;
                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                    {
                        if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "åæ®å·²å®¡æ ¸!ä¸éè¦åå®¡æ ¸!";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    //å®¡æ ¸åæ®
                    if (!BillOld.CheckBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else
                {
                    //å¤æåæ®æ¯å¦å·²ç»åå®¡æ ¸
                    DataSet ds;
                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                    {
                        if (ds.Tables[0].Rows[0]["HChecker"] == null || ds.Tables[0].Rows[0]["HChecker"].ToString() == "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "åæ®å·²åå®¡æ ¸!ä¸éè¦ååå®¡æ ¸!";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    //åå®¡æ ¸åæ®
                    if (!BillOld.AbandonCheck(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "åå®¡æ ¸å¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }

                oCN.Commit();//æäº¤äºå¡

                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "æ§è¡æåï¼";
                objJsonResult.data = null;
                return objJsonResult; ;

            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "æ§è¡å¤±è´¥ï¼" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
        #region å·¥èµç»ç®å(å¶å®) å³é/åå³éåè½
        [Route("Pay_OtherBalBill/ClosePay_OtherBalBill")]
        [HttpGet]
        public object ClosePay_OtherBalBill(string HInterID, int Type, string user)
        {
            try
            {
                //å¤ææ¯å¦æå é¤æé
                if (!DBUtility.ClsPub.Security_Log("Pay_OtherBalBill_Close", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "æ æéå³é!";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (string.IsNullOrWhiteSpace(HInterID))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "HInterIDä¸ºç©ºï¼";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                ClsPub.CurUserName = user;
                BillOld.MvarItemKey = "Pay_OtherBalBillMain";
                oCN.BeginTran();//å¼å§äºå¡

                //Type 1 å³é  2  åå³é
                if (Type == 1)
                {
                    //å¤æåæ®æ¯å¦å·²ç»å³é
                    DataSet ds;
                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                    {
                        if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "åæ®å·²å³é!ä¸éè¦åå³é!";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    //å³éåæ®
                    if (!BillOld.CloseBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "å³éå¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else
                {
                    //å¤æåæ®æ¯å¦å·²ç»åå³é
                    DataSet ds;
                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                    {
                        if (ds.Tables[0].Rows[0]["HCloseMan"] == null || ds.Tables[0].Rows[0]["HCloseMan"].ToString() == "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "åæ®å·²åå³é!ä¸éè¦ååå³é!";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    //åå³éåæ®
                    if (!BillOld.CancelClose(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "åå³éå¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }

                oCN.Commit();//æäº¤äºå¡

                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "æ§è¡æåï¼";
                objJsonResult.data = null;
                return objJsonResult; ;

            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "æ§è¡å¤±è´¥ï¼" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
        #region å·¥èµç»ç®å(å¶å®) ä½åº/åä½åºåè½
        [Route("Pay_OtherBalBill/DropPay_OtherBalBill")]
        [HttpGet]
        public object DropPay_OtherBalBill(string HInterID, int Type, string user)
        {
            try
            {
                //å¤ææ¯å¦æä½åºæé
                if (!DBUtility.ClsPub.Security_Log("Pay_OtherBalBill_Delete", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "æ æéä½åº!";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (string.IsNullOrWhiteSpace(HInterID))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "HInterIDä¸ºç©ºï¼";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                ClsPub.CurUserName = user;
                BillOld.MvarItemKey = "Pay_OtherBalBillMain";
                oCN.BeginTran();//å¼å§äºå¡

                //Type 1 ä½åº  2  åä½åº
                if (Type == 1)
                {
                    //å¤æåæ®æ¯å¦å·²ç»ä½åº
                    DataSet ds;
                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                    {
                        if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "åæ®å·²ä½åº!ä¸éè¦åä½åº!";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    //ä½åºåæ®
                    if (!BillOld.Cancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "ä½åºå¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else
                {
                    //å¤æåæ®æ¯å¦å·²ç»åä½åº
                    DataSet ds;
                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                    {
                        if (ds.Tables[0].Rows[0]["HDeleteMan"] == null || ds.Tables[0].Rows[0]["HDeleteMan"].ToString() == "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "åæ®å·²åä½åº!ä¸éè¦ååä½åº!";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    //åä½åºåæ®
                    if (!BillOld.AbandonCancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "åä½åºå¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }

                oCN.Commit();//æäº¤äºå¡

                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "æ§è¡æåï¼";
                objJsonResult.data = null;
                return objJsonResult; ;

            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "æ§è¡å¤±è´¥ï¼" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
    }
}

 WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user

@@ -20,12 +20,12 @@
    <File Include="bin/BLL.dll">
      <publishTime>11/09/2022 16:02:08</publishTime>
      <publishTime>11/02/2022 22:03:01</publishTime>
      <publishTime>07/20/2023 09:57:00</publishTime>
      <publishTime>07/20/2023 10:38:39</publishTime>
    </File>
    <File Include="bin/BLL.pdb">
      <publishTime>11/09/2022 16:02:08</publishTime>
      <publishTime>11/02/2022 22:03:01</publishTime>
      <publishTime>07/20/2023 09:57:00</publishTime>
      <publishTime>07/20/2023 10:38:39</publishTime>
    </File>
    <File Include="bin/BouncyCastle.Crypto.dll">
      <publishTime>12/18/2020 05:32:28</publishTime>
@@ -33,12 +33,12 @@
    <File Include="bin/DAL.dll">
      <publishTime>11/09/2022 16:02:06</publishTime>
      <publishTime>11/02/2022 22:02:58</publishTime>
      <publishTime>07/20/2023 09:56:58</publishTime>
      <publishTime>07/20/2023 10:38:37</publishTime>
    </File>
    <File Include="bin/DAL.pdb">
      <publishTime>11/09/2022 16:02:06</publishTime>
      <publishTime>11/02/2022 22:02:58</publishTime>
      <publishTime>07/20/2023 09:56:58</publishTime>
      <publishTime>07/20/2023 10:38:37</publishTime>
    </File>
    <File Include="bin/Dapper.dll">
      <publishTime>07/22/2016 22:52:40</publishTime>
@@ -46,12 +46,12 @@
    <File Include="bin/DBUtility.dll">
      <publishTime>11/02/2022 22:02:56</publishTime>
      <publishTime>11/15/2022 13:55:23</publishTime>
      <publishTime>07/20/2023 09:56:55</publishTime>
      <publishTime>07/20/2023 10:38:34</publishTime>
    </File>
    <File Include="bin/DBUtility.pdb">
      <publishTime>11/09/2022 16:01:58</publishTime>
      <publishTime>11/02/2022 22:02:56</publishTime>
      <publishTime>07/20/2023 09:56:55</publishTime>
      <publishTime>07/20/2023 10:38:34</publishTime>
    </File>
    <File Include="bin/Grpc.Core.Api.dll">
      <publishTime>03/22/2022 13:17:26</publishTime>
@@ -107,12 +107,12 @@
    <File Include="bin/Model.dll">
      <publishTime>11/09/2022 16:02:01</publishTime>
      <publishTime>11/02/2022 22:02:56</publishTime>
      <publishTime>07/20/2023 09:56:56</publishTime>
      <publishTime>07/20/2023 10:38:35</publishTime>
    </File>
    <File Include="bin/Model.pdb">
      <publishTime>11/09/2022 16:02:01</publishTime>
      <publishTime>11/02/2022 22:02:56</publishTime>
      <publishTime>07/20/2023 09:56:56</publishTime>
      <publishTime>07/20/2023 10:38:35</publishTime>
    </File>
    <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs">
      <publishTime>04/06/2023 15:57:02</publishTime>
@@ -147,33 +147,33 @@
    <File Include="bin/Pub_Class.dll">
      <publishTime>11/09/2022 16:01:56</publishTime>
      <publishTime>11/02/2022 22:02:54</publishTime>
      <publishTime>07/20/2023 09:56:54</publishTime>
      <publishTime>07/20/2023 10:38:33</publishTime>
    </File>
    <File Include="bin/Pub_Class.pdb">
      <publishTime>11/09/2022 16:01:56</publishTime>
      <publishTime>11/02/2022 22:02:54</publishTime>
      <publishTime>07/20/2023 09:56:54</publishTime>
      <publishTime>07/20/2023 10:38:33</publishTime>
    </File>
    <File Include="bin/Pub_Control.dll">
      <publishTime>11/09/2022 16:01:57</publishTime>
      <publishTime>11/02/2022 22:02:55</publishTime>
      <publishTime>07/20/2023 09:56:54</publishTime>
      <publishTime>07/20/2023 10:38:33</publishTime>
    </File>
    <File Include="bin/Pub_Control.pdb">
      <publishTime>11/09/2022 16:01:57</publishTime>
      <publishTime>11/02/2022 22:02:55</publishTime>
      <publishTime>07/20/2023 09:56:54</publishTime>
      <publishTime>07/20/2023 10:38:33</publishTime>
    </File>
    <File Include="bin/RestSharp.dll">
      <publishTime>08/31/2012 06:22:50</publishTime>
    </File>
    <File Include="bin/SQLHelper.dll">
      <publishTime>07/20/2023 09:56:55</publishTime>
      <publishTime>07/20/2023 10:38:34</publishTime>
    </File>
    <File Include="bin/SQLHelper.pdb">
      <publishTime>11/09/2022 16:01:57</publishTime>
      <publishTime>11/02/2022 22:02:55</publishTime>
      <publishTime>07/20/2023 09:56:55</publishTime>
      <publishTime>07/20/2023 10:38:34</publishTime>
    </File>
    <File Include="bin/stdole.dll">
      <publishTime>05/09/2021 13:35:37</publishTime>
@@ -286,7 +286,7 @@
    <File Include="bin/WebAPI.dll">
      <publishTime>11/14/2022 11:23:59</publishTime>
      <publishTime>11/02/2022 22:03:04</publishTime>
      <publishTime>07/20/2023 09:57:06</publishTime>
      <publishTime>07/20/2023 10:38:44</publishTime>
    </File>
    <File Include="bin/WebAPI.dll.config">
      <publishTime>12/15/2021 17:59:43</publishTime>
@@ -294,7 +294,7 @@
    <File Include="bin/WebAPI.pdb">
      <publishTime>11/14/2022 11:23:59</publishTime>
      <publishTime>11/02/2022 22:03:04</publishTime>
      <publishTime>07/20/2023 09:57:06</publishTime>
      <publishTime>07/20/2023 10:38:44</publishTime>
    </File>
    <File Include="bin/WebGrease.dll">
      <publishTime>07/18/2013 01:03:52</publishTime>
@@ -503,7 +503,7 @@
    <File Include="Web.config">
      <publishTime>11/14/2022 11:24:08</publishTime>
      <publishTime>11/02/2022 22:03:20</publishTime>
      <publishTime>07/20/2023 09:57:09</publishTime>
      <publishTime>07/20/2023 10:38:48</publishTime>
    </File>
  </ItemGroup>
</Project>

			@@ -7,6 +7,7 @@
			using System.Data.SqlClient;
			using System.Web.Http;
			using WebAPI.Models;
			using Newtonsoft.Json;

			namespace WebAPI.Controllers
			{
			@@ -19,6 +20,7 @@
			public DataSet ds = new DataSet();
			public WebServer webserver = new WebServer();
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			public DAL.ClsSc_ICMOBill BillOld = new DAL.ClsSc_ICMOBill();
			//DataSet ds;
			public DLL.ClsPay_OtherBalBill BillNew0 = new DLL.ClsPay_OtherBalBill(); //
			public DLL.ClsPay_OtherBalBill BillOld0 = new DLL.ClsPay_OtherBalBill(); //
			@@ -381,5 +383,330 @@
			}
			}
			//


			#region å·¥èµç»ç®å(å¶å®) å®¡æ ¸/åå®¡æ ¸
			/// <summary>
			///
			/// </summary>
			/// <param name="HInterID">åæ®ID</param>
			/// <param name="IsAudit">å®¡æ ¸(0),åå®¡æ ¸(1)</param>
			/// <param name="CurUserName">å®¡æ ¸äºº</param>
			/// <returns></returns>
			[Route("Pay_OtherBalBill/AuditPay_OtherBalBill")]
			[HttpGet]
			public object AuditPay_OtherBalBill(string HInterID, int Type, string user)
			{
			try
			{
			//å¤ææ¯å¦æå®¡æ ¸æé
			if (!DBUtility.ClsPub.Security_Log("Pay_OtherBalBill_Check", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ æéå®¡æ ¸!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (string.IsNullOrWhiteSpace(HInterID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterIDä¸ºç©ºï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}


			ClsPub.CurUserName = user;
			BillOld.MvarItemKey = "Pay_OtherBalBillMain";
			oCN.BeginTran();//å¼å§äºå¡

			//Type 1 å®¡æ ¸ 2 åå®¡æ ¸
			if (Type == 1)
			{
			//å¤æåæ®æ¯å¦å·²ç»å®¡æ ¸
			DataSet ds;
			string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
			ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
			if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
			{
			if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®å·²å®¡æ ¸!ä¸éè¦åå®¡æ ¸!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			//å®¡æ ¸åæ®
			if (!BillOld.CheckBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			//å¤æåæ®æ¯å¦å·²ç»åå®¡æ ¸
			DataSet ds;
			string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
			ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
			if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
			{
			if (ds.Tables[0].Rows[0]["HChecker"] == null \|\| ds.Tables[0].Rows[0]["HChecker"].ToString() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®å·²åå®¡æ ¸!ä¸éè¦ååå®¡æ ¸!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			//åå®¡æ ¸åæ®
			if (!BillOld.AbandonCheck(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "åå®¡æ ¸å¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			oCN.Commit();//æäº¤äºå¡

			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "æ§è¡æåï¼";
			objJsonResult.data = null;
			return objJsonResult; ;

			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ§è¡å¤±è´¥ï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion
			#region å·¥èµç»ç®å(å¶å®) å³é/åå³éåè½
			[Route("Pay_OtherBalBill/ClosePay_OtherBalBill")]
			[HttpGet]
			public object ClosePay_OtherBalBill(string HInterID, int Type, string user)
			{
			try
			{
			//å¤ææ¯å¦æå é¤æé
			if (!DBUtility.ClsPub.Security_Log("Pay_OtherBalBill_Close", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ æéå³é!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (string.IsNullOrWhiteSpace(HInterID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterIDä¸ºç©ºï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ClsPub.CurUserName = user;
			BillOld.MvarItemKey = "Pay_OtherBalBillMain";
			oCN.BeginTran();//å¼å§äºå¡

			//Type 1 å³é 2 åå³é
			if (Type == 1)
			{
			//å¤æåæ®æ¯å¦å·²ç»å³é
			DataSet ds;
			string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
			ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
			if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
			{
			if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®å·²å³é!ä¸éè¦åå³é!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			//å³éåæ®
			if (!BillOld.CloseBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "å³éå¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			//å¤æåæ®æ¯å¦å·²ç»åå³é
			DataSet ds;
			string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
			ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
			if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
			{
			if (ds.Tables[0].Rows[0]["HCloseMan"] == null \|\| ds.Tables[0].Rows[0]["HCloseMan"].ToString() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®å·²åå³é!ä¸éè¦ååå³é!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			//åå³éåæ®
			if (!BillOld.CancelClose(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "åå³éå¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			oCN.Commit();//æäº¤äºå¡

			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "æ§è¡æåï¼";
			objJsonResult.data = null;
			return objJsonResult; ;

			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ§è¡å¤±è´¥ï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion
			#region å·¥èµç»ç®å(å¶å®) ä½åº/åä½åºåè½
			[Route("Pay_OtherBalBill/DropPay_OtherBalBill")]
			[HttpGet]
			public object DropPay_OtherBalBill(string HInterID, int Type, string user)
			{
			try
			{
			//å¤ææ¯å¦æä½åºæé
			if (!DBUtility.ClsPub.Security_Log("Pay_OtherBalBill_Delete", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ æéä½åº!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (string.IsNullOrWhiteSpace(HInterID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterIDä¸ºç©ºï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ClsPub.CurUserName = user;
			BillOld.MvarItemKey = "Pay_OtherBalBillMain";
			oCN.BeginTran();//å¼å§äºå¡

			//Type 1 ä½åº 2 åä½åº
			if (Type == 1)
			{
			//å¤æåæ®æ¯å¦å·²ç»ä½åº
			DataSet ds;
			string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
			ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
			if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
			{
			if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®å·²ä½åº!ä¸éè¦åä½åº!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			//ä½åºåæ®
			if (!BillOld.Cancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "ä½åºå¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			//å¤æåæ®æ¯å¦å·²ç»åä½åº
			DataSet ds;
			string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
			ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
			if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
			{
			if (ds.Tables[0].Rows[0]["HDeleteMan"] == null \|\| ds.Tables[0].Rows[0]["HDeleteMan"].ToString() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®å·²åä½åº!ä¸éè¦ååä½åº!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			//åä½åºåæ®
			if (!BillOld.AbandonCancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "åä½åºå¤±è´¥!åå :" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			oCN.Commit();//æäº¤äºå¡

			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "æ§è¡æåï¼";
			objJsonResult.data = null;
			return objJsonResult; ;

			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ§è¡å¤±è´¥ï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion
			}
			}

			@@ -20,12 +20,12 @@
			<File Include="bin/BLL.dll">
			<publishTime>11/09/2022 16:02:08</publishTime>
			<publishTime>11/02/2022 22:03:01</publishTime>
			<publishTime>07/20/2023 09:57:00</publishTime>
			<publishTime>07/20/2023 10:38:39</publishTime>
			</File>
			<File Include="bin/BLL.pdb">
			<publishTime>11/09/2022 16:02:08</publishTime>
			<publishTime>11/02/2022 22:03:01</publishTime>
			<publishTime>07/20/2023 09:57:00</publishTime>
			<publishTime>07/20/2023 10:38:39</publishTime>
			</File>
			<File Include="bin/BouncyCastle.Crypto.dll">
			<publishTime>12/18/2020 05:32:28</publishTime>
			@@ -33,12 +33,12 @@
			<File Include="bin/DAL.dll">
			<publishTime>11/09/2022 16:02:06</publishTime>
			<publishTime>11/02/2022 22:02:58</publishTime>
			<publishTime>07/20/2023 09:56:58</publishTime>
			<publishTime>07/20/2023 10:38:37</publishTime>
			</File>
			<File Include="bin/DAL.pdb">
			<publishTime>11/09/2022 16:02:06</publishTime>
			<publishTime>11/02/2022 22:02:58</publishTime>
			<publishTime>07/20/2023 09:56:58</publishTime>
			<publishTime>07/20/2023 10:38:37</publishTime>
			</File>
			<File Include="bin/Dapper.dll">
			<publishTime>07/22/2016 22:52:40</publishTime>
			@@ -46,12 +46,12 @@
			<File Include="bin/DBUtility.dll">
			<publishTime>11/02/2022 22:02:56</publishTime>
			<publishTime>11/15/2022 13:55:23</publishTime>
			<publishTime>07/20/2023 09:56:55</publishTime>
			<publishTime>07/20/2023 10:38:34</publishTime>
			</File>
			<File Include="bin/DBUtility.pdb">
			<publishTime>11/09/2022 16:01:58</publishTime>
			<publishTime>11/02/2022 22:02:56</publishTime>
			<publishTime>07/20/2023 09:56:55</publishTime>
			<publishTime>07/20/2023 10:38:34</publishTime>
			</File>
			<File Include="bin/Grpc.Core.Api.dll">
			<publishTime>03/22/2022 13:17:26</publishTime>
			@@ -107,12 +107,12 @@
			<File Include="bin/Model.dll">
			<publishTime>11/09/2022 16:02:01</publishTime>
			<publishTime>11/02/2022 22:02:56</publishTime>
			<publishTime>07/20/2023 09:56:56</publishTime>
			<publishTime>07/20/2023 10:38:35</publishTime>
			</File>
			<File Include="bin/Model.pdb">
			<publishTime>11/09/2022 16:02:01</publishTime>
			<publishTime>11/02/2022 22:02:56</publishTime>
			<publishTime>07/20/2023 09:56:56</publishTime>
			<publishTime>07/20/2023 10:38:35</publishTime>
			</File>
			<File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs">
			<publishTime>04/06/2023 15:57:02</publishTime>
			@@ -147,33 +147,33 @@
			<File Include="bin/Pub_Class.dll">
			<publishTime>11/09/2022 16:01:56</publishTime>
			<publishTime>11/02/2022 22:02:54</publishTime>
			<publishTime>07/20/2023 09:56:54</publishTime>
			<publishTime>07/20/2023 10:38:33</publishTime>
			</File>
			<File Include="bin/Pub_Class.pdb">
			<publishTime>11/09/2022 16:01:56</publishTime>
			<publishTime>11/02/2022 22:02:54</publishTime>
			<publishTime>07/20/2023 09:56:54</publishTime>
			<publishTime>07/20/2023 10:38:33</publishTime>
			</File>
			<File Include="bin/Pub_Control.dll">
			<publishTime>11/09/2022 16:01:57</publishTime>
			<publishTime>11/02/2022 22:02:55</publishTime>
			<publishTime>07/20/2023 09:56:54</publishTime>
			<publishTime>07/20/2023 10:38:33</publishTime>
			</File>
			<File Include="bin/Pub_Control.pdb">
			<publishTime>11/09/2022 16:01:57</publishTime>
			<publishTime>11/02/2022 22:02:55</publishTime>
			<publishTime>07/20/2023 09:56:54</publishTime>
			<publishTime>07/20/2023 10:38:33</publishTime>
			</File>
			<File Include="bin/RestSharp.dll">
			<publishTime>08/31/2012 06:22:50</publishTime>
			</File>
			<File Include="bin/SQLHelper.dll">
			<publishTime>07/20/2023 09:56:55</publishTime>
			<publishTime>07/20/2023 10:38:34</publishTime>
			</File>
			<File Include="bin/SQLHelper.pdb">
			<publishTime>11/09/2022 16:01:57</publishTime>
			<publishTime>11/02/2022 22:02:55</publishTime>
			<publishTime>07/20/2023 09:56:55</publishTime>
			<publishTime>07/20/2023 10:38:34</publishTime>
			</File>
			<File Include="bin/stdole.dll">
			<publishTime>05/09/2021 13:35:37</publishTime>
			@@ -286,7 +286,7 @@
			<File Include="bin/WebAPI.dll">
			<publishTime>11/14/2022 11:23:59</publishTime>
			<publishTime>11/02/2022 22:03:04</publishTime>
			<publishTime>07/20/2023 09:57:06</publishTime>
			<publishTime>07/20/2023 10:38:44</publishTime>
			</File>
			<File Include="bin/WebAPI.dll.config">
			<publishTime>12/15/2021 17:59:43</publishTime>
			@@ -294,7 +294,7 @@
			<File Include="bin/WebAPI.pdb">
			<publishTime>11/14/2022 11:23:59</publishTime>
			<publishTime>11/02/2022 22:03:04</publishTime>
			<publishTime>07/20/2023 09:57:06</publishTime>
			<publishTime>07/20/2023 10:38:44</publishTime>
			</File>
			<File Include="bin/WebGrease.dll">
			<publishTime>07/18/2013 01:03:52</publishTime>
			@@ -503,7 +503,7 @@
			<File Include="Web.config">
			<publishTime>11/14/2022 11:24:08</publishTime>
			<publishTime>11/02/2022 22:03:20</publishTime>
			<publishTime>07/20/2023 09:57:09</publishTime>
			<publishTime>07/20/2023 10:38:48</publishTime>
			</File>
			</ItemGroup>
			</Project>