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;
}
