委外接收的删除 判断 瑞琪的条码生成规则 新增通过删除修改的接口 工厂日历的完善

yangle

2023-08-01 de1dccd289b272a99aff32d20b57c9a7211e3bf2

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

@@ -23,6 +23,7 @@
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;
        DAL.ClsGy_SOPBill oBill = new DAL.ClsGy_SOPBill();
        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();

        public DataGridView grdMain = new System.Windows.Forms.DataGridView();

@@ -251,6 +252,20 @@
            {
                ds = oCN.RunProcReturn(sWhere, "WindowPrint");

                //客户制定
                string sErr = "";
                if (oSystemParameter.ShowBill(ref sErr))
                {
                    if (oSystemParameter.omodel.WMS_CampanyName == "乔一")
                    {
                        if (ds.Tables[0].Columns.Count > 8) {
                            LogService.CustomWriteLog("单据号:"+ ds.Tables[0].Rows[0][7].ToString(),"CS"+ DateTime.Now.ToString("yyyyMMdd"));
                        }
                    }
                  
                }
               

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
@@ -266,6 +281,38 @@
                return objJsonResult;
            }
        }

        /// <summary>
        /// å¯¹æ•°æ®åº“进行操作
        /// </summary>
        /// <param name="sWhere"></param>
        /// <returns></returns>
        [Route("Gy_SOPBillList/UpDelSQL")]
        [HttpGet]
        public object UpDelSQL(string sWhere)
        {
            try
            {
                oCN.BeginTran();
                oCN.RunProc(sWhere);
                oCN.Commit();

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
    }
}