public void GETGROUPMODEL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int _GroupCode = int.Parse(P1); WX_Group GP = new WX_GroupB().GetEntity(d => d.GroupCode == _GroupCode); msg.Result = GP; }
public void GETGROUPLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { DataTable dt = new DataTable(); int total = 0; dt = new WX_GroupB().GetDataPager("WX_Group g left join JH_Auth_User u on g.CRUser=u.UserName", " g.*, u.UserRealName ", 99999, 1, " g.CRDate desc", " g.isDel=0 and g.CRUser='******'", ref total); if (dt.Rows.Count > 0) { } msg.Result = dt; msg.Result1 = total; }
public void GETHUODONGLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { DataTable dt = new DataTable(); int total = 0; string whestr = " ZiLvXiaoZu='" + UserInfo.User.ZiLvXiaoZu + "' " + "or ZiLvXiaoZu in (select Items from dbo.Split(REPLACE('" + UserInfo.User.JianDuXiaoZu + "',' ',''),';'))"; dt = new WX_GroupB().GetDataPager("WX_HD ", " * ", 99999, 1, " CRDate desc", whestr, ref total); msg.Result = dt; msg.Result1 = total; msg.Result2 = UserInfo.User.IsZuZhang; }
public void GETMESSAGEHISTORY(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { DataTable dt = new DataTable(); int total = 0; int page = 0; int pagecount = 50; int.TryParse(context.Request.QueryString["p"] ?? "1", out page); int.TryParse(context.Request.QueryString["pagecount"] ?? "8", out pagecount);//页数 string whestr = "GroupName='" + P1 + "'" + " and id in (select top 100 id from[Message] where groupname = '" + P1 + "' order by CRDate desc )"; dt = new WX_GroupB().GetDataPager("MESSAGE ", " * ", 99999, page, " CRDate", whestr, ref total); msg.Result = dt; msg.Result1 = total; }