代码清理

啊鑫

2025-09-09 f2b71fe1d3c2b7651d525a5b5bbe66fad602ea06

 WebApi/Gs.Wom/WorkService/WorkProController.cs

@@ -13,8 +13,8 @@
using static Gs.Toolbox.UtilityHelper;


namespace Gs.Wom.WorkService
{
namespace Gs.Wom.WorkService;

    [ApiGroup(ApiGroupNames.BaseInfo)]
    public class WorkProController : IRomteService
    {
@@ -30,6 +30,7 @@
        }

        #region

        /// <summary>
        ///     读取列表，支持分页
        /// </summary>
@@ -67,8 +68,10 @@
            catch (Exception ex)
            {
                LogHelper.Debug(ToString(), "GetListPage error：" + ex.Message);
                return ReturnDto<PageList<dynamic>>.QuickReturn(default(PageList<dynamic>), ReturnCode.Exception, ex.Message);
            return ReturnDto<PageList<dynamic>>.QuickReturn(
                default(PageList<dynamic>), ReturnCode.Exception, ex.Message);
            }

            var _pglist = new PageList<dynamic>
            {
                total = 0,
@@ -90,10 +93,10 @@
                var _dy = dset.Tables[0].TableToDynamicList();
                _pglist.list = _dy;
            }

            return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
                ReturnCode.Success, "读取成功");
        }



        /// <summary>
@@ -104,13 +107,14 @@
        [RequestMethod(RequestMethods.POST)]
        public ReturnDto<int?> DeleteModel([FromBody] JArray guidList)
        {
            string[] intArray = guidList.ToObject<string[]>();
            System.Text.StringBuilder sbGuid = new StringBuilder();
            foreach (string val in intArray)
        var intArray = guidList.ToObject<string[]>();
        var sbGuid = new StringBuilder();
        foreach (var val in intArray)
            {
                if (sbGuid.Length > 0) sbGuid.Append(", ");
                sbGuid.Append(val);
            }

            var rtnInt = (int)ReturnCode.Default;
            var cont = 0;
            try
@@ -119,9 +123,10 @@
                if (cont > 0)
                    return ReturnDto<int>.QuickReturn(default(int?),
                        ReturnCode.Exception, "删除失败，该信息已被审核！");
                System.Text.StringBuilder sbSql = new StringBuilder();
            var sbSql = new StringBuilder();
                sbSql.Append("delete from WORK_PROCESS ");
                sbSql.Append(" where guid in (select line from dbo.fn_split('" + sbGuid.ToString() + "',','))");
            sbSql.Append(" where guid in (select line from dbo.fn_split('" +
                         sbGuid + "',','))");
                var rows = DbHelperSQL.ExecuteSql(sbSql.ToString());
                rtnInt = rows;
            }
@@ -132,6 +137,7 @@
                return ReturnDto<int>.QuickReturn(default(int?),
                    ReturnCode.Exception, "删除失败，" + ex.Message);
            }

            if (rtnInt > 0)
                return ReturnDto<int>.QuickReturn(default(int?), ReturnCode.Success,
                    "操作成功，共删除" + rtnInt + "条数据！");
@@ -157,17 +163,26 @@
            string isTbm = model.isTbm;
            string description = model.description;
            int? rtnInt = (int)ReturnCode.Default;
            System.Text.StringBuilder sbSql = new StringBuilder();
        var sbSql = new StringBuilder();
            if (!CheckGuid(guid))
            {
                guid= Guid.NewGuid().ToString();
                sbSql.Append("INSERT INTO [dbo].[WORK_PROCESS] ([guid] ,[processNo] ,[processName] ,[remark] ,[isBack] ,[isStatus] ,[description] ,[createBy] ,[createDate] ,[lastUpdateBy] ,[lastUpdateDate],isZsm,isTbm)");
                sbSql.Append(" values( '"+ guid + "',@processNo,@processName,@remark,@isBack,@isStatus,@description,'" + _userCode + "',getdate(),'" + _userCode + "',getdate(),@isZsm,@isTbm)");
            sbSql.Append(
                "INSERT INTO [dbo].[WORK_PROCESS] ([guid] ,[processNo] ,[processName] ,[remark] ,[isBack] ,[isStatus] ,[description] ,[createBy] ,[createDate] ,[lastUpdateBy] ,[lastUpdateDate],isZsm,isTbm)");
            sbSql.Append(" values( '" + guid +
                         "',@processNo,@processName,@remark,@isBack,@isStatus,@description,'" +
                         _userCode + "',getdate(),'" + _userCode +
                         "',getdate(),@isZsm,@isTbm)");
            }
            else
            {
                sbSql.Append("UPDATE [dbo].[WORK_PROCESS]  SET [processNo] =@processNo,[processName] =@processName,[remark] =@remark,[isBack] =@isBack,[isStatus] =@isStatus,[description] =@description,[lastUpdateBy] ='" + _userCode + "',[lastUpdateDate] =getdate(),isZsm=@isZsm,isTbm=@isTbm where guid='" + guid.ToString()+"'");
            sbSql.Append(
                "UPDATE [dbo].[WORK_PROCESS]  SET [processNo] =@processNo,[processName] =@processName,[remark] =@remark,[isBack] =@isBack,[isStatus] =@isStatus,[description] =@description,[lastUpdateBy] ='" +
                _userCode +
                "',[lastUpdateDate] =getdate(),isZsm=@isZsm,isTbm=@isTbm where guid='" +
                guid + "'");
            }

            SqlParameter[] parameters =
                   {
                        new("@processNo", processNo),
@@ -177,7 +192,7 @@
                        new("@isStatus", isStatus),
                        new("@description", description),
                        new("@isZsm", isZsm),
                        new("@isTbm", isTbm),
            new("@isTbm", isTbm)
                    };
            try
            {
@@ -187,12 +202,15 @@
            {
                LogHelper.Debug(ToString(), "EditModel error：" + ex.Message);
                rtnInt = (int)ReturnCode.Exception;
                return ReturnDto<string>.QuickReturn("", ReturnCode.Exception, ex.Message);
            return ReturnDto<string>.QuickReturn("", ReturnCode.Exception,
                ex.Message);
            }

            if (rtnInt > 0)
                return ReturnDto<string>.QuickReturn(guid, ReturnCode.Success, "操作成功！");
            return ReturnDto<string>.QuickReturn("", ReturnCode.Exception, "增加失败，请重试！");
            return ReturnDto<string>.QuickReturn(guid, ReturnCode.Success,
                "操作成功！");
        return ReturnDto<string>.QuickReturn("", ReturnCode.Exception,
            "增加失败，请重试！");
        }

        /// <summary>
@@ -220,6 +238,7 @@
                    return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success,
                        "读取成功！");
                }

                return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default,
                    "读取失败！");
            }
@@ -240,6 +259,6 @@
            //    .ToString());
            return cont;
        }

        #endregion
    }
}