修改页码及排序

杨乐

2022-02-10 777db38816776abbe4b864d26a6c0381b75e8f9d

 WebAPI/Controllers/BaseSet/Gy_QCCheckClassController.cs

@@ -33,12 +33,12 @@
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_IF_QCCheckClassList " + sWhere, "h_v_IF_QCCheckClassList");
                    ds = oCN.RunProcReturn("select * from h_v_IF_QCCheckClassList order by 代码", "h_v_IF_QCCheckClassList");
                }
                else
                {
                    string sql1 = "select * from h_v_IF_QCCheckClassList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    string sql = sql1 + sWhere+ " order by 代码";
                    ds = oCN.RunProcReturn(sql, "h_v_IF_QCCheckClassList");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
@@ -126,7 +126,7 @@
            DAL.ClsGy_QCCheckClass_View oDeptHlp = new DAL.ClsGy_QCCheckClass_View();
            try
            {
                if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, true, User))
                if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false, User))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
@@ -244,7 +244,7 @@
                "(HNumber,HName,HHelpCode,HShortNumber,HParentID" +
                ",HLevel,HEndFlag,HStopflag,HRemark,HUseFlag) " +
                " values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "','" + HItemID + "'" +
                ",'1',0,'" + Convert.ToString(HStopflag ? 1 : 0) + "','" + HRemark + "','0')");
                ",'1',0,'" + Convert.ToString(HStopflag ? 1 : 0) + "','" + HRemark + "','未使用')");
                //修改上级为非末级代码
                if (list[0].HItemID.ToString() != "")
                {
@@ -309,7 +309,7 @@


                //判断权限
                if (!ClsPub.Security_Log(msg5, 1, true, msg4))
                if (!ClsPub.Security_Log(msg5, 1, false, msg4))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;