Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region 公告列表删除 |
| | | [Route("GG_Notice/Get_GG_Notice_DeleteBill")] |
| | | [HttpGet] |
| | | public object Get_GG_Notice_DeleteBill(string HInterID, string user) |
| | | { |
| | | try |
| | | { |
| | | //删除权限 |
| | | //if (!DBUtility.ClsPub.Security_Log_second("", 1, true, user)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "无删除权限!"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | oCN.RunProc("delete from OA_InformBillSub where HInterID=" + HInterID); |
| | | oCN.RunProc("delete from OA_InformBillMain where HInterID=" + HInterID); |
| | | oCN.Commit();//提交事务 |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "公告数据删除成功!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "公告数据删除失败!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | } |
| | | } |
| | |
| | | if (sGnbm != "" && sGnbm != null) |
| | | { |
| | | sName = sGnbm.Substring(1, sGnbm.Length - 1); |
| | | if (sName == "权限管理-用户") |
| | | { |
| | | sName = ""; |
| | | } |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select * from Gy_Czygl where czybm='" + czybm + "'", "Gy_Czygl"); |
| | | string AuthorityID = ClsPub.isStrNull(ds.Tables[0].Rows[0]["AuthorityID"]); |
| | | ds = oCN.RunProcReturn("SELECT id hid,case when id<=" + AuthorityID.Length + " then case when SUBSTRING('" + AuthorityID + "',id,1)=1 then 1 else 0 end else 0 end 是否权限,gnms 功能说明,gnbm hgnbm FROM xt_xtgnb where useflag=1 and sjgnbm='" + sName + "' and rightflag=1 order by gnbm", "xt_xtgnb"); |