优化

王 垚

2022-01-06 465528ae38bf7a0be016f65af9c55bb0e84821d4

 WebAPI/Controllers/POInStockController.cs

@@ -289,7 +289,9 @@
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();
            string msg3 = sArray[1].ToString();

            LogService.Write("msg1:" + msg1);
            LogService.Write("msg2:" + msg2);
            LogService.Write("msg3:" + msg3);

            string UserName = "";
            ListModels oListModels = new ListModels();
@@ -343,6 +345,7 @@
                msg3 = msg3.Replace("\n", "");  //\n
                //msg2 = msg2.Replace("'", "’");
                List<Model.ClsCg_POInStockBillSub> ls = new List<Model.ClsCg_POInStockBillSub>();

                ls = oListModels.getObjectByJson_POInStockSub(msg3);
                int i = 0;
                foreach (Model.ClsCg_POInStockBillSub oItemSub in ls)
@@ -612,7 +615,7 @@
                SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
                //采购订单 生成送货单列表
                if (!String.IsNullOrEmpty(HBillNo))
                    HInterID = GetHinterIDByBillNo(HBillNo).ToString();
                    HInterID = GetHinterIDByBillNo(HBillNo, "Aduit").ToString();
                if (HInterID == "0")
                {
                    objjson.code = "0";
@@ -790,12 +793,12 @@
        [HttpGet]
        public object GetHinterID(string HBillNo)
        {
            int HinterID = GetHinterIDByBillNo(HBillNo);
            int HinterID = GetHinterIDByBillNo(HBillNo, "Print");
            if (HinterID == 0)
            {
                objjson.code = "0";
                objjson.count = 0;
                objjson.Message = "操作失败,请先保存订单";
                objjson.Message = "操作失败,请先保存并审核订单";
                objjson.data = HinterID;
                return objjson;
            }
@@ -806,11 +809,13 @@
            return objjson;
        }

        public int GetHinterIDByBillNo(string HBillNo)
        public int GetHinterIDByBillNo(string HBillNo, string type)
        {
            SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
            int HInterID = 0;
            string sql = "select HInterID from CG_POINSTOCKBILLMAIN where HBILLNO = '" + HBillNo + "'";
            if (type == "Print")
                sql += " and HBillStatus = '2' ";//打印判断是否审核
            DataTable dt = oCn.RunProcReturn(sql, "HInterID").Tables[0];
            if (dt.Rows.Count > 0)
                HInterID = Convert.ToInt32(dt.Rows[0]["HInterID"]);
@@ -832,7 +837,7 @@
                if (objjson.code == "0")
                    return objjson;

                WebAPIController.Add_Log("送货单删除，单号：" + HBillNo, HUserName, "送货单删除");
                WebAPIController.Add_Log("送货单删除", HUserName, "送货单删除，单号：" + HBillNo);
                oCN.BeginTran();
                oBill.DeleteRelation(ref DBUtility.ClsPub.sExeReturnInfo, Convert.ToInt32(HInterID));
                oCN.RunProc("Delete From Cg_POInStockBillMain where HInterID = " + HInterID);
@@ -988,6 +993,14 @@
        public object TestSaverPOInStock([FromBody] string[] ids)
        {
            List<string> mylist = new List<string>(ids.Distinct());
            if (mylist.Count > 1)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "操作失败！请选择相同采购订单数据行下推！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            try
            {
                string HinterID = "";