1

llj

4 天以前 99bcfefdb20187000fc89a8f2654745ad2f0e371

 WebAPI/Controllers/XSGL/Xs_ExceptiveCheckRequestBillController.cs

@@ -8,10 +8,12 @@
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
using WebAPI.Utility;

namespace WebAPI.Controllers
{
    //特批申请单Controller
    [Permission(HModName = "Xs_ExceptiveCheckRequestBill")]
    public class Xs_ExceptiveCheckRequestBillController : ApiController
    {
        //获取系统参数
@@ -31,20 +33,21 @@
        /// </summary>
        [Route("Xs_ExceptiveCheckRequestBill/list")]
        [HttpGet]
        [Permission(HModName = "Xs_ExceptiveCheckRequestBill", Operate = "_Query")]
        public object getXs_ExceptiveCheckRequestBill(string sWhere, string user)
        {
            try
            {
                List<object> columnNameList = new List<object>();
                //查看权限
                //if (!DBUtility.ClsPub.Security_Log("Gy_ProjectStage_Query", 1, false, user))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "无查看权限！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                if (!DBUtility.ClsPub.Security_Log("Xs_ExceptiveCheckRequestBill_Query", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无查看权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (sWhere == null || sWhere.Equals(""))
                {
@@ -86,6 +89,7 @@
        #region 特批申请单保存 新增/编辑
        [Route("Xs_ExceptiveCheckRequestBill/SaveXs_ExceptiveCheckRequestBill")]
        [HttpPost]
        [Permission(HModName = "Xs_ExceptiveCheckRequestBill", Operate = "_Edit")]
        public object SaveXs_ExceptiveCheckRequestBill([FromBody] JObject msg)
        {
            var _value = msg["msg"].ToString();
@@ -217,7 +221,15 @@

                }


                //进行 会计期间 结账 的判断和控制
                int sYear = 0;
                int sPeriod = 0;
                DateTime HDate = DateTime.Now;
                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
                {
                    objJsonResult.Message = s;
                    return objJsonResult;
                }

                //保存
                //保存完毕后处理
@@ -307,6 +319,7 @@
        /// </summary>
        [Route("Xs_ExceptiveCheckRequestBill/delete")]
        [HttpGet]
        [Permission(HModName = "Xs_ExceptiveCheckRequestBill", Operate = "_Drop")]
        public object deleteXs_ExceptiveCheckRequestBill(string HInterID, string user)
        {
            try
@@ -350,6 +363,16 @@
                    return objJsonResult;
                }

                //进行 会计期间 结账 的判断和控制
                int sYear = 0;
                int sPeriod = 0;
                DateTime HDate = DateTime.Now;
                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
                {
                    objJsonResult.Message = s;
                    return objJsonResult;
                }

                oCN.BeginTran();

                oCN.RunProc("delete from Xs_ExceptiveCheckRequestBillMain where HInterID = " + HInterID);
@@ -359,7 +382,7 @@

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.Message = "您已删除单据号为" + BillOld.omodel.HBillNo + "的特批申请单！";
                objJsonResult.data = null;
                return objJsonResult;
            }
@@ -383,6 +406,7 @@
        /// <returns></returns>
        [Route("Xs_ExceptiveCheckRequestBill/AuditXs_ExceptiveCheckRequestBill")]
        [HttpGet]
        [Permission(HModName = "Xs_ExceptiveCheckRequestBill", Operate = "_Check")]
        public object AuditXs_ExceptiveCheckRequestBill(int HInterID, int IsAudit, string CurUserName)
        {
            string ModRightNameCheck = "Xs_ExceptiveCheckRequestBill_Check";
@@ -468,6 +492,17 @@
                //进行需要进行的审核/反审核操作
                if (IsAudit == 0) //审核提交
                {
                    //进行 会计期间 结账 的判断和控制
                    string s = "";
                    int sYear = 0;
                    int sPeriod = 0;
                    DateTime HDate = DateTime.Now;
                    if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
                    {
                        objJsonResult.Message = s;
                        return objJsonResult;
                    }

                    oCN.BeginTran();

                    //检验源单是否存在
@@ -486,7 +521,7 @@
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else if (ds.Tables[0].Rows[0]["HBillStatus"].ToString() != "1")
                        else if (int.Parse(ds.Tables[0].Rows[0]["HBillStatus"].ToString()) > 1)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
@@ -509,7 +544,7 @@
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else if (ds.Tables[0].Rows[0]["HBillStatus"].ToString() != "1")
                        else if (int.Parse(ds.Tables[0].Rows[0]["HBillStatus"].ToString()) > 1)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
@@ -566,6 +601,18 @@
                }
                if (IsAudit == 1) //反审核提交
                {

                    //进行 会计期间 结账 的判断和控制
                    string s = "";
                    int sYear = 0;
                    int sPeriod = 0;
                    DateTime HDate = DateTime.Now;
                    if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
                    {
                        objJsonResult.Message = s;
                        return objJsonResult;
                    }

                    //反审核提交AbandonCheck
                    if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
                    {
@@ -622,7 +669,7 @@
                    }


                    if (oBill.omodel.HBillStatus != 1)
                    if (oBill.omodel.HBillStatus > 1)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
@@ -717,6 +764,7 @@
        /// <returns></returns>
        [Route("Xs_ExceptiveCheckRequestBill/CloseXs_ExceptiveCheckRequestBill")]
        [HttpGet]
        [Permission(HModName = "Xs_ExceptiveCheckRequestBill", Operate = "_Close")]
        public object CloseXs_ExceptiveCheckRequestBill(int HInterID, int IsAudit, string CurUserName)
        {
            string ModRightNameCheck = "Xs_ExceptiveCheckRequestBill_Close";
@@ -862,6 +910,7 @@
        /// <returns></returns>
        [Route("Xs_ExceptiveCheckRequestBill/DeleteXs_ExceptiveCheckRequestBill")]
        [HttpGet]
        [Permission(HModName = "Xs_ExceptiveCheckRequestBill", Operate = "_Delete")]
        public object DeleteXs_ExceptiveCheckRequestBill(int HInterID, int IsAudit, string CurUserName)
        {
            string ModRightNameCheck = "Xs_ExceptiveCheckRequestBill_Delete";