单品过站优化

wtt

2025-11-07 ed879c727d188cfe3e4ee2e5d18a4065f652d457

 WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_MatePriceController.cs

@@ -37,8 +37,7 @@
                    return objJsonResult;
                }
                string sql1 = string.Format(@"select * from h_v_Gy_MaterPrice where 1 = 1 ");

                string sql = sql1 + sWhere;
                string sql = sql1 + sWhere+ "order by åˆ›å»ºæ—¶é—´ DESC ";
                ds = oCN.RunProcReturn(sql, "h_v_Gy_MaterPrice");

                //添加列名
@@ -76,7 +75,7 @@
            {
                List<object> columnNameList = new List<object>();
                //编辑权限
                if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePrice_Query", 1, false, user))
                if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePrice_Edit", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
@@ -209,6 +208,8 @@
                if (oBill.oModel.HItemID == 0)
                {
                    bResult = oBill.AddNew();
                    DataSet Maxds = oCN.RunProcReturn("select MAX(HItemID) from Gy_MaterPrice" , "Gy_MaterPrice");
                    oBill.oModel.HItemID = Convert.ToInt64(Maxds.Tables[0].Rows[0][0]);
                }
                else
                {
@@ -229,7 +230,7 @@
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "保存成功！";
                    objJsonResult.data = 1;
                    objJsonResult.data = oBill.oModel.HItemID;
                    return objJsonResult;
                }
                else
@@ -325,6 +326,10 @@
        [HttpGet]
        public object MatePriceCheck(int HInterID, int IsAudit, string CurUserName)
        {
            Int64 lngBillKey = 0;
            lngBillKey = DBUtility.ClsPub.isLong(HInterID);
            DAL.ClsGy_MatePrice_Ctl oBill = new DAL.ClsGy_MatePrice_Ctl();
            List<Model.ClsGy_MatePrice_Model> lsmain = new List<Model.ClsGy_MatePrice_Model>();
            try
            {
                //审核权限
@@ -336,6 +341,42 @@
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if(lngBillKey==0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                ////针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作
                //if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))                    //根据HInterID获取该单据的数据
                //{
                //    if (oBill.oModel.HCheckEmp.Trim() != "")
                //    {
                //        objJsonResult.code = "0";
                //        objJsonResult.count = 0;
                //        objJsonResult.Message = "单据已关闭!不能再次审核！";
                //        objJsonResult.data = null;
                //        return objJsonResult;
                //    }
                //    //if (oBill.omodel.HDeleteMan.Trim() != "")
                //    //{
                //    //    objJsonResult.code = "0";
                //    //    objJsonResult.count = 0;
                //    //    objJsonResult.Message = "单据已作废!不能再次审核！";
                //    //    objJsonResult.data = null;
                //    //    return objJsonResult;
                //    //}
                //}
                //else
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}

                var ds = oCN.RunProcReturn("select * from Gy_MaterPrice where HItemID=" + HInterID, "Gy_MaterPrice");
                if (ds.Tables[0].Rows.Count > 0)
@@ -703,7 +744,7 @@
            }
        }
        #endregion

        

    }
}