/// <summary> /// 获取我的收藏byID /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1">ID</param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETTEXT(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int DataID = 0; int.TryParse(P1, out DataID); JH_Auth_WXMSG wxmsg = new JH_Auth_WXMSGB().GetEntity(d => d.ID == DataID); msg.Result = wxmsg; }
//分享页面根据文件夹Id获取文件列表 public void GETFILELIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int FolderID = int.Parse(P1);// int ComId = int.Parse(P2); msg.Result = new FT_FolderB().GetEntities(d => d.ComId == ComId && d.PFolderID == FolderID); msg.Result1 = new FT_FileB().GetEntities(d => d.ComId == ComId && d.FolderID == FolderID); return; }
/// <summary> /// 根据ID查询工资明细 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETGZDLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int ID; JH_Auth_User userInfo = new JH_Auth_User(); int.TryParse(context.Request["ID"] ?? "-1", out ID); msg.Result = new SZHL_XZ_GZDB().GetEntities(d => d.ID == ID).ToList(); return; }
//获取接收人列表 public void GETXXFBUSERLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int id = 0; int.TryParse(P1, out id); SZHL_XXFBType xxfbType = new SZHL_XXFBTypeB().GetEntity(d => d.ID == id && d.ComId == UserInfo.User.ComId); msg.Result = new JH_Auth_UserB().GetEntities(d => xxfbType.SeeUser.Contains(d.UserName) && d.ComId == UserInfo.User.ComId); }
public void CHECKREGISTERPHONE(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { var qy2 = new JH_Auth_QYB().GetEntities(p => p.Mobile == P1.Trim()); if (qy2.Count() > 0) { msg.ErrorMsg = "此手机已注册企业,请更换手机号继续注册"; } }
public void GETMOBILEINDEX(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { string strSql = string.Format(@"SELECT top 3 item.* from SZHL_XXFB_ITEM item inner join SZHL_XXFB xxfb on item.XXFBId=xxfb.ID where item.ComId={0} and xxfb.IsSend='1' and SHStatus=2 and (','+xxfb.JSUser+',' LIKE '%,{1},%' or xxfb.JSUser='') order by xxfb.FBTime DESC", UserInfo.User.ComId, UserInfo.User.UserName); DataTable dt = new SZHL_XXFBB().GetDTByCommand(strSql); msg.Result = dt; }
/// <summary> /// 获取我所监督的自律小组列表 /// </summary> public void GETMYJIANDUGROUPTEAM(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { //我的自律小组名称 JH_Auth_User thisuser = new JH_Auth_UserB().GetEntity(d => d.ID == UserInfo.User.ID); string viewname = "select Items as XiaoZu from dbo.Split(REPLACE('" + thisuser.JianDuXiaoZu + "',' ',''),';') "; DataTable dt = new JH_Auth_UserB().GetDTByCommand(viewname); msg.Result = dt; msg.Result1 = thisuser.ZiLvXiaoZu; }
/// <summary> /// 更新表单可管理字段 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void SETPDFILED(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int Id = 0; int.TryParse(P1, out Id); Yan_WF_TD TD = new Yan_WF_TDB().GetEntity(d => d.ID == Id && d.ComId == UserInfo.User.ComId); TD.WritableFields = P2; new Yan_WF_TDB().Update(TD); }
/// <summary> /// 更新归还车辆记录 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void BACKCLJL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int ID = int.Parse(P1); SZHL_YCGL ycgl = new SZHL_YCGLB().GetEntity(d => d.ID == ID && d.ComId == UserInfo.User.ComId); ycgl.Status = "0";//0 归还 1正在使用 ycgl.BackDate = DateTime.Now; new SZHL_YCGLB().Update(ycgl); msg.Result = ycgl; }
/// <summary> /// 获取投票人 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="strUserName"></param> public void GETTPR(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int Id = 0, opid = 0; int.TryParse(P1, out Id); int.TryParse(P2, out opid); DataTable dttpr = new SZHL_QYHD_ResultB().GetDTByCommand("SELECT CRUser FROM SZHL_QYHD_Result WHERE HDId=" + P1 + " AND OptionID=" + opid + " GROUP BY CRUser"); msg.Result = dttpr; }
/// <summary> /// 借阅管理日历视图 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETYCGLVIEW(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { string strSql = string.Format("SELECT ycgl.ID,ycgl.intProcessStanceid,ts.tsBrand+'-'+ts.tsType+'-'+ts.tsNum+' '+CONVERT(VARCHAR(5),ycgl.StartTime,8)+'~'+CONVERT(VARCHAR(5),ycgl.EndTime,8) title,ycgl.StartTime start,ycgl.EndTime [end] from SZHL_TSGL ycgl left outer join SZHL_TSGL_TS ts on ycgl.tsID=ts.ID where ( dbo.fn_PDStatus(ycgl.intProcessStanceid)='已审批' or dbo.fn_PDStatus(ycgl.intProcessStanceid)='正在审批' or dbo.fn_PDStatus(ycgl.intProcessStanceid)='-1' ) and ycgl.ComId=" + UserInfo.User.ComId + " and isnull(ts.tsType,'')!=''"); if (P1 != "0") { strSql += string.Format(" and ycgl.tsID={0} ", P1); } msg.Result = new SZHL_CCXJB().GetDTByCommand(strSql); }
public void GETWDSL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { try { msg.Result = new SZHL_TSSQB().GetDTByCommand("SELECT COUNT(*) AS SL FROM SZHL_TSSQ WHERE ','+RedUsers+',' NOT like '%," + UserInfo.User.UserName + ",%'"); } catch (Exception ex) { } }
/// <summary> /// 会议日历视图 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETHYGLVIEW(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { string strSql = string.Format("SELECT hygl.ID,hygl.intProcessStanceid,hygl.FQUser,'['+room.Name+']'+hygl.Title+' '+CONVERT(VARCHAR(5),hygl.StartTime,8)+'~'+CONVERT(VARCHAR(5),hygl.EndTime,8) title,hygl.StartTime start,hygl.EndTime [end],CASE when dbo.fn_PDStatus(hygl.intProcessStanceid)='已审批' then 1 when dbo.fn_PDStatus(hygl.intProcessStanceid)='-1' then 1 when dbo.fn_PDStatus(hygl.intProcessStanceid)='正在审批' then 0 end SHStatus from SZHL_HYGL hygl INNER join SZHL_HYGL_ROOM room on hygl.RoomID=room.ID where ( dbo.fn_PDStatus(hygl.intProcessStanceid)='已审批' or dbo.fn_PDStatus(hygl.intProcessStanceid)='正在审批' or dbo.fn_PDStatus(hygl.intProcessStanceid)='-1' ) and hygl.ComId=" + UserInfo.User.ComId); if (P1 != "0") { strSql += string.Format(" and hygl.RoomID={0} ", P1); } msg.Result = new SZHL_YCGLB().GetDTByCommand(strSql); }
//获取素材列表 public void GETSCLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { string strSql = string.Format("select * from SZHL_XXFB_SCK where CRUser='******' and ComId={1} ", UserInfo.User.UserName, UserInfo.User.ComId);//and Type={1} msg.Result = new SZHL_XXFB_SCKB().GetDTByCommand(strSql + " and Type=0"); string strSql2 = string.Format("SELECT sck.*,files.name,files.FileExtendName,files.FileMD5 from SZHL_XXFB_SCK sck inner join FT_File files on sck.Files=files.Id where sck.CRUser='******' and sck.ComId={1} ", UserInfo.User.UserName, UserInfo.User.ComId);//and Type={1} msg.Result1 = new SZHL_XXFB_SCKB().GetDTByCommand(strSql2 + " and Type=1"); msg.Result2 = new SZHL_XXFB_SCKB().GetDTByCommand(strSql2 + " and Type=2"); }
/// <summary> /// 登录 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1">用户名</param> /// <param name="P2">密码(未解码的)</param> /// <param name="UserInfo"></param> public void LOGIN(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { string password = context.Request["password"] ?? ""; string username = context.Request["UserName"] ?? ""; string chkcode = context.Request["chkcode"] ?? ""; msg.ErrorMsg = ""; //取消验证码 Weiler //if (context.Session["chkcode"] != null) //{ // if (!chkcode.ToUpper().Equals(context.Session["chkcode"].ToString())) // { // msg.ErrorMsg = "验证码不正确"; // return; // } //} //else //{ // msg.ErrorMsg = "验证码已过期"; // return; //} JH_Auth_QY qyModel = new JH_Auth_QYB().GetALLEntities().First(); password = CommonHelp.GetMD5(password); JH_Auth_User userInfo = new JH_Auth_User(); List <JH_Auth_User> userList = new JH_Auth_UserB().GetEntities(d => (d.UserName == username || d.mobphone == username) && d.UserPass == password).ToList(); if (userList.Count() == 0) { msg.ErrorMsg = "用户名或密码不正确"; return; } else { userInfo = userList[0]; if (userInfo.IsUse != "Y") { msg.ErrorMsg = "用户被禁用,请联系管理员"; return; } if (string.IsNullOrEmpty(userInfo.pccode)) { userInfo.pccode = CommonHelp.CreatePCCode(userInfo); } userInfo.logindate = DateTime.Now; new JH_Auth_UserB().Update(userInfo); msg.Result = userInfo.pccode; msg.Result1 = userInfo.UserName; msg.Result4 = userInfo; } }
public void ADDJFBX(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { SZHL_JFBX jfbxModel = JsonConvert.DeserializeObject <SZHL_JFBX>(P1); List <SZHL_JFBXITEM> itemList = JsonConvert.DeserializeObject <List <SZHL_JFBXITEM> >(P2); if (itemList == null || itemList.Count() == 0) { msg.Result = "请添加消费记录"; return; } string wximg = context.Request["wximg"] ?? ""; if (wximg != "") // 处理微信上传的图片 { string fids = new FT_FileB().ProcessWxIMG(wximg, "JFBX", UserInfo); if (!string.IsNullOrEmpty(jfbxModel.Files)) { jfbxModel.Files += "," + fids; } else { jfbxModel.Files = fids; } } if (jfbxModel.ID == 0) { jfbxModel.CRDate = DateTime.Now; jfbxModel.CRUser = UserInfo.User.UserName; jfbxModel.ComId = UserInfo.User.ComId; jfbxModel.FormCode = new SZHL_JFBXB().GetFormCode(); jfbxModel.BranchName = UserInfo.BranchInfo.DeptName; jfbxModel.BranchNo = UserInfo.BranchInfo.DeptCode; new SZHL_JFBXB().Insert(jfbxModel); foreach (SZHL_JFBXITEM item in itemList) { item.ComID = UserInfo.User.ComId; item.JFBXID = jfbxModel.ID; new SZHL_JFBXITEMB().Insert(item); } } else { new SZHL_JFBXB().Update(jfbxModel); new SZHL_JFBXITEMB().Delete(d => d.JFBXID == jfbxModel.ID && d.ComID == UserInfo.User.ComId); foreach (SZHL_JFBXITEM item in itemList) { item.ComID = UserInfo.User.ComId; item.JFBXID = jfbxModel.ID; new SZHL_JFBXITEMB().Insert(item); } } msg.Result = jfbxModel; }
/// <summary> /// 添加外勤签到 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1">客户信息</param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void ADDWQQD(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { SZHL_WQQD wqqd = JsonConvert.DeserializeObject <SZHL_WQQD>(P1); if (string.IsNullOrEmpty(wqqd.Position)) { msg.ErrorMsg = "当前位置不能为空"; return; } if (P2 != "") // 处理微信上传的图片 { string fids = new FT_FileB().ProcessWxIMG(P2, "RLZY", UserInfo); if (!string.IsNullOrEmpty(wqqd.Files)) { wqqd.Files += "," + fids; } else { wqqd.Files = fids; } } if (wqqd.ID == 0) { wqqd.CRDate = DateTime.Now; wqqd.CRUser = UserInfo.User.UserName; wqqd.BranchName = UserInfo.BranchInfo.DeptName; wqqd.BranchNo = UserInfo.User.BranchCode; wqqd.ComId = UserInfo.User.ComId; wqqd.CRUserName = UserInfo.User.UserRealName; new SZHL_WQQDB().Insert(wqqd); if (!string.IsNullOrEmpty(wqqd.HBUser)) { SZHL_TXSX CSTX = new SZHL_TXSX(); CSTX.Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); CSTX.APIName = "WQQD"; CSTX.ComId = UserInfo.User.ComId; CSTX.FunName = "SENDWQMSG"; CSTX.CRUserRealName = UserInfo.User.UserRealName; CSTX.MsgID = wqqd.ID.ToString(); CSTX.ISCS = "N"; CSTX.TXUser = wqqd.HBUser; CSTX.TXMode = "WQQD"; CSTX.CRUser = UserInfo.User.UserName; TXSX.TXSXAPI.AddALERT(CSTX); //时间为发送时间 } } else { new SZHL_WQQDB().Update(wqqd); } msg.Result = wqqd; }
public void REGISTERYSOLD(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { JH_Auth_QY QY = new JH_Auth_QYB().GetEntity(d => d.ComId == 10334); QY.CRDate = DateTime.Now.AddYears(-2); QY.QYProfile = QY.FileServerUrl; QY.FileServerUrl = ""; QY.IsUseWX = "N"; new JH_Auth_QYB().Update(QY); msg.Result = QY; }
/// <summary> /// 验证企业名称 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void YZQYMC(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { if (!string.IsNullOrEmpty(P1)) { var qy = new JH_Auth_QYB().GetEntity(p => p.QYName == P1); if (qy != null) { msg.ErrorMsg = "企业名称已存在"; } } }
public void UPDZY(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { String zyid = context.Request("ZYID") ?? "0"; FT_File model = new FT_FileB().GetEntity(d => d.zyid == zyid && d.ComId == UserInfo.User.ComId.Value); model.Name = P1; new FT_FileB().Update(model); msg.Result = model; }
//首页获取任务数据 public void GETRWGLINDEXLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { string userName = UserInfo.User.UserName; string strWhere = string.Format(" (bg.CRUser='******' or ','+RWFZR+',' like '%,{0},%' or ','+RWCYR+',' like '%,{0},%' ) ", userName); int recordCount = 0; DataTable dtList = new SZHL_GZBGB().GetDataPager(" SZHL_RWGL bg inner join JH_Auth_ZiDian zd on LeiBie= zd.ID and Class=7 ", "bg.*,zd.TypeName ", 8, 1, "bg.CRDate desc", strWhere + " And RWStatus=0", ref recordCount); DataTable dtList1 = new SZHL_GZBGB().GetDataPager(" SZHL_RWGL bg inner join JH_Auth_ZiDian zd on LeiBie= zd.ID and Class=7 ", "bg.*,zd.TypeName ", 8, 1, "bg.CRDate desc", strWhere + " And RWStatus=1", ref recordCount); msg.Result = dtList; msg.Result1 = dtList1; }
public void SAVEDATA(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { BI_DB_YBP model = new BI_DB_YBP(); model.Name = P1; model.YBType = P2; model.CRUser = UserInfo.User.UserName; model.CRDate = DateTime.Now; new BI_DB_YBPB().Insert(model); msg.Result = model; }
/// <summary> /// 获取可用车辆 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETCLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { // string strSql = string.Format("SELECT car.* from SZHL_YCGL_CAR car LEFT JOIN SZHL_YCGL ycgl on car.ID=ycgl.CarID where car.Status=0 and (ycgl.Status=0 or ycgl.Status is NULL) and car.ComId={0}", UserInfo.User.ComId); string strSql = string.Format("SELECT car.* from SZHL_YCGL_CAR car where car.Status=0 and car.ComId={0}", UserInfo.User.ComId); //if (P1 != "") //{ // strSql += string.Format(" and ycgl.EndTime<'{0}' ", P1); //} msg.Result = new SZHL_YCGL_CARB().GetDTByCommand(strSql); }
/// <summary> /// 删除会议室 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void DELHYS(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int Id = int.Parse(P1); int ss = int.Parse(P2); SZHL_HYGL_ROOM model = new SZHL_HYGL_ROOMB().GetEntity(d => d.ID == Id && d.ComId == UserInfo.User.ComId); model.IsDel = ss; model.DelUser = UserInfo.User.UserName; model.DelDate = DateTime.Now; new SZHL_HYGL_ROOMB().Update(model); }
public void DXGL_CHECK(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { SZHL_TXSX TX = JsonConvert.DeserializeObject <SZHL_TXSX>(P1); if (!string.IsNullOrEmpty(TX.TXUser)) { // UserInfo = new JH_Auth_UserB().GetUserInfo(TX.ComId.Value,TX.CRUser); //发送微信消息 new SZHL_DXGLB().SendSMS(TX.TXUser, TX.TXContent, TX.ComId.Value); } }
/// <summary> /// 流程审批添加 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void ADDPROCESS(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { Yan_WF_PD lcsp = JsonConvert.DeserializeObject <Yan_WF_PD>(P1); if (lcsp.ProcessName.Trim() == "") { msg.ErrorMsg = "流程名称不能为空"; return; } if (lcsp.ID == 0)//如果Id为0,为添加操作 { if (new Yan_WF_PDB().GetEntities(d => d.ComId == UserInfo.User.ComId && d.ProcessName == lcsp.ProcessName).Count() > 0) { msg.ErrorMsg = "已存在此流程"; return; } lcsp.lcstatus = 1; lcsp.ComId = UserInfo.User.ComId; if (lcsp.ManageRole != null) { lcsp.ManageRole.Trim(','); } lcsp.CRDate = DateTime.Now; lcsp.CRUser = UserInfo.User.UserName; lcsp.CRUserName = UserInfo.User.UserRealName; new Yan_WF_PDB().Insert(lcsp); //添加流程表数据 } else { //修改流程表数据 new Yan_WF_PDB().Update(lcsp); } //如果流程类型为固定流程并且固定流程内容不为空,添加固定流程数据 if (lcsp.ProcessType == "1" && !string.IsNullOrEmpty(P2)) { List <Yan_WF_TD> tdList = JsonConvert.DeserializeObject <List <Yan_WF_TD> >(P2); tdList.ForEach(d => d.ProcessDefinitionID = lcsp.ID); tdList.ForEach(d => d.ComId = UserInfo.User.ComId); tdList.ForEach(d => d.CRDate = DateTime.Now); tdList.ForEach(d => d.CRUser = UserInfo.User.UserName); tdList.ForEach(d => d.TDCODE = d.ProcessDefinitionID + "-" + d.Taskorder); tdList.ForEach(d => d.AssignedRole = d.AssignedRole.Trim(',')); new Yan_WF_TDB().Delete(d => d.ProcessDefinitionID == tdList[0].ProcessDefinitionID); List <string> ExtendModes = new List <string>(); ExtendModes = new JH_Auth_ExtendModeB().GetEntities(D => D.ComId == UserInfo.User.ComId && D.PDID == lcsp.ID).Select(D => D.TableFiledColumn).ToList(); tdList[0].WritableFields = ExtendModes.ListTOString(','); new Yan_WF_TDB().Insert(tdList); } msg.Result = lcsp; }
/// <summary> /// 彻底删除已归档的数据 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void DELFORM(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { if (!string.IsNullOrEmpty(P1)) { int[] IDS = P1.SplitTOInt(','); new Yan_WF_PIB().Delete(d => d.ComId == UserInfo.User.ComId && IDS.Contains(d.ID)); new Yan_WF_TIB().Delete(d => d.ComId == UserInfo.User.ComId && IDS.Contains(d.PIID)); new JH_Auth_ExtendDataB().Delete(d => d.ComId == UserInfo.User.ComId && IDS.Contains(d.DataID.Value)); //是不是还需要删除关联表得数据 } }
public void DELDRAFTS(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int ID = int.Parse(P1); SZHL_XXFB xxfb = new SZHL_XXFBB().GetEntity(d => d.ID == ID && d.IsSend == "0" && d.ComId == UserInfo.User.ComId); if (xxfb != null) { new SZHL_XXFBB().Delete(xxfb); new SZHL_XXFB_ITEMB().Delete(d => d.XXFBId == xxfb.ID); } }
/// <summary> /// 根据小组名称获取自律小组信息,包含我所监督的小组 /// </summary> public void GETGROUPTEAMBYCODE(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { P1 = P1.Trim(); string viewname = "select U.* , wu.nickName from JH_Auth_User U LEFT JOIN WX_User wu on u.WxOpenid = wu.openid " + "where u.ZiLvXiaoZu is not null and u.ZiLvXiaoZu <> '' and u.ZiLvXiaoZu = '" + P1 + "' " + "or ('" + P1 + "' like (select Items from dbo.Split(REPLACE(u.jianduxiaozu,' ',''),';') where items='" + P1 + "'))" + " order by u.UserOrder, u.IsZuZhang desc, u.UserRealName asc"; DataTable dt = new JH_Auth_UserB().GetDTByCommand(viewname); msg.Result = dt; }
public void GETSHXXFBLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int page = 0; int.TryParse(context.Request["p"] ?? "1", out page); string strWhere = string.Format(" fgtype.IsCheck='True' and ','+fgtype.CheckUser+',' LIKE '%,{0},%' and fb.ComId={1} and fb.MsgType=1", UserInfo.User.UserName, UserInfo.User.ComId); int recordCount = 0; DataTable dt = new SZHL_XXFBB().GetDataPager("SZHL_XXFB fb inner join SZHL_XXFBType fgtype on fb.TypeID=fgtype.ID", " fb.*,fgtype.TypeName,fgtype.CheckUser", 8, page, " FBTime desc", strWhere, ref recordCount); msg.Result = dt; msg.Result1 = recordCount; }