委外加工入库 完善

杨乐

2022-01-25 56fcaa1904a933c5f27c5fce65994e8b041e2a6e

 WebAPI/Controllers/²Ö´æ¹ÜÀí/ίÍâÓÃÁÏ/WW_PPBomBillController.cs

@@ -18,14 +18,20 @@
        public DLL.ClsWW_PPBomBill BillNew0 = new DLL.ClsWW_PPBomBill();   
        public DLL.ClsWW_PPBomBill BillOld0 = new DLL.ClsWW_PPBomBill();

        #region æ¨¡å…·é‡‡è´­å…¥åº“单列表
        #region å§”外用料列表

        [Route("WW_PPBomBillController/Get_WW_PPBomBillList")]
        [HttpGet]
        public object Get_WW_PPBomBillList(string sWhere)
        public object Get_WW_PPBomBillList(string sWhere,string user)
        {
            try
            {

                if (!DBUtility.ClsPub.Security_Log("", 1, false, user))
                { 
                
                }

                ds = WW_PPBomBillList(sWhere);
                if (ds == null)
                {
@@ -56,7 +62,7 @@

        public static DataSet WW_PPBomBillList(string sWhere)
        {
            string sql1 = string.Format(@"select * from h_v_WW_PPBomBillList");
            string sql1 = string.Format(@"select * from h_v_WW_PPBomBillList where 1=1 ");
            if (sWhere == null || sWhere.Equals(""))
            {
                return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + "order by æ—¥æœŸ desc", "h_v_WW_PPBomBillList");