1

chenhaozhe

2025-12-01 1d97bffe5449a6b3e29d619f5a45400483fb6748

 WebAPI/Controllers/BaseSet/Gy_MaterialController.cs

@@ -1808,12 +1808,12 @@
                }
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Gy_MouldFileList " + sWhere + "order by 日期 desc", "h_v_Gy_MouldFileList");
                    ds = oCN.RunProcReturn("select * from h_v_Gy_MouldFileList " + sWhere + "order by 条码编号 desc", "h_v_Gy_MouldFileList");
                }
                else
                {
                    string sql1 = "select * from h_v_Gy_MouldFileList where 1 = 1 ";
                    string sql = sql1 + sWhere + "order by 日期 desc";
                    string sql = sql1 + sWhere + "order by 条码编号 desc";
                    ds = oCN.RunProcReturn(sql, "h_v_Gy_MouldFileList");
                }

@@ -2918,8 +2918,7 @@
                }
                //=========================================================

                //主表
                oCN.RunProc("UpDate Gy_MouldFileMain set  " +
                string sql = "UpDate Gy_MouldFileMain set  " +
                " HBillNo='" + HBillNo + "'" +  //固定赋值===============
                ",HDate='" + HDate + "'" +
                ",HYear='" + HYear.ToString() + "'" +
@@ -2972,10 +2971,13 @@
                ",HMadeSupID=" + HMadeSupID +
                ",HNowWHID=" + HNowWHID +
                ",HNowSPID=" + HNowSPID +
                ",HInitLife='" + HInitLife +
                "',HNextMainDate='" + HNextMainDate +
                ",HInitLife='" + HInitLife + "'" +
                ",HNextMainDate='" + HNextMainDate +
                "',HMouldUseStatus='" + HMouldUseStatus +
                "' where HInterID=" + HInterID.ToString());
                "' where HInterID=" + HInterID.ToString();

                //主表
                oCN.RunProc(sql);

                //修改子项目代码
                //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
@@ -4900,5 +4902,26 @@
                return objJsonResult;
            }
        }


        [Route("Gy_BarCodeBillList/GetBarCodeBillPermission")]
        [HttpGet]
        public object GetBarCodeBillPermission(string user)
        {
            if (!DBUtility.ClsPub.Security_Log("Gy_BarCodeBillList_Print", 1, false, user))
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "无权限查询!";
                objJsonResult.data = 0;
                return objJsonResult;
            }
            else
            {
                objJsonResult.data = 1;
                return objJsonResult;
            }
                
        }
    }
}