public void SENDQXZANMSG(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);
UserInfo = new JH_Auth_UserB().GetUserInfo(tx.ComId.Value, tx.CRUser);
var model = new SZHL_TSSQB().GetEntity(p => p.ID == msgid && p.ComId == UserInfo.User.ComId);
if (model != null)
{
Article ar0 = new Article();
ar0.Title = "您被取消一个赞";
ar0.Description = "话题:" + CommonHelp.RemoveHtml(model.HTNR) + "\r\n来自:" + UserInfo.User.UserRealName;
ar0.Url = model.ID.ToString();
List <Article> al = new List <Article>();
al.Add(ar0);
string jsr = string.Empty;
jsr = model.CRUser;
//发送消息
//string content = ar0.Description;
//new JH_Auth_User_CenterB().SendMsg(UserInfo, "CRM", content, model.ID.ToString(), jsr, "A");
if (!string.IsNullOrEmpty(jsr))
{
WXHelp wx = new WXHelp(UserInfo.QYinfo);
wx.SendTH(al, "TSSQ", "A", jsr);
}
}
}
/// <summary>
/// 删除话题
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void DELHTBYID(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
try
{
int SQID = int.Parse(P1);
SZHL_TSSQ SQ = new SZHL_TSSQ();
SQ = new SZHL_TSSQB().GetEntity(d => d.ID == SQID);
if (SQ.CRUser == UserInfo.User.UserName && DateTime.Now.AddMonths(-1) < SQ.CRDate)
{
if (new SZHL_TSSQB().Delete(d => d.ID == SQID))
{
if (new JH_Auth_TLB().Delete(d => d.ComId == UserInfo.User.ComId && d.MSGType == "TSSQ" && d.MSGTLYID == P1))
{
msg.ErrorMsg = "";
}
}
}
else
{
msg.ErrorMsg = "超出时限,您已无法删除该信息";
}
}
catch (Exception ex)
{
msg.ErrorMsg = ex.Message;
}
}
/// <summary>
/// 设置精华发文
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void SETJH(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
try
{
int Id = 0;
int.TryParse(P1, out Id);
int STATUS = 0;
int.TryParse(P2, out STATUS);
SZHL_TSSQ MODEL = new SZHL_TSSQB().GetEntity(D => D.ID == Id);
MODEL.Status = STATUS;
new SZHL_TSSQB().Update(MODEL);
}
catch (Exception ex)
{
msg.ErrorMsg = ex.Message;
}
}
public void SENDHTMSG(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);
UserInfo = new JH_Auth_UserB().GetUserInfo(tx.ComId.Value, tx.CRUser);
var model = new SZHL_TSSQB().GetEntity(p => p.ID == msgid && p.ComId == UserInfo.User.ComId);
if (model != null)
{
Article ar0 = new Article();
ar0.Title = UserInfo.User.UserRealName + "发表了新话题";
ar0.Description = CommonHelp.RemoveHtml(model.HTNR);
ar0.Url = model.ID.ToString();
if (!string.IsNullOrEmpty(model.Files))
{
ar0.PicUrl = model.Files.Split(',')[0];
}
List <Article> al = new List <Article>();
al.Add(ar0);
string jsr = string.Empty;
if (!string.IsNullOrEmpty(model.CYR))
{
jsr = model.CYR;
}
else
{
jsr = new JH_Auth_UserB().GetEntities(p => p.ComId == UserInfo.QYinfo.ComId).Select(d => d.UserName).ToList().ListTOString(',');
}
//发送消息
string content = ar0.Description;
new JH_Auth_User_CenterB().SendMsg(UserInfo, "TSSQ", content, model.ID.ToString(), jsr, "A");
if (!string.IsNullOrEmpty(jsr))
{
WXHelp wx = new WXHelp(UserInfo.QYinfo);
wx.SendTH(al, "TSSQ", "A", jsr);
}
}
}
/// <summary>
/// 获取话题BYID
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETHTMODEL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int Id = 0;
int.TryParse(P1, out Id);
SZHL_TSSQ sg = new SZHL_TSSQB().GetEntity(d => d.ID == Id && d.ComId == UserInfo.User.ComId);
msg.Result = sg;
if (sg != null)
{
if (!string.IsNullOrWhiteSpace(sg.Files))
{
msg.Result1 = new FT_FileB().GetEntities(" ID in (" + sg.Files + ")");
}
if (sg.LeiBie != null && !string.IsNullOrWhiteSpace(sg.LeiBie.ToString()))
{
var SS = new JH_Auth_ZiDianB().GetEntity(p => p.ID == sg.LeiBie);
if (SS != null)
{
msg.Result2 = SS.TypeName;
}
}
//msg.Result3 = new JH_Auth_TLB().GetEntities(d => d.ComId == UserInfo.User.ComId && d.MSGType == "TSSQ" && d.MSGTLYID == P1 && (d.MsgISShow != "Y" && d.MsgISShow != "N")).ToList();
DataTable dtPL = new SZHL_GZBGB().GetDTByCommand(" SELECT * FROM JH_Auth_TL WHERE MSGType='TSSQ' AND MSGTLYID='" + P1 + "' and MsgISShow!='Y' and MsgISShow!='N')");
dtPL.Columns.Add("FileList", Type.GetType("System.Object"));
foreach (DataRow dr in dtPL.Rows)
{
if (dr["MSGisHasFiles"] != null && dr["MSGisHasFiles"].ToString() != "")
{
int[] fileIds = dr["MSGisHasFiles"].ToString().SplitTOInt(',');
dr["FileList"] = new FT_FileB().GetEntities(d => fileIds.Contains(d.ID));
}
}
msg.Result3 = dtPL;
}
}
/// <summary>
/// 话题点赞
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void ZANHTBYID(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int id = 0;
if (int.TryParse(P1, out id))
{
List <JH_Auth_TL> tls = new JH_Auth_TLB().GetEntities(d => d.ComId == UserInfo.User.ComId && d.MSGType == "TSSQ" && d.CRUser == UserInfo.User.UserName && (d.MsgISShow == "Y" || d.MsgISShow == "N") && d.MSGTLYID == P1).ToList();
if (tls.Count > 0)
{
//if (tls[0].CRUser != UserInfo.User.UserName)
//{
// SZHL_TXSX CSTX = new SZHL_TXSX();
// CSTX.Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// CSTX.APIName = "TSSQ";
// CSTX.ComId = UserInfo.User.ComId;
// CSTX.FunName = "SENDQXZANMSG";
// CSTX.CRUserRealName = UserInfo.User.UserRealName;
// CSTX.MsgID = tls[0].MSGTLYID;
// CSTX.TXContent = "";
// CSTX.ISCS = "N";
// CSTX.TXUser = tls[0].CRUser;
// CSTX.TXMode = tls[0].MSGType;
// CSTX.CRUser = UserInfo.User.UserName;
// TXSX.TXSXAPI.AddALERT(CSTX); //时间为发送时间
//}
//new JH_Auth_TLB().Delete(tls[0]);
if (tls[0].MsgISShow == "N")
{
tls[0].MsgISShow = "Y";
new JH_Auth_TLB().Update(tls[0]);
msg.Result = tls[0];
}
else if (tls[0].MsgISShow == "Y")
{
tls[0].MsgISShow = "N";
new JH_Auth_TLB().Update(tls[0]);
msg.ErrorMsg = "del";
}
}
else
{
JH_Auth_TL Model = new JH_Auth_TL();
Model.CRDate = DateTime.Now;
Model.CRUser = UserInfo.User.UserName;
Model.CRUserName = UserInfo.User.UserRealName;
Model.ComId = UserInfo.User.ComId;
Model.MSGTLYID = P1;
Model.MSGType = "TSSQ";
Model.MsgISShow = "Y";
new JH_Auth_TLB().Insert(Model);
SZHL_TSSQ tssq = new SZHL_TSSQB().GetEntity(d => d.ID == id);
if (tssq.CRUser != UserInfo.User.UserName)
{
SZHL_TXSX CSTX = new SZHL_TXSX();
CSTX.Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
CSTX.APIName = "TSSQ";
CSTX.ComId = UserInfo.User.ComId;
CSTX.FunName = "SENDZANMSG";
CSTX.CRUserRealName = UserInfo.User.UserRealName;
CSTX.MsgID = P1;
CSTX.TXContent = "";
CSTX.ISCS = "N";
CSTX.TXUser = tssq.CRUser;
CSTX.TXMode = Model.MSGType;
CSTX.CRUser = UserInfo.User.UserName;
TXSX.TXSXAPI.AddALERT(CSTX); //时间为发送时间
}
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 GETHTLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
string userName = UserInfo.User.UserName;
int page = 0;
int pagecount = 8;
int.TryParse(context.Request["p"] ?? "1", out page); //页码
int.TryParse(context.Request["pagecount"] ?? "8", out pagecount); //页数
page = page == 0 ? 1 : page;
int recordCount = 0;
string strWhere = string.Format(" sq.ComId={0} ", UserInfo.User.ComId);
string strContent = context.Request["Content"] ?? "";
strContent = strContent.TrimEnd();
if (strContent != "")
{
strWhere += string.Format(" And ( sq.HTNR like '%{0}%' )", strContent);
}
string leibie = context.Request["lb"] ?? "";
if (leibie != "")
{
strWhere += string.Format(" And sq.LeiBie='{0}' ", leibie);
}
int DataID = -1;
int.TryParse(context.Request["ID"] ?? "-1", out DataID);//记录Id
if (DataID != -1)
{
string strIsHasDataQX = new JH_Auth_QY_ModelB().ISHASDATAREADQX("TSSQ", DataID, UserInfo);
if (strIsHasDataQX == "Y")
{
strWhere += string.Format(" And sq.ID = '{0}'", DataID);
}
}
if (P1 != "")
{
switch (P1)
{
case "0":
{
//设置usercenter已读
new JH_Auth_User_CenterB().ReadMsg(UserInfo, DataID, "TSSQ");
}
break;
case "1": //我的
{
strWhere += " And sq.CRUser='******'";
}
break;
case "2": //我评论过的
{
//DataTable dtPL = new JH_Auth_TLB().GetDTByCommand(string.Format("SELECT tl.MSGTLYID FROM JH_Auth_TL tl WHERE tl.MSGType='TSSQ' AND tl.MsgISShow <> 'Y' AND tl.CRUser='******'", UserInfo.User.UserName));
string htIDs = new JH_Auth_TLB().GetEntities(d => d.MSGType == "TSSQ" && d.CRUser == UserInfo.User.UserName && (d.MsgISShow != "Y" && d.MsgISShow != "N")).Select(d => d.MSGTLYID).ToList().ListTOString(',');
if (!string.IsNullOrWhiteSpace(htIDs))
{
strWhere += "And sq.ID IN (" + htIDs + ") ";
}
else
{
strWhere += "And sq.ID ='' ";
}
}
break;
case "3": //全部
{
strWhere += " And (ISNULL(sq.CYR,'') = '' OR ','+sq.CYR+',' like '%," + userName + ",%' )";
}
break;
}
DataTable dt = new SZHL_TSSQB().GetDataPager(@" SZHL_TSSQ sq LEFT JOIN JH_Auth_ZiDian zd ON sq.LeiBie=zd.ID and Class=19", " sq.*,zd.TypeName ", pagecount, page, " sq.CRDate DESC ", strWhere, ref recordCount);
#region 附件评论
string Ids = "";
string fileIDs = "";
foreach (DataRow row in dt.Rows)
{
Ids += row["ID"].ToString() + ",";
if (!string.IsNullOrEmpty(row["Files"].ToString()))
{
fileIDs += row["Files"].ToString() + ",";
}
}
Ids = Ids.TrimEnd(',');
fileIDs = fileIDs.TrimEnd(',');
if (Ids != "")
{
List <FT_File> FileList = new List <FT_File>();
DataTable dtPL = new JH_Auth_TLB().GetDTByCommand(string.Format("SELECT tl.* FROM JH_Auth_TL tl WHERE tl.MSGType='TSSQ' AND (ISNULL(tl.MsgISShow,'') <> 'Y' and ISNULL(tl.MsgISShow,'') <> 'N') AND tl.MSGTLYID in ({0}) ORDER BY CRDate ASC", Ids));
DataTable zandt = new JH_Auth_TLB().GetDTByCommand(string.Format("SELECT tl.* FROM JH_Auth_TL tl WHERE tl.MSGType='TSSQ' AND MsgISShow='Y' AND tl.MSGTLYID in ({0})", Ids));
if (!string.IsNullOrEmpty(fileIDs))
{
int[] fileId = fileIDs.SplitTOInt(',');
FileList = new FT_FileB().GetEntities(d => fileId.Contains(d.ID)).ToList();
}
dt.Columns.Add("PLList", Type.GetType("System.Object"));
dt.Columns.Add("FileList", Type.GetType("System.Object"));
dt.Columns.Add("ZanList", Type.GetType("System.Object"));
dt.Columns.Add("IsZan", Type.GetType("System.Object"));
foreach (DataRow row in dt.Rows)
{
DataTable dtPLs = dtPL.FilterTable("MSGTLYID='" + row["ID"] + "'");
dtPLs.Columns.Add("FileList", Type.GetType("System.Object"));
foreach (DataRow dr in dtPLs.Rows)
{
if (dr["MSGisHasFiles"] != null && dr["MSGisHasFiles"].ToString() != "")
{
int[] fileIds = dr["MSGisHasFiles"].ToString().SplitTOInt(',');
dr["FileList"] = new FT_FileB().GetEntities(d => fileIds.Contains(d.ID));
}
}
row["PLList"] = dtPLs;
row["ZanList"] = zandt.FilterTable("MSGTLYID='" + row["ID"] + "'");
row["IsZan"] = zandt.FilterTable(" MSGTLYID='" + row["ID"] + "' and CRUser='******'").Rows.Count > 0 ? "Y" : "N";
if (FileList.Count > 0)
{
string[] fileIds = row["Files"].ToString().Split(',');
row["FileList"] = FileList.Where(d => fileIds.Contains(d.ID.ToString()));
}
}
}
#endregion
msg.Result = dt;
msg.Result1 = recordCount;
}
}
public void SENDHTMSG(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);
UserInfo = new JH_Auth_UserB().GetUserInfo(tx.ComId.Value, tx.CRUser);
var model = new SZHL_TSSQB().GetEntity(p => p.ID == msgid && p.ComId == UserInfo.User.ComId);
if (model != null)
{
#region old
//Article ar0 = new Article();
//ar0.Title = UserInfo.User.UserRealName + "发表了新话题";
//ar0.Description = CommonHelp.RemoveHtml(model.HTNR);
//ar0.Url = model.ID.ToString();
//if (!string.IsNullOrEmpty(model.Files))
//{
// ar0.PicUrl = model.Files.Split(',')[0];
//}
//List<Article> al = new List<Article>();
//al.Add(ar0);
//string jsr = string.Empty;
//if (!string.IsNullOrEmpty(model.CYR))
//{
// jsr = model.CYR;
//}
//else
//{
// jsr = new JH_Auth_UserB().GetEntities(p => p.ComId == UserInfo.QYinfo.ComId).Select(d => d.UserName).ToList().ListTOString(',');
//}
////发送消息
//string content = ar0.Description;
//new JH_Auth_User_CenterB().SendMsg(UserInfo, "TSSQ", content, model.ID.ToString(), jsr, "A");
//if (!string.IsNullOrEmpty(jsr))
//{
// WXHelp wx = new WXHelp(UserInfo.QYinfo);
// wx.SendTH(al, "TSSQ", "A", jsr);
//}
#endregion
//小程序发送通知
var ht = new CommonHelp().StripHT(model.HTNR);
string tzr = model.TZR.ToString();
foreach (var bm in model.TZBM.Split(','))
{
var bmr = new JH_Auth_UserB().GetUserListbyBranch(Int32.Parse(bm), "", UserInfo.User.ComId.Value);
foreach (DataRow dr in bmr.Rows)
{
if (!tzr.Contains(dr["UserName"].ToString()))
{
tzr += "," + dr["UserName"].ToString();
}
}
}
CommonHelp.WriteLOG(tzr);
foreach (var ksuser in tzr.Split(','))
{
if (ksuser != "")
{
CommonHelp.WriteLOG(ksuser);
var usr = new JH_Auth_UserB().GetEntity(p => p.UserName == ksuser);
if (usr != null && !string.IsNullOrEmpty(usr.weixinCard))
{
}
}
}
}
}
