public void XMGLMSG(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
SZHL_TXSX TX = JsonConvert.DeserializeObject <SZHL_TXSX>(P1);
int rwid = 0;
int.TryParse(TX.MsgID, out rwid);
SZHL_XMGL xm = new SZHL_XMGLB().GetEntity(d => d.ID == rwid);
Article ar0 = new Article();
ar0.Title = TX.TXContent;
ar0.Description = xm == null ? "" : xm.XMMC;
ar0.Url = TX.MsgID;
List <Article> al = new List <Article>();
al.Add(ar0);
if (!string.IsNullOrEmpty(TX.TXUser))
{
try
{
//发送PC消息
UserInfo = new JH_Auth_UserB().GetUserInfo(TX.ComId.Value, TX.CRUser);
new JH_Auth_User_CenterB().SendMsg(UserInfo, TX.TXMode, TX.TXContent, TX.MsgID, TX.TXUser, "B", 0, TX.ISCS);
}
catch (Exception)
{
}
}
//发送微信消息
WXHelp wx = new WXHelp(UserInfo.QYinfo);
wx.SendTH(al, TX.TXMode, "B", TX.TXUser);
}
/// <summary>
/// 查看项目的详细
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETXMGLMODEL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int Id = 0;
int.TryParse(P1, out Id);
DataTable Model = new SZHL_XMGLB().GetDTByCommand("SELECT xm.*,zd.TypeName from SZHL_XMGL xm left join JH_Auth_ZiDian zd on convert(varchar,YXJ)=convert(varchar,zd.ID) WHERE xm.ID=" + Id + "");
msg.Result = Model;
if (Model != null && Model.Rows.Count > 0)
{
DataTable dtpl = new JH_Auth_TLB().GetTL("XMGL", Model.Rows[0]["ID"].ToString());
msg.Result1 = dtpl;
DataTable filedt = dtpl.Copy();
if (filedt != null && filedt.Rows.Count > 0)
{
foreach (DataRow dr in filedt.Rows)
{
if (dr["MSGisHasFiles"] == null || dr["MSGisHasFiles"].ToString() == "")
{
dr.Delete();
}
}
filedt.AcceptChanges();
msg.Result3 = filedt;
}
if (Model.Rows[0]["Files"].ToString() != "")
{
int[] fileIDs = Model.Rows[0]["Files"].ToString().SplitTOInt(',');
List <FT_File> FileList = new FT_FileB().GetEntities(d => fileIDs.Contains(d.ID)).ToList();
msg.Result2 = FileList;
}
}
}
public void GETXMGLDATA(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
string strWhere = " xm.ComId=" + UserInfo.User.ComId;
if (P1 != "")
{
strWhere += string.Format(" And xm.Status='{0}'", P1);
}
if (P2 != "")
{
switch (P2)
{
case "0":
strWhere += string.Format(" And (xm.CRUser='******' or ','+XMFZR+',' like '%,{0},%' or ','+XMCYR+',' like '%,{0},%' )", UserInfo.User.UserName);
break;
case "1":
strWhere += string.Format(" And xm.CRUser='******'", UserInfo.User.UserName);
break;
case "2":
strWhere += string.Format(" And (','+XMFZR+',' like '%," + UserInfo.User.UserName + ",%' )");
break;
case "3":
strWhere += string.Format(" And (','+XMCYR+',' like '%," + UserInfo.User.UserName + ",%' )");
break;
}
}
string lb = context.Request["lb"] ?? "";
if (lb != "")
{
strWhere += string.Format(" And YXJ='{0}'", lb);
}
string strContent = context.Request["Content"] ?? "";
strContent = strContent.TrimEnd();
if (strContent != "")
{
strWhere += string.Format(" And ( XMMC like '%{0}%' )", strContent);
}
//根据创建时间查询
string time = context.Request["time"] ?? "";
if (time != "")
{
if (time == "1") //近一周
{
strWhere += string.Format(" And datediff(day,xm.CRDate,getdate())<7");
}
else if (time == "2")
{ //近一月
strWhere += string.Format(" And datediff(day,xm.CRDate,getdate())<30");
}
else if (time == "4")
{ //今年
strWhere += string.Format(" And datediff(year,xm.CRDate,getdate())=0");
}
else if (time == "5")
{ //上一年
strWhere += string.Format(" And datediff(year,xm.CRDate,getdate())=1");
}
else if (time == "3") //自定义时间
{
string strTime = context.Request["starTime"] ?? "";
string endTime = context.Request["endTime"] ?? "";
if (strTime != "")
{
strWhere += string.Format(" And convert(varchar(10),xm.CRDate,120) >='{0}'", strTime);
}
if (endTime != "")
{
strWhere += string.Format(" And convert(varchar(10),xm.CRDate,120) <='{0}'", endTime);
}
}
}
int DataID = -1;
int.TryParse(context.Request["ID"] ?? "-1", out DataID);//记录Id
if (DataID != -1)
{
string strIsHasDataQX = new JH_Auth_QY_ModelB().ISHASDATAREADQX("CRM", DataID, UserInfo);
if (strIsHasDataQX == "Y")
{
strWhere += string.Format(" And xm.ID = '{0}'", DataID);
}
}
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 total = 0;
DataTable dtList = new SZHL_XMGLB().GetDataPager("SZHL_XMGL xm left join JH_Auth_ZiDian zd on convert(varchar,YXJ)=convert(varchar,zd.ID)", "xm.* ,zd.TypeName", pagecount, page, " xm.CRDate desc,xm.Status ", strWhere, ref total);
dtList.Columns.Add("PLList", Type.GetType("System.Object"));
dtList.Columns.Add("FileList", Type.GetType("System.Object"));
for (int i = 0; i < dtList.Rows.Count; i++)
{
dtList.Rows[i]["PLList"] = new JH_Auth_TLB().GetTL("XMGL", dtList.Rows[i]["ID"].ToString());
if (dtList.Rows[i]["Files"].ToString() != "")
{
dtList.Rows[i]["FileList"] = new FT_FileB().GetEntities(" ID in (" + dtList.Rows[i]["Files"].ToString() + ")");
}
}
msg.Result = dtList;
msg.Result1 = total;
}
