//获取需要审核的信息
public void GETXXFBLISTWXSH(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("SZHL_XXFB.ComId='{0}' and IsSend=1 and MsgType=1 and FBTime<=getdate() ", UserInfo.User.ComId);
if (P1 == "1") //显示待发布列表
{
strWhere += string.Format(" and SZHL_XXFB.CRUser='******' ", UserInfo.User.UserName);
}
else //默认显示待审核列表
{
strWhere += string.Format(" and SZHL_XXFB.SHUser='******' ", UserInfo.User.UserName);
}
int recordCount = 0;
DataTable dt = new SZHL_XXFBB().GetDataPager("SZHL_XXFB inner join SZHL_XXFBType xxtype on XXFBType=xxtype.ID", " SZHL_XXFB.*,xxtype.TypeName", 8, page, " FBTime desc", strWhere, ref recordCount);
if (dt.Rows.Count > 0)
{
dt.Columns.Add("Item", Type.GetType("System.Object"));
foreach (DataRow dr in dt.Rows)
{
int xid = Int32.Parse(dr["ID"].ToString());
var list = new SZHL_XXFB_ITEMB().GetEntities(p => p.XXFBId == xid);
dr["Item"] = list;
}
}
msg.Result = dt;
msg.Result1 = Math.Ceiling(recordCount * 1.0 / 8);
}
public void SENDWXMSG(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
var tx = JsonConvert.DeserializeObject <SZHL_TXSX>(P1);
int msgid = Int32.Parse(tx.MsgID);
var model = new SZHL_XXFBB().GetEntity(p => p.ID == msgid);
UserInfo = new JH_Auth_UserB().GetUserInfo(tx.ComId.Value, model.CRUser);
if (model != null)
{
var item = new SZHL_XXFB_ITEMB().GetEntities(d => d.XXFBId == model.ID);
if (item.Count() > 0)
{
List <Article> Msgs = new List <Article>();
foreach (var v in item)
{
new JH_Auth_User_CenterB().SendMsg(UserInfo, "XXFB", model.CRUserName + "发布了一个企业信息", v.ID.ToString(), model.JSUser);
Article ar = new Article();
ar.Title = v.XXTitle;
ar.Description = v.XXTitle;
ar.PicUrl = v.ImageIds.Split(',')[0];
ar.Url = v.ID.ToString();
Msgs.Add(ar);
}
WXHelp wx = new WXHelp(UserInfo.QYinfo);
wx.SendTH(Msgs, "XXFB", "A", model.JSUser);
}
}
}
//获取接收的发布信息,已审核过的信息
public void GETXXFBLISTWX(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int page = 0;
int pagecount = 8;
int.TryParse(context.Request["p"] ?? "1", out page); //页码
int.TryParse(context.Request["pagecount"] ?? "8", out pagecount); //页数
string strWhere = string.Format("SZHL_XXFB.ComId='{0}' and IsSend='1' and MsgType=1 and (((SHstatus='2' and (','+SZHL_XXFB.JSUser+',' LIKE '%,{1},%' or SZHL_XXFB.JSUser='')) and FBTime<=getdate()) or (SHStatus=0 and SHUser='******')or (SHStatus=1 and SZHL_XXFB.CRUser='******')) ", UserInfo.User.ComId, UserInfo.User.UserName);
if (P1 != "")
{
strWhere += string.Format(" And (SZHL_XXFB.XXTitle like '%{0}%' )", P1);
}
if (P2 != "")
{
strWhere += string.Format(" and ( xxtype.Id={0} or TypePath like '{1}%') ", P2.Split('-').LastOrDefault(), P2);
}
int recordCount = 0;
DataTable dt = new SZHL_XXFBB().GetDataPager("SZHL_XXFB inner join SZHL_XXFBType xxtype on XXFBType=xxtype.ID", " SZHL_XXFB.*,xxtype.TypeName", pagecount, page, "SHstatus asc,IsSend asc, FBTime desc", strWhere, ref recordCount);
if (dt.Rows.Count > 0)
{
dt.Columns.Add("Item", Type.GetType("System.Object"));
foreach (DataRow dr in dt.Rows)
{
int xid = Int32.Parse(dr["ID"].ToString());
var list = new SZHL_XXFB_ITEMB().GetEntities(p => p.XXFBId == xid);
dr["Item"] = list;
}
}
msg.Result = dt;
msg.Result1 = Math.Ceiling(recordCount * 1.0 / 8);
}
public void UPXXFBREADUSER(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int Id = int.Parse(P1);
SZHL_XXFB_ITEM model = new SZHL_XXFB_ITEMB().GetEntity(d => d.ID == Id);
if (model != null)
{
if (model.ReadUser == null || !model.ReadUser.Split(',').Contains(UserInfo.User.UserName))
{
model.ReadUser += (model.ReadUser == "" || model.ReadUser == null ? "" : ",") + UserInfo.User.UserName;
new SZHL_XXFB_ITEMB().Update(model);
string strSql = string.Format("UPDATE JH_Auth_User_Center set isRead=1 where ComId={0} and MsgModeId='xxfb' and DataId={1} and UserTO='{2}'", UserInfo.User.ComId, Id, UserInfo.User.UserName);
new JH_Auth_User_CenterB().ExsSql(strSql);
}
}
}
//获取信息详情 PC微信共同使用
public void GETXXFBMODELWX(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int Id = int.Parse(P1);
SZHL_XXFB_ITEM model = new SZHL_XXFB_ITEMB().GetEntity(d => d.ID == Id && d.ComId == UserInfo.User.ComId);
if (model != null)
{
SZHL_XXFB xmodel = new SZHL_XXFBB().GetEntity(p => p.ID == model.XXFBId);
xmodel.Remark = new SZHL_XXFBTypeB().GetEntity(p => p.ID == xmodel.XXFBType).TypeName;
msg.Result = model;
msg.Result1 = new SZHL_XXFB_ITEMB().GetDTByCommand(" SELECT ID,MSGTLYID,MSGType,MSGContent,CRDate,CRUser,CRUserName FROM JH_Auth_TL WHERE MSGType='XXFB' AND MSGTLYID='" + P1 + "'");
if (!string.IsNullOrEmpty(model.Files))
{
msg.Result2 = new FT_FileB().GetEntities(" ID in (" + model.Files + ")");
}
msg.Result3 = new JH_Auth_User_CenterB().GetEntities(d => d.DataId == P1 && d.MsgModeID == "xxfb" && d.isRead == 0).Select(d => d.UserTO);
msg.Result4 = xmodel;
}
new JH_Auth_User_CenterB().ReadMsg(UserInfo, Id, "XXFB");
}
