惠康供应商平台后端
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yusijie
8 天以前 6aec5afe583d05eab24ac63a65e9ae4324004d68 
 WebAPI/Controllers/MaterialHandingController.cs


@@ -35,6 +35,14 @@


                string VsWhere = sWhere;


                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();


                DataSet ds;


                if (!DBUtility.ClsPub.Security_Log("Gy_SupMaterPack_Query", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无保存权限！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //其他过滤


                //string sql = " where 1 = 1 " + sqlWhere;


                ////转换特殊字符


@@ -576,8 +584,15 @@


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




                    oCN.BeginTran();


                if (!DBUtility.ClsPub.Security_Log("Gy_SupMaterPack_Delete", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无保存权限！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                oCN.BeginTran();




                   // oCN.RunProc("delete from Gy_UserMaterRelation where HInterID = " + HItemID);


                    oCN.RunProc("delete from Gy_UserMaterRelation where HItemID='" + HItemID + "'");