蓝宝PC后端
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
啊鑫
8 天以前 f2b71fe1d3c2b7651d525a5b5bbe66fad602ea06 
 WebApi/Gs.JJGZ/MesJjgzScheduleController.cs


@@ -1,7 +1,6 @@


using System.Data;


using System.Data.SqlClient;


using System.Dynamic;


using System.Text;


using Gs.Toolbox;


using Gs.Toolbox.ApiCore.Abstract.Mvc;


using Gs.Toolbox.ApiCore.Common.Mvc;


@@ -18,6 +17,7 @@


    private readonly IHttpContextAccessor _http;




    private readonly string _userCode, _userGuid, _orgFids;




    public MesJjgzScheduleController(IHttpContextAccessor httpContextAccessor)


    {


        _http = httpContextAccessor;


@@ -38,7 +38,7 @@


        int everyPageSize = model.everyPageSize;


        string sortName = model.sortName;


        string keyWhere = model.keyWhere;


        




        var _pglist = new PageList<dynamic>


        {


            total = 0,


@@ -49,27 +49,32 @@


        try


        {


            // 构建分页查询SQL


            string orderBy = string.IsNullOrEmpty(sortName) ? "CREATE_DATE DESC" : $"{sortName} ASC";


            


            var orderBy = string.IsNullOrEmpty(sortName)


                ? "CREATE_DATE DESC"


                : $"{sortName} ASC";




            // 查询总数


            string countSql = $"SELECT COUNT(1) FROM MES_JJGZ_SCHEDULES WHERE 1=1 {keyWhere}";


            var countSql =


                $"SELECT COUNT(1) FROM MES_JJGZ_SCHEDULES WHERE 1=1 {keyWhere}";


            var countResult = DbHelperSQL.GetSingle(countSql);


            int intTotal = countResult != null ? Convert.ToInt32(countResult) : 0;


            


            var intTotal =


                countResult != null ? Convert.ToInt32(countResult) : 0;




            if (intTotal > 0)


            {


                // 分页查询数据


                int offset = (currentPage - 1) * everyPageSize;


                string dataSql = $@"


                var offset = (currentPage - 1) * everyPageSize;


                var dataSql = $@"


                    SELECT * FROM (


                        SELECT ROW_NUMBER() OVER (ORDER BY {orderBy}) AS RowNum, *


                        FROM MES_JJGZ_SCHEDULES 


                        WHERE 1=1 {keyWhere}


                    ) AS T


                    WHERE T.RowNum BETWEEN {offset + 1} AND {offset + everyPageSize}";


                




                var dsMain = DbHelperSQL.Query(dataSql);


                if (dsMain != null && dsMain.Tables.Count > 0 && dsMain.Tables[0].Rows.Count > 0)


                if (dsMain != null && dsMain.Tables.Count > 0 &&


                    dsMain.Tables[0].Rows.Count > 0)


                {


                    var pages = intTotal % everyPageSize != 0


                        ? intTotal / everyPageSize + 1


@@ -86,8 +91,9 @@


        {


            LogHelper.Debug(ToString(), ex.Message);


            return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,


          ReturnCode.Exception, ex.Message);


                ReturnCode.Exception, ex.Message);


        }




        return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,


            ReturnCode.Success, "读取成功");


    }


@@ -102,12 +108,13 @@


    {


        string guid = model.guid.ToString();


        dynamic m = new ExpandoObject();


        string mainTable = "MES_JJGZ_SCHEDULES";


        var mainTable = "MES_JJGZ_SCHEDULES";


        try


        {


            string sqlMain = $"SELECT * FROM {mainTable} WHERE GUID='{guid}'";


            var sqlMain = $"SELECT * FROM {mainTable} WHERE GUID='{guid}'";


            var dsMain = DbHelperSQL.Query(sqlMain);


            if (dsMain != null && dsMain.Tables.Count > 0 && dsMain.Tables[0].Rows.Count > 0)


            if (dsMain != null && dsMain.Tables.Count > 0 &&


                dsMain.Tables[0].Rows.Count > 0)


            {


                var dr = dsMain.Tables[0].Rows[0];


                m = dr.RowToDynamic();


@@ -117,8 +124,10 @@


        {


            LogHelper.Debug(ToString(), ex.Message);


        }




        if (m != null)


            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "读取成功！");


            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success,


                "读取成功！");


        return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "读取失败！");


    }




@@ -137,8 +146,9 @@


        m.outMsg = "";


        try


        {


            string sql = $"UPDATE MES_JJGZ_SCHEDULES SET CHECK_STATUS='{_inFieldValue}',CHECK_DATE = getdate(), CHECK_USER='{_userGuid}' WHERE GUID='{_guid}'";


            int rows = DbHelperSQL.ExecuteSql(sql);


            var sql =


                $"UPDATE MES_JJGZ_SCHEDULES SET CHECK_STATUS='{_inFieldValue}',CHECK_DATE = getdate(), CHECK_USER='{_userGuid}' WHERE GUID='{_guid}'";


            var rows = DbHelperSQL.ExecuteSql(sql);


            m.outSum = rows;


            m.outMsg = rows > 0 ? "操作成功！" : "未更新任何数据";


        }


