1
llj
2 天以前 445f0928ea74a18e72e65a520c0023508e14e936
WebAPI/Controllers/WebAPIController.cs
@@ -21,6 +21,7 @@
using WebAPI.Service;
using SyntacticSugar.constant;
using System.Text.RegularExpressions;
using WebAPI.Utility;
namespace WebAPI.Controllers
{
@@ -381,6 +382,16 @@
                        objjson.code = "0";
                        objjson.count = 0;
                        objjson.Message = "用户" + UserName + "没有该组织权限";
                        objjson.data = null;
                        return objjson;
                    }
                }else if (HOrgName == "华迅特种陶瓷")
                {
                    if (DateTime.Now >= new DateTime(2026, 7, 15))
                    {
                        objjson.code = "0";
                        objjson.count = 0;
                        objjson.Message = "该用户的许可到期,请与管理员联系";
                        objjson.data = null;
                        return objjson;
                    }
@@ -1701,6 +1712,7 @@
        /// <returns></returns>
        [Route("Web/GetGy_ErrMsgBackTypeList_Json")]
        [HttpGet]
        [Permission(HModName = "Gy_ErrMsgBackType_Query")]
        public object GetGy_ErrMsgBackTypeList_Json(string ErrMsg)
        {
            sWhere = " 禁用标志 ='否'";
@@ -3479,6 +3491,7 @@
        /// <returns></returns>
        [Route("SaveGy_BadType")]
        [HttpPost]
        [Permission(HModName = "Gy_BadType", Operate = "_Edit")]
        public object SaveGy_BadType([FromBody] JObject msg)
        {
            DataSet ds;
@@ -3698,6 +3711,7 @@
        /// <returns></returns>
        [Route("GetGy_BadTypeDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_BadType", Operate = "_Query")]
        public ApiResult<DataSet> GetGy_BadTypeDetail(string HID)
        {
            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_gy_BadTypeList  where HItemID= " + HID + " ", "h_v_gy_BadTypeList");
@@ -3712,6 +3726,8 @@
        /// <returns></returns>
        [Route("DeltetGy_BadType")]
        [HttpGet]
        [Permission(HModName = "Gy_BadType", Operate = "_Drop")]
        public object DeltetGy_BadType(string HItemID, string user)
        {
            DataSet ds;
@@ -4150,6 +4166,7 @@
        /// <returns></returns>
        [Route("SaveGy_ErrType")]
        [HttpPost]
        [Permission(HModName = "Gy_ErrType", Operate = "_Edit")]
        public object SaveGy_ErrType([FromBody] JObject msg)
        {
            DataSet ds;
@@ -4363,6 +4380,7 @@
        /// <returns></returns>
        [Route("GetGy_ErrTypeDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_ErrType", Operate = "_Query")]
        public ApiResult<DataSet> GetGy_ErrTypeDetail(string HID)
        {
            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_ErrTypeList  where HItemID= " + HID + " ", "h_v_Gy_ErrTypeList");
@@ -4378,6 +4396,7 @@
        /// <returns></returns>
        [Route("DeltetGy_ErrType")]
        [HttpGet]
        [Permission(HModName = "Gy_ErrType", Operate = "_Drop")]
        public object DeltetGy_ErrType(string HItemID, string user)
        {
            DataSet ds;
@@ -4436,6 +4455,7 @@
        #region 异常类型审核/反审核
        [Route("Gy_ErrType/AuditGy_ErrType")]
        [HttpGet]
        [Permission(HModName = "Gy_ErrType", Operate = "_Check")]
        public object AuditGy_ErrType(string HInterID, int Type, string user)
        {
            try
@@ -4802,6 +4822,7 @@
        /// <returns></returns>
        [Route("SaveGy_BadResultList")]
        [HttpPost]
        [Permission(HModName = "Gy_BadResult", Operate = "_Edit")]
        public object SaveGy_BadResultList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -5023,6 +5044,8 @@
        /// <returns></returns>
        [Route("GetGy_BadResultDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_BadResult", Operate = "_Query")]
        public ApiResult<DataSet> GetGy_BadResultDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_BadResultBillDetail(HID);
@@ -5035,6 +5058,8 @@
        /// <returns></returns>
        [Route("DeltetGy_BadResult")]
        [HttpGet]
        [Permission(HModName = "Gy_BadResult", Operate = "_Drop")]
        public object DeltetGy_BadResult(string HItemID, string user)
        {
            DataSet ds;
@@ -5437,6 +5462,7 @@
        /// <returns></returns>
        [Route("SaveGy_InspectValueList")]
        [HttpPost]
        [Permission(HModName = "Gy_InspectValue", Operate = "_Edit")]
        public object SaveGy_InspectValueList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -5647,6 +5673,7 @@
        /// <returns></returns>
        [Route("GetGy_InspectValueDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_InspectValue", Operate = "_Query")]
        public ApiResult<DataSet> GetGy_InspectValueDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_InspectValueBillDetail(HID);
@@ -5659,6 +5686,7 @@
        /// <returns></returns>
        [Route("DeltetGy_InspectValue")]
        [HttpGet]
        [Permission(HModName = "Gy_InspectValue", Operate = "_Drop")]
        public object DeltetGy_InspectValue(string HItemID, string user)
        {
            DataSet ds;
@@ -5988,6 +6016,7 @@
        /// <returns></returns>
        [Route("SaveGy_InspectMethodList")]
        [HttpPost]
        [Permission(HModName = "Gy_InspectMethod", Operate = "_Edit")]
        public object SaveGy_InspectMethodList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -6197,6 +6226,7 @@
        /// <returns></returns>
        [Route("GetGy_InspectMethodDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_InspectMethod", Operate = "_Query")]
        public ApiResult<DataSet> GetGy_InspectMethodDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_InspectMethodBillDetail(HID);
@@ -6209,6 +6239,7 @@
        /// <returns></returns>
        [Route("DeltetGy_InspectMethod")]
        [HttpGet]
        [Permission(HModName = "Gy_InspectMethod", Operate = "_Drop")]
        public object DeltetGy_InspectMethod(string HItemID, string user)
        {
            DataSet ds;
@@ -6289,6 +6320,7 @@
        /// <returns></returns>
        [Route("SaveGy_QualityStdList")]
        [HttpPost]
        [Permission(HModName = "Gy_QualityStd", Operate = "_Edit")]
        public object SaveGy_QualityStdList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -6502,6 +6534,7 @@
        /// <returns></returns>
        [Route("GetGy_QualityStdDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_QualityStd", Operate = "_Query")]
        public ApiResult<DataSet> GetGy_QualityStdDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_QualityStdBillDetail(HID);
@@ -6514,6 +6547,7 @@
        /// <returns></returns>
        [Route("DeltetGy_QualityStd")]
        [HttpGet]
        [Permission(HModName = "Gy_QualityStd", Operate = "_Drop")]
        public object DeltetGy_QualityStd(string HItemID, string user)
        {
            DataSet ds;
@@ -6594,6 +6628,7 @@
        /// <returns></returns>
        [Route("SaveGy_InspectInstruMentList")]
        [HttpPost]
        [Permission(HModName = "Gy_InspectInstruMent", Operate = "_Edit")]
        public object SaveGy_InspectInstruMentList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -6806,6 +6841,7 @@
        /// <returns></returns>
        [Route("GetGy_InspectInstruMentDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_InspectInstruMent", Operate = "_Query")]
        public ApiResult<DataSet> GetGy_InspectInstruMentDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_InspectInstruMentBillDetail(HID);
@@ -6818,6 +6854,7 @@
        /// <returns></returns>
        [Route("DeltetGy_InspectInstruMent")]
        [HttpGet]
        [Permission(HModName = "Gy_InspectInstruMent", Operate = "_Drop")]
        public object DeltetGy_InspectInstruMent(string HItemID, string user)
        {
            DataSet ds;
@@ -7128,6 +7165,7 @@
        /// <returns></returns>
        [Route("SaveGy_InspectBasisList")]
        [HttpPost]
        [Permission(HModName = "Gy_InspectBasis", Operate = "_Edit")]
        public object SaveGy_InspectBasisList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -7338,6 +7376,7 @@
        /// <returns></returns>
        [Route("GetGy_InspectBasisDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_InspectBasis", Operate = "_Query")]
        public ApiResult<DataSet> GetGy_InspectBasisDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_InspectBasisBillDetail(HID);
@@ -7350,6 +7389,7 @@
        /// <returns></returns>
        [Route("DeltetGy_InspectBasis")]
        [HttpGet]
        [Permission(HModName = "Gy_InspectBasis", Operate = "_Drop")]
        public object DeltetGy_InspectBasis(string HItemID, string user)
        {
            DataSet ds;
@@ -7430,6 +7470,7 @@
        /// <returns></returns>
        [Route("SaveGy_PostSkillList")]
        [HttpPost]
        [Permission(HModName = "Gy_PostSkill_Edit")]
        public object SaveGy_PostSkillList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -7643,6 +7684,7 @@
        /// <returns></returns>
        [Route("GetGy_PostSkillDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_PostSkill_Query")]
        public ApiResult<DataSet> GetGy_PostSkillDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_PostSkillDetail(HID);
@@ -7655,6 +7697,7 @@
        /// <returns></returns>
        [Route("DeltetGy_PostSkill")]
        [HttpGet]
        [Permission(HModName = "Gy_PostSkill_Drop")]
        public object DeltetGy_PostSkill(string HItemID, string user)
        {
            DataSet ds;
@@ -8072,6 +8115,7 @@
        /// <returns></returns>
        [Route("SaveGy_PostList")]
        [HttpPost]
        [Permission(HModName = "Gy_Post_Edit")]
        public object SaveGy_PostList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -8285,6 +8329,7 @@
        /// <returns></returns>
        [Route("GetGy_PostDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_Post_Query")]
        public ApiResult<DataSet> GetGy_PostDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_PostDetail(HID);
@@ -8297,6 +8342,7 @@
        /// <returns></returns>
        [Route("DeltetGy_Post")]
        [HttpGet]
        [Permission(HModName = "Gy_Post_Drop")]
        public object DeltetGy_Post(string HItemID, string user)
        {
            DataSet ds;
@@ -8565,6 +8611,7 @@
        #region 岗位项目 导入(保存)
        [Route("Gy_Post/Gy_Post_btnSave")]
        [HttpPost]
        [Permission(HModName = "Gy_Post_Edit")]
        public object Gy_Post_btnSave([FromBody] JObject sMainSub)
        {
            var _value = sMainSub["sMainSub"].ToString();
@@ -8685,6 +8732,7 @@
        /// <returns></returns>
        [Route("SaveGy_StockMoveStyleList")]
        [HttpPost]
        [Permission(HModName = "Gy_StockMoveStyle_Edit")]
        public object SaveGy_StockMoveStyleList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -8888,6 +8936,7 @@
        /// <returns></returns>
        [Route("GetGy_StockMoveStyleDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_StockMoveStyle_Query")]
        public ApiResult<DataSet> GetGy_StockMoveStyleDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_StockMoveStyleDetail(HID);
@@ -8900,6 +8949,7 @@
        /// <returns></returns>
        [Route("DeltetGy_StockMoveStyle")]
        [HttpGet]
        [Permission(HModName = "Gy_StockMoveStyle_Drop")]
        public object DeltetGy_StockMoveStyle(string HItemID, string user)
        {
            DataSet ds;
@@ -8965,6 +9015,7 @@
        /// <returns></returns>
        [Route("SaveGy_StockInStyleList")]
        [HttpPost]
        [Permission(HModName = "Gy_StockInStyle_Edit")]
        public object SaveGy_StockInStyleList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -9168,6 +9219,7 @@
        /// <returns></returns>
        [Route("GetGy_StockInStyleDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_StockInStyle_Query")]
        public ApiResult<DataSet> GetGy_StockInStyleDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_StockInStyleDetail(HID);
@@ -9180,6 +9232,7 @@
        /// <returns></returns>
        [Route("DeltetGy_StockInStyle")]
        [HttpGet]
        [Permission(HModName = "Gy_StockInStyle_Drop")]
        public object DeltetGy_StockInStyle(string HItemID, string user)
        {
            DataSet ds;
@@ -9245,6 +9298,7 @@
        /// <returns></returns>
        [Route("SaveGy_StockOutStyleList")]
        [HttpPost]
        [Permission(HModName = "Gy_StockOutStyle_Edit")]
        public object SaveGy_StockOutStyleList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -9448,6 +9502,7 @@
        /// <returns></returns>
        [Route("GetGy_StockOutStyleDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_StockOutStyle_Query")]
        public ApiResult<DataSet> GetGy_StockOutStyleDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_StockOutStyleDetail(HID);
@@ -9460,6 +9515,7 @@
        /// <returns></returns>
        [Route("DeltetGy_StockOutStyle")]
        [HttpGet]
        [Permission(HModName = "Gy_StockOutStyle_Drop")]
        public object DeltetGy_StockOutStyle(string HItemID, string user)
        {
            DataSet ds;
@@ -9525,6 +9581,7 @@
        /// <returns></returns>
        [Route("SaveGy_AreaSetList")]
        [HttpPost]
        [Permission(HModName = "Gy_AreaSet_Edit")]
        public object SaveGy_AreaSetList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -9728,6 +9785,7 @@
        /// <returns></returns>
        [Route("GetGy_AreaSetDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_AreaSet_Query")]
        public ApiResult<DataSet> GetGy_AreaSetDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_AreaSetDetail(HID);
@@ -9740,6 +9798,7 @@
        /// <returns></returns>
        [Route("DeltetGy_AreaSet")]
        [HttpGet]
        [Permission(HModName = "Gy_AreaSet_Drop")]
        public object DeltetGy_AreaSet(string HItemID, string user)
        {
            DataSet ds;
@@ -9805,6 +9864,7 @@
        /// <returns></returns>
        [Route("SaveGy_SellStyleList")]
        [HttpPost]
        [Permission(HModName = "Gy_SellStyle_Edit")]
        public object SaveGy_SellStyleList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -10008,6 +10068,7 @@
        /// <returns></returns>
        [Route("GetGy_SellStyleDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_SellStyle_Query")]
        public ApiResult<DataSet> GetGy_SellStyleDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_SellStyleDetail(HID);
@@ -10020,6 +10081,7 @@
        /// <returns></returns>
        [Route("DeltetGy_SellStyle")]
        [HttpGet]
        [Permission(HModName = "Gy_SellStyle_Drop")]
        public object DeltetGy_SellStyle(string HItemID, string user)
        {
            DataSet ds;
@@ -10085,6 +10147,7 @@
        /// <returns></returns>
        [Route("SaveGy_PoStockStyleList")]
        [HttpPost]
        [Permission(HModName = "Gy_PoStockStyle_Edit")]
        public object SaveGy_PoStockStyleList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -10288,6 +10351,7 @@
        /// <returns></returns>
        [Route("GetGy_PoStockStyleDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_PoStockStyle_Query")]
        public ApiResult<DataSet> GetGy_PoStockStyleDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_PoStockStyleDetail(HID);
@@ -10300,6 +10364,7 @@
        /// <returns></returns>
        [Route("DeltetGy_PoStockStyle")]
        [HttpGet]
        [Permission(HModName = "Gy_PoStockStyle_Drop")]
        public object DeltetGy_PoStockStyle(string HItemID, string user)
        {
            DataSet ds;
@@ -10365,6 +10430,7 @@
        /// <returns></returns>
        [Route("SaveGy_SupTypeList")]
        [HttpPost]
        [Permission(HModName = "Gy_SupType_Edit")]
        public object SaveGy_SupTypeList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -10568,6 +10634,7 @@
        /// <returns></returns>
        [Route("GetGy_SupTypeDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_SupType_Query")]
        public ApiResult<DataSet> GetGy_SupTypeDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_SupTypeDetail(HID);
@@ -10580,6 +10647,7 @@
        /// <returns></returns>
        [Route("DeltetGy_SupType")]
        [HttpGet]
        [Permission(HModName = "Gy_SupType_Drop")]
        public object DeltetGy_SupType(string HItemID, string user)
        {
            DataSet ds;
@@ -10796,6 +10864,7 @@
        #region 供应商分类项目 导入(保存)
        [Route("Gy_SupType/Gy_SupType_btnSave")]
        [HttpPost]
        [Permission(HModName = "Gy_SupType_Edit")]
        public object Gy_SupType_btnSave([FromBody] JObject sMainSub)
        {
            var _value = sMainSub["sMainSub"].ToString();
@@ -11247,6 +11316,7 @@
        /// <returns></returns>
        [Route("SaveGy_CusTypeList")]
        [HttpPost]
        [Permission(HModName = "Gy_CusType_Edit")]
        public object SaveGy_CusTypeList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -11450,6 +11520,7 @@
        /// <returns></returns>
        [Route("GetGy_CusTypeDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_CusType_Query")]
        public ApiResult<DataSet> GetGy_CusTypeDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_CusTypeDetail(HID);
@@ -11462,6 +11533,7 @@
        /// <returns></returns>
        [Route("DeltetGy_CusType")]
        [HttpGet]
        [Permission(HModName = "Gy_CusType_Drop")]
        public object DeltetGy_CusType(string HItemID, string user)
        {
            DataSet ds;
@@ -11679,6 +11751,7 @@
        #region 客户分类项目 导入(保存)
        [Route("Gy_CusType/Gy_CusType_btnSave")]
        [HttpPost]
        [Permission(HModName = "Gy_CusType_Edit")]
        public object Gy_CusType_btnSave([FromBody] JObject sMainSub)
        {
            var _value = sMainSub["sMainSub"].ToString();
@@ -11799,6 +11872,7 @@
        /// <returns></returns>
        [Route("SaveGy_StockCheckItemList")]
        [HttpPost]
        [Permission(HModName = "Gy_StockCheckItem_Edit")]
        public object SaveGy_StockCheckItemList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -12002,6 +12076,7 @@
        /// <returns></returns>
        [Route("GetGy_StockCheckItemDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_StockCheckItem_Query")]
        public ApiResult<DataSet> GetGy_StockCheckItemDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_StockCheckItemDetail(HID);
@@ -12014,6 +12089,7 @@
        /// <returns></returns>
        [Route("DeltetGy_StockCheckItem")]
        [HttpGet]
        [Permission(HModName = "Gy_StockCheckItem_Drop")]
        public object DeltetGy_StockCheckItem(string HItemID, string user)
        {
            DataSet ds;
@@ -12079,6 +12155,7 @@
        /// <returns></returns>
        [Route("SaveGy_ProjectMoneyList")]
        [HttpPost]
        [Permission(HModName = "Gy_ProjectMoney_Edit")]
        public object SaveGy_ProjectMoneyList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -12281,6 +12358,8 @@
        /// <returns></returns>
        [Route("GetGy_ProjectMoneyDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_ProjectMoney_Query")]
        public ApiResult<DataSet> GetGy_ProjectMoneyDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_ProjectMoneyDetail(HID);
@@ -12293,6 +12372,7 @@
        /// <returns></returns>
        [Route("DeltetGy_ProjectMoney")]
        [HttpGet]
        [Permission(HModName = "Gy_ProjectMoney_Drop")]
        public object DeltetGy_ProjectMoney(string HItemID, string user)
        {
            DataSet ds;
@@ -12782,6 +12862,7 @@
        /// <returns></returns>
        [Route("SaveGy_ErrMsgBackType")]
        [HttpPost]
        [Permission(HModName = "Gy_ErrMsgBackType_Edit")]
        public object SaveGy_ErrMsgBackType([FromBody] JObject msg)
        {
            DataSet ds;
@@ -12987,6 +13068,7 @@
        /// <returns></returns>
        [Route("GetGy_ErrMsgBackTypeDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_ErrMsgBackType_Query")]
        public ApiResult<DataSet> GetGy_ErrMsgBackTypeDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_ErrMsgBackTypeDetail(HID);
@@ -12999,6 +13081,7 @@
        /// <returns></returns>
        [Route("DeltetGy_ErrMsgBackType")]
        [HttpGet]
        [Permission(HModName = "Gy_ErrMsgBackType_Drop")]
        public object DeltetGy_ErrMsgBackType(string HItemID, string user)
        {
            DataSet ds;
@@ -13386,6 +13469,7 @@
        /// <returns></returns>
        [Route("SaveGy_BadPhenomenaList")]
        [HttpPost]
        [Permission(HModName = "Gy_BadPhenomena_Edit")]
        public object SaveGy_BadPhenomenaList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -13609,6 +13693,7 @@
        /// <returns></returns>
        [Route("GetGy_BadPhenomenaDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_BadPhenomena_Query")]
        public ApiResult<DataSet> GetGy_BadPhenomenaDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_BadPhenomenaDetail(HID);
@@ -13621,6 +13706,7 @@
        /// <returns></returns>
        [Route("DeltetGy_BadPhenomena")]
        [HttpGet]
        [Permission(HModName = "Gy_BadPhenomena_Drop")]
        public object DeltetGy_BadPhenomena(string HItemID, string user)
        {
            DataSet ds;
@@ -13908,6 +13994,7 @@
        #region 不良现象项目 导入(保存)
        [Route("Gy_BadPhenomena/Gy_BadPhenomena_btnSave")]
        [HttpPost]
        [Permission(HModName = "Gy_BadPhenomena_Edit")]
        public object Gy_BadPhenomena_btnSave([FromBody] JObject sMainSub)
        {
            var _value = sMainSub["sMainSub"].ToString();
@@ -14030,6 +14117,7 @@
        /// <returns></returns>
        [Route("SaveGy_ProjectClassList")]
        [HttpPost]
        [Permission(HModName = "Gy_ProjectClass_Edit")]
        public object SaveGy_ProjectClassList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -14234,6 +14322,7 @@
        /// <returns></returns>
        [Route("GetGy_ProjectClassDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_ProjectClass_Query")]
        public ApiResult<DataSet> GetGy_ProjectClassDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_ProjectClassDetail(HID);
@@ -14246,6 +14335,7 @@
        /// <returns></returns>
        [Route("DeltetGy_ProjectClass")]
        [HttpGet]
        [Permission(HModName = "Gy_ProjectClass_Drop")]
        public object DeltetGy_ProjectClass(string HItemID, string user)
        {
            DataSet ds;
@@ -14331,6 +14421,7 @@
        /// <returns></returns>
        [Route("SaveGy_TaskClassList")]
        [HttpPost]
        [Permission(HModName = "Gy_TaskClass_Edit")]
        public object SaveGy_TaskClassList([FromBody] JObject msg)
        {
            DataSet ds;
@@ -14535,6 +14626,7 @@
        /// <returns></returns>
        [Route("GetGy_TaskClassDetail")]
        [HttpGet]
        [Permission(HModName = "Gy_TaskClass_Query")]
        public ApiResult<DataSet> GetGy_TaskClassDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_TaskClassDetail(HID);
@@ -14547,6 +14639,7 @@
        /// <returns></returns>
        [Route("DeltetGy_TaskClass")]
        [HttpGet]
        [Permission(HModName = "Gy_TaskClass_Drop")]
        public object DeltetGy_TaskClass(string HItemID, string user)
        {
            DataSet ds;
@@ -18734,6 +18827,7 @@
        /// <returns></returns>
        [Route("Xt_User/Gy_UserByUserListDrop")]
        [HttpGet]
        [Permission(HModName = "Gy_UserByUser_Drop")]
        public object DeltetGy_Material(string HItemID, string user)
        {
            DataSet ds;
@@ -18823,6 +18917,8 @@
        /// <returns></returns>
        [Route("Gy_UserByUserEdit")]
        [HttpGet]
        [Permission(HModName = "Gy_UserByUser_Query")]
        public ApiResult<DataSet> Gy_UserByUserEdit(string HID)
        {
            var model = LuBaoSevice.Gy_UserByUserEdit(HID);
@@ -19351,6 +19447,7 @@
        /// <returns></returns>
        [Route("Web/GetClassTimePrjGroupBillEdit_Json")]
        [HttpGet]
        public object GetClassTimePrjGroupBillEdit_Json(string sWhere)
        {
            //if (!DBUtility.ClsPub.Security_Log("Gy_ClassTimePrj", 1, false, user))
@@ -19444,6 +19541,7 @@
        /// <returns></returns>
        [Route("Web/SaveGetClassTimePrjGroupList")]
        [HttpGet]
        [Permission(HModName = "Gy_ClassTimePrj")]
        public object SaveGetClassTimePrjGroupList(string HNumber, string HName, string HDeptID, string refSav, string user, string HItem)
        {
@@ -24127,7 +24225,12 @@
            string suffix = ".txt";
            string folder = "ptTemplate";
            // 匹配 {{ 字段名 }} 所需正则表达式 支持中文
            var regex = new Regex(@"{{\s*([\u4e00-\u9fa5a-zA-Z0-9_\s]+?)\s*}}", RegexOptions.Compiled);
            var regex = new Regex(@"{{\s*([\u4e00-\u9fa5a-zA-Z0-9_\s]+?)\s*}}", RegexOptions.Singleline);
            // 匹配 矩形框 位置 宽高 所需正则表达式
            var RectRegex = new Regex(@"^\^FO(\d+),(\d+)\^GB(\d+),(\d+)", RegexOptions.Singleline);
            // 匹配 模板字符串 所在行 位置 宽高 所需正则表达式 支持中文
            var fieldRegex = new Regex(@"\^FO(\d+),(\d+)\^A[A-Z]+,(\d+),(\d+).*?\{\{\s*([\u4e00-\u9fa5a-zA-Z0-9_\s]+?)\s*\}\}", RegexOptions.Singleline);
            if (ptMode == "ZPL")
            {
@@ -24201,6 +24304,7 @@
                        {
                            string currentLine = lines[i];
                            string preLine = "";
                            string concatStr = "";
                            if(i>0)
                            {
                                // 获取当前行的上一行,用于判断是否是矩形框
@@ -24213,20 +24317,32 @@
                                continue;
                            }
                            // 正则表达式匹配 {{ 字段名 }} 所在行的字段,如果有,则进行替换,没有,则默认为空字符串
                            currentLine = regex.Replace(currentLine, match =>
                            // 判断矩形框,如果前一行是矩形框,则需判断该行字符串长度是否超长
                            if(!getConcatStr(rectRegex: RectRegex, fieldRegex: fieldRegex,
                                PreLine: preLine, CurrLine: currentLine, fieldObject: item,
                                templateRegex: regex,
                                ref concatStr))
                            {
                                string fieldName = match.Groups[1].Value.Trim();
                                if (msg != null && item.ContainsKey(fieldName))
                                // 正则表达式匹配 {{ 字段名 }} 所在行的字段,如果有,则进行替换,没有,则默认为空字符串
                                concatStr = regex.Replace(currentLine, match =>
                                {
                                    return item[fieldName]?.ToString() ?? "";
                                }
                                return "";
                            });
                            // 将所有 \n 的换行符 替换为 \r\n
                                    string fieldName = match.Groups[1].Value.Trim();
                                    if (msg != null && item.ContainsKey(fieldName))
                                    {
                                        return item[fieldName]?.ToString() ?? "";
                                    }
                                    return "";
                                });
                            }
                            sb.Append(currentLine);
                            if(string.IsNullOrWhiteSpace(concatStr))
                            {
                                concatStr = currentLine;
                            }
                            // 将所有 \n 的换行符 替换为 \r\n
                            sb.Append(concatStr);
                            sb.Append("\r\n"); // 标准换行
                        }
                    }
@@ -24245,12 +24361,113 @@
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = $"模板渲染失败:{ex.Message}";
                objJsonResult.Message = $"模板渲染失败:{ex}";
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        private bool getConcatStr(Regex rectRegex, Regex fieldRegex,
            string PreLine, string CurrLine, JObject fieldObject, Regex templateRegex, ref string concatStr)
        {
            var rectRegexResult = rectRegex.Match(PreLine);
            var fieldRegexResult = fieldRegex.Match(CurrLine);
            var templateRegexResult = templateRegex.Match(CurrLine);
            if (!rectRegexResult.Success)
            {
                return false;
            }
            if(!fieldRegexResult.Success)
            {
                return false;
            }
            if(!templateRegexResult.Success)
            {
                return false;
            }
            // 矩形 位置 宽高
            int rectLocationX = int.Parse(rectRegexResult.Groups[1].Value);
            int rectLocationY = int.Parse(rectRegexResult.Groups[2].Value);
            int rectWidth = int.Parse(rectRegexResult.Groups[3].Value);
            int rectHeight = int.Parse(rectRegexResult.Groups[4].Value);
            // 模板字符串 位置 字符宽高
            int fieldLocationX = int.Parse(fieldRegexResult.Groups[1].Value);
            int fieldLocationY = int.Parse(fieldRegexResult.Groups[2].Value);
            int fieldWidth = int.Parse(fieldRegexResult.Groups[3].Value);
            int fieldHeight = int.Parse(fieldRegexResult.Groups[4].Value);
            var fieldName = fieldRegexResult.Groups[5].Value;
            JToken fieldValueToken = "";
            fieldObject.TryGetValue(fieldName, out fieldValueToken);
            if (string.IsNullOrWhiteSpace(fieldValueToken?.ToString()))
            {
                return false;
            }
            string fieldValue = fieldValueToken.ToString();
            if (fieldValue.Length * fieldWidth > rectWidth)
            {
                // 字符串长度大于矩形的最大长度 则文本需要从矩形的Y位置开始渲染
                fieldLocationY = rectLocationY;
                // 获取换行所需的行数
                int lineCount = int.Parse(Math.Ceiling((float)fieldValue.Length / fieldWidth).ToString());
                // 计算换行后的最大行数 * 字符高度 是否大于矩形最大高度
                if(lineCount * fieldHeight > rectHeight)
                {
                    fieldHeight = int.Parse(Math.Floor((float)rectHeight / lineCount).ToString());
                    fieldWidth = fieldHeight;
                }
                // 计算每行应该放多少字符
                int maxCharsPerLine = (int)Math.Ceiling((double)fieldValue.Length / lineCount);
                for (int i = 0; i < lineCount; i++)
                {
                    // 起始位置
                    int start = i * maxCharsPerLine;
                    // 剩余多少字符
                    int remaining = fieldValue.Length - start;
                    if (remaining <= 0)
                        break;
                    // 本次取几个字符
                    int take = Math.Min(maxCharsPerLine, remaining);
                    // 截取当前行文本
                    string lineText = fieldValue.Substring(start, take);
                    // 计算新行坐标
                    int newY = fieldLocationY + i * fieldHeight;
                    // 替换拼接
                    concatStr += fieldRegex.Replace(CurrLine, m =>
                        $"^FO{fieldLocationX},{newY}^AJN,{fieldWidth},{fieldHeight}^CI28^FD{lineText}^FS"
                    );
                }
                return true;
            }
            return false;
        }
        #endregion
        #region APP根据设备id进行自动登录
        [HttpGet]
        [Route("Web/getSysParameter")]
        public object getSysParameter(string HClientID)
@@ -24294,6 +24511,155 @@
                return objJsonResult;
            }
        }
        #endregion
        #region 根据表名获取sql语句
        [HttpGet]
        [Route("Web/getSQL")]
        public object getSQL(string TableName, string ModeName, string OpertionType, string Identityid)
        {
            if (OpertionType == "insert")
            {
                string sql = $"select * from {TableName}";
                DataSet ds = oCN.RunProcReturn(sql, TableName);
                if (ds == null || ds.Tables[0].Rows.Count <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "系统参数不存在,请联系管理";
                    objJsonResult.data = 0;
                    return objJsonResult;
                }
                sql = $"exec h_p_sqlhelper '{TableName}'";
                ds = oCN.RunProcReturn(sql, "h_p_sqlhelper");
                if (ds == null || ds.Tables.Count < 2 || ds.Tables[1].Rows.Count <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "系统参数不存在,请联系管理";
                    objJsonResult.data = 0;
                    return objJsonResult;
                }
                StringBuilder sb = new StringBuilder();
                string columnsStr = ds.Tables[0].Rows[0][0].ToString();
                sb.AppendLine($"string sqlRes = $\"INSERT INTO [{TableName}] ({columnsStr})");
                sb.AppendLine("                VALUES (");
                // 2. 拼接 VALUES 里面的参数
                int count = ds.Tables[1].Rows.Count;
                for (int i = 0; i < count; i++)
                {
                    string propName = ds.Tables[1].Rows[i][0].ToString();
                    string valueFormat = "";
                    if (propName == "HMakeDate" || propName == "HMakeTime")
                    {
                        valueFormat = "getdata()";
                    }
                    else if (propName == "HERPItemID")
                    {
                        valueFormat = "'{0}'";
                    }
                    else
                    {
                        valueFormat = $"'{{{ModeName}.{propName}}}'"; // 默认通用逻辑
                    }
                    sb.Append("                " + valueFormat);
                    if (i < count - 1)
                    {
                        sb.Append(",");
                    }
                    sb.AppendLine();
                }
                sb.AppendLine("                ); \";");
                sb.Append(" oCN.RunProc(sqlRes);");
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "成功";
                objJsonResult.data = sb;
                return objJsonResult;
            }
            else
            {
                string whereKey = Identityid;
                string sql = $"select * from {TableName}";
                DataSet ds = oCN.RunProcReturn(sql, TableName);
                if (ds == null || ds.Tables[0].Rows.Count <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "系统参数不存在,请联系管理";
                    objJsonResult.data = 0;
                    return objJsonResult;
                }
                sql = $"exec h_p_sqlhelper '{TableName}'";
                ds = oCN.RunProcReturn(sql, "h_p_sqlhelper");
                if (ds == null || ds.Tables.Count < 2 || ds.Tables[1].Rows.Count <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "系统参数不存在,请联系管理";
                    objJsonResult.data = 0;
                    return objJsonResult;
                }
                StringBuilder sb = new StringBuilder();
                sb.Append($"string sqlRes =$\"Update {TableName} set ");
                int count = ds.Tables[1].Rows.Count;
                int setFieldCount = 0;
                for (int i = 0; i < count; i++)
                {
                    string propName = ds.Tables[1].Rows[i][0].ToString();
                    if (propName == whereKey)
                        continue;
                    if (setFieldCount > 0)
                    {
                        sb.Append(",");
                    }
                    string valueFormat = "";
                    if (propName == "HModifyTime" || propName == "HUpDateDate")
                    {
                        valueFormat = $"{propName}=getdate()";
                    }
                    else
                    {
                        valueFormat = $"{propName}='{{{ModeName}.{propName}}}'";
                    }
                    sb.Append("\r\n                " + valueFormat);
                    setFieldCount++;
                }
                sb.Append($" where {whereKey}='{{{ModeName}.{whereKey}}}'\"");
                sb.AppendLine();
                sb.Append("oCN.RunProc(sqlRes);");
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "成功";
                objJsonResult.data = sb;
                return objJsonResult;
            }
        }
        #endregion
    }
}
#endregion