@@ -147,8 +157,10 @@


            LogHelper.Debug(ToString(), "EditModelSubmit error：" + ex.Message);


            m.outMsg = ex.Message;


            m.outSum = -1;


            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, ex.Message);


            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default,


                ex.Message);


        }




        return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "操作成功！");


    }




@@ -176,17 +188,17 @@


        mObj.outSum = -1;


        mObj.outGuid = "";


        mObj.outNo = "";


        




        using (var conn = new SqlConnection(DbHelperSQL.strConn))


        {


            try


            {


                conn.Open();


                




                if (CheckGuid(guid))


                {


                    // 编辑模式


                    string sql = $@"UPDATE MES_JJGZ_SCHEDULES SET 


                    var sql = $@"UPDATE MES_JJGZ_SCHEDULES SET 


                        OnWorkTime1='{onWorkTime1}', 


                        OffWorkTime1='{offWorkTime1}', 


                        OnWorkTime2='{onWorkTime2}', 


@@ -197,8 +209,8 @@


                        EndTime='{endTime}', 


                        Remark='{remark}' 


                        WHERE GUID='{guid}'";


                    


                    int rows = DbHelperSQL.ExecuteSql(sql);




                    var rows = DbHelperSQL.ExecuteSql(sql);


                    mObj.outSum = rows;


                    mObj.outGuid = guid.ToString();


                    mObj.outMsg = rows > 0 ? "操作成功！" : "未更新任何数据";


@@ -207,19 +219,22 @@


                {


                    // 新增模式 - 生成班次编号和GUID


                    guid = Guid.NewGuid();


                    




                    // 调用存储过程生成班次编号


                    using (var cmd = new SqlCommand("getOrderNo", conn))


                    {


                        cmd.CommandType = CommandType.StoredProcedure;


                        cmd.Parameters.Add(new SqlParameter("@wntype", "SC(班次)"));


                        cmd.Parameters.Add(new SqlParameter("@hNo", SqlDbType.NVarChar, 50) { Direction = ParameterDirection.Output });


                        


                        cmd.Parameters.Add(


                            new SqlParameter("@wntype", "SC(班次)"));


                        cmd.Parameters.Add(


                            new SqlParameter("@hNo", SqlDbType.NVarChar, 50)


                                { Direction = ParameterDirection.Output });




                        cmd.ExecuteNonQuery();


                        string scheNo = cmd.Parameters["@hNo"].Value.ToString();


                        


                        var scheNo = cmd.Parameters["@hNo"].Value.ToString();




                        // 插入数据


                        string insertSql = $@"


                        var insertSql = $@"


                            DECLARE @userBy NVARCHAR(20); 


                            SELECT TOP 1 @userBy=[ACCOUNT] FROM [dbo].[SYS_USER] WHERE guid='{_userGuid}';


                            INSERT INTO MES_JJGZ_SCHEDULES (


@@ -231,8 +246,8 @@


                                '{onWorkTime1}', '{offWorkTime1}', '{onWorkTime2}', '{offWorkTime2}', 


                                '{onWorkTime3}', '{offWorkTime3}', '{beginTime}', '{endTime}', '{remark}', 0


                            )";


                        


                        int rows = DbHelperSQL.ExecuteSql(insertSql);




                        var rows = DbHelperSQL.ExecuteSql(insertSql);


                        mObj.outSum = rows;


                        mObj.outGuid = guid.ToString();


                        mObj.outNo = scheNo;


@@ -251,10 +266,12 @@


                conn.Close();


            }


        }


        




        if (mObj.outSum <= 0)


            return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception, mObj.outMsg);


        return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success, mObj.outMsg);


            return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception,


                mObj.outMsg);


        return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success,


            mObj.outMsg);


    }




    /// <summary>


@@ -273,7 +290,7 @@


        {


            if (CheckGuid(guid))


            {


                string sql = $"DELETE FROM MES_JJGZ_SCHEDULES WHERE GUID='{guid}'";


                var sql = $"DELETE FROM MES_JJGZ_SCHEDULES WHERE GUID='{guid}'";


                _outSum = DbHelperSQL.ExecuteSql(sql);


                _outMsg = _outSum > 0 ? "删除成功！" : "未删除任何数据";


            }


@@ -289,8 +306,10 @@


            _outMsg = ex.Message;


            _outSum = -1;


        }




        if (_outSum <= 0)


            return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception, _outMsg);


            return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception,


                _outMsg);


        return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg);


    }


}