/// <summary>
/// 获取投票人
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="strUserName"></param>
public void GETTPR(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int Id = 0, opid = 0;
int.TryParse(P1, out Id);
int.TryParse(P2, out opid);
DataTable dttpr = new SZHL_QYHD_ResultB().GetDTByCommand("SELECT CRUser FROM SZHL_QYHD_Result WHERE HDId=" + P1 + " AND OptionID=" + opid + " GROUP BY CRUser");
msg.Result = dttpr;
}
/// <summary>
/// 投票
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="strUserName"></param>
public void ADDTPITEM(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int Id = 0;
int.TryParse(P1, out Id);
SZHL_QYHDN qyhd = new SZHL_QYHDNB().GetEntity(d => d.ID == Id);
if (qyhd == null)
{
msg.ErrorMsg = "活动不存在或已被删除";
return;
}
if (qyhd.StartTime > DateTime.Now)
{
msg.ErrorMsg = "投票未开始";
return;
}
if (qyhd.EndTime < DateTime.Now)
{
msg.ErrorMsg = "投票已截止";
return;
}
DataTable dt = new SZHL_QYHD_ResultB().GetDTByCommand("SELECT OptionUser FROM SZHL_QYHD_Result WHERE HDId='" + P1 + "' AND CRUser='******' AND ComId='" + UserInfo.User.ComId + "' GROUP BY OptionUser");
if (dt.Rows.Count > 0)
{
msg.ErrorMsg = "您已投票";
return;
}
if (P2 == "")
{
msg.ErrorMsg = "请选择";
return;
}
List <SZHL_QYHD_Result> results = new List <SZHL_QYHD_Result>();
string[] xxitem = P2.Split(',');
for (int i = 0; i < xxitem.Length; i++)
{
SZHL_QYHD_Result result = new SZHL_QYHD_Result();
result.CRDate = DateTime.Now;
result.CRUser = UserInfo.User.UserName;
result.ComId = UserInfo.User.ComId;
result.OptionUser = UserInfo.User.UserName;
result.OptionID = Convert.ToInt32(xxitem[i]);
result.HDID = Id;
results.Add(result);
}
new SZHL_QYHD_ResultB().Insert(results);
msg.Result = qyhd;
}
/// <summary>
/// 获取投票信息
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1">ID</param>
/// <param name="P2"></param>
/// <param name="strUserName"></param>
public void GETQYTPMODEL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int Id = 0;
int.TryParse(P1, out Id);
SZHL_QYHDN qyhd = new SZHL_QYHDNB().GetEntity(d => d.ID == Id);
string UserISTP = "N";
//判断当前人是否已投票
UserISTP = new SZHL_QYHD_ResultB().GetEntities(d => d.HDID == qyhd.ID && d.OptionUser == UserInfo.User.UserName && d.ComId == UserInfo.User.ComId).Count() > 0 ? "Y" : "N";
if (P2 == "isuser")
{
UserISTP = "";
}
//选项详细
DataTable dt = new SZHL_QYHD_ResultB().GetDTByCommand(@"SELECT ID,OptionText FROM SZHL_QYHD_Option WHERE HDId='" + P1 + @"'");
msg.Result = qyhd;
msg.Result2 = new SZHL_QYHD_ResultB().GetDTByCommand("SELECT COUNT(0),OptionUser FROM SZHL_QYHD_Result WHERE HDId='" + P1 + "' GROUP BY OptionUser,ComId").Rows.Count;
if (UserISTP == "N")//未投票返回企业投票信息
{
msg.Result1 = dt;
}
else
{ //已投票返回投票信息
dt.Columns.Add("tpr", Type.GetType("System.Object"));
dt.Columns.Add("num", Type.GetType("System.Object"));
List <SZHL_QYHD_Result> resultList = new SZHL_QYHD_ResultB().GetEntities(d => d.HDID == Id).ToList();
foreach (DataRow row in dt.Rows)
{
int opId = 0;
int.TryParse(row["ID"].ToString(), out opId);
List <string> optionUser = resultList.Where(d => d.OptionID == opId).Select(d => d.OptionUser).ToList();
row["tpr"] = optionUser;
row["num"] = optionUser.Count;
}
msg.Result1 = dt;
msg.Result3 = resultList.Count;
}
msg.Result4 = UserISTP;
if (qyhd != null && qyhd.EndTime < DateTime.Now)
{
qyhd.Status = 1;
}
}
/// <summary>
/// 获取投票信息
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="strUserName"></param>
public void TPCOUNTLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int Id = 0;
int.TryParse(P1, out Id);
DataTable dt = new SZHL_QYHD_ResultB().GetDTByCommand(@"SELECT ID,OptionText FROM SZHL_QYHD_Option WHERE HDId='" + P1 + @"'");
dt.Columns.Add("num", Type.GetType("System.Object"));
dt.Columns.Add("tpr", Type.GetType("System.Object"));
List <SZHL_QYHD_Result> resultList = new SZHL_QYHD_ResultB().GetEntities(d => d.HDID == Id).ToList();
foreach (DataRow row in dt.Rows)
{
int opId = 0;
int.TryParse(row["ID"].ToString(), out opId);
List <string> optionUser = resultList.Where(d => d.OptionID == opId).Select(d => d.OptionUser).ToList();
row["num"] = optionUser.Count;
row["tpr"] = optionUser;
}
msg.Result = dt;
msg.Result1 = resultList.Count;
}
/// <summary>
/// 活动列表
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETQYHDLIST_PAGE(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int DataID = -1;
int.TryParse(context.Request["ID"] ?? "-1", out DataID);//获取单个数据的ID
int listType = 0;
int.TryParse(context.Request["listType"] ?? "0", out listType);
string strWhere = "ComId=" + UserInfo.User.ComId + " AND (CYR='' OR CYR like '%" + UserInfo.User.UserName + "%' OR CRUser='******')";
if (listType == 1)
{
strWhere = "ComId=" + UserInfo.User.ComId + " And CRUser='******'";
}
if (P1 == "0")
{
strWhere += string.Format(" And Type = 0 ");
}
else if (P1 == "1")
{
strWhere += string.Format(" And Type=1 ");
}
if (P2 != "")
{
strWhere += string.Format(" And Title like '%{0}%' ", P2);
}
if (DataID != -1)
{
string strIsHasDataQX = new JH_Auth_QY_ModelB().ISHASDATAREADQX("QYHD", DataID, UserInfo);
if (strIsHasDataQX == "Y")
{
strWhere += string.Format(" And ID = '{0}'", DataID);
}
//更新消息为已读状态
new JH_Auth_User_CenterB().ReadMsg(UserInfo, DataID, "QYHD");
}
int page = 0;
int pagecount = 8;
int.TryParse(context.Request["p"] ?? "1", out page);
int.TryParse(context.Request["pagecount"] ?? "8", out pagecount);//页数
int recordCount = 0;
//HDStatus 0已结束 2 正在进行 1 未开始
string strSql = @"SELECT qyhd.ID,qyhd.Type,qyhd.FQF,qyhd.Title,qyhd.JZDate,qyhd.HDDate,qyhd.Status,qyhd.CRDate,qyhd.Files,qyhd.CRUser,qyhd.ComId,qyhd.CYR,qyhd.StartTime,qyhd.EndTime,qyhd.HD_Content,qyhd.HD_Adress,qyhd.TP_IsNM,TP_Type,TP_IsPublic,qyhd.IsPublic,COUNT(result.ID) BMCount ,SUM(case when result.CRUser='******' then 1 else 0 end ) UserBMCount,
case when StartTime>GETDATE() then 1 when EndTime>GETDATE() and StartTime<GETDATE() then 2 when EndTime<GETDATE() then 0 End HDStatus
from SZHL_QYHDN qyhd left join SZHL_QYHD_Result result on qyhd.Id=result.HDID
group by qyhd.ID,qyhd.Type,qyhd.FQF,qyhd.Title,qyhd.JZDate,qyhd.HDDate,qyhd.Status,qyhd.Files,qyhd.CRDate,qyhd.CRUser,qyhd.ComId,qyhd.CYR,qyhd.StartTime,qyhd.EndTime,qyhd.HD_Content,qyhd.HD_Adress,qyhd.TP_IsNM,TP_Type,TP_IsPublic,qyhd.IsPublic";
DataTable dt = new SZHL_QYHDNB().GetDataPager("(" + strSql + ") newTab ", "*", pagecount, page, "HDStatus desc,CRDate desc", strWhere, ref recordCount);
string Ids = "";
string fileIDs = "";
string BMIDs = ""; //报名列表
string TPItemIds = ""; //投票选项
#region 附件，评论列表
foreach (DataRow row in dt.Rows)
{
Ids += row["ID"].ToString() + ",";
if (!string.IsNullOrEmpty(row["Files"].ToString()))
{
fileIDs += row["Files"].ToString() + ",";
}
if (row["Type"].ToString() == "0")
{
BMIDs += row["ID"].ToString() + ",";
}
else
{
TPItemIds += row["ID"].ToString() + ",";
}
}
Ids = Ids.TrimEnd(',');
fileIDs = fileIDs.TrimEnd(',');
BMIDs = BMIDs.TrimEnd(',');
TPItemIds = TPItemIds.TrimEnd(',');
if (Ids != "")
{
List <FT_File> FileList = new List <FT_File>();
DataTable dtPL = new JH_Auth_TLB().GetDTByCommand(string.Format("SELECT * FROM JH_Auth_TL tl WHERE tl.MSGType='QYHD' 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();
}
//报名列表
List <SZHL_QYHD_Result> resultList = new List <SZHL_QYHD_Result>();
if (BMIDs != "")
{
int[] HDIds = BMIDs.SplitTOInt(',');
resultList = new SZHL_QYHD_ResultB().GetEntities(d => HDIds.Contains(d.HDID.Value) && d.ComId == UserInfo.User.ComId).ToList();
}
//投票选项
DataTable dtOption = new DataTable();
if (TPItemIds != "")
{
string strOpSql = string.Format(@"SELECT op.ID,op.OptionText,op.HDId,COUNT(result.ID) TPCount from SZHL_QYHD_Option op left join SZHL_QYHD_Result result on op.ID=result.OptionID and op.HDId in ({0})
GROUP by op.ID,op.OptionText,op.HDId", TPItemIds);
dtOption = new SZHL_QYHD_OptionB().GetDTByCommand(strOpSql);
}
dt.Columns.Add("PLList", Type.GetType("System.Object"));
dt.Columns.Add("FileList", Type.GetType("System.Object"));
dt.Columns.Add("BMList", Type.GetType("System.Object"));
dt.Columns.Add("OptionList", Type.GetType("System.Object"));
foreach (DataRow row in dt.Rows)
{
int HDId = int.Parse(row["ID"].ToString());
row["BMList"] = resultList.Where(d => d.HDID == HDId);
//row["PLList"] = dtPL.FilterTable("MSGTLYID='" + row["ID"] + "'");
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;
if (dtOption.Rows.Count > 0)
{
row["OptionList"] = dtOption.Where("HDId=" + row["ID"]);
}
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;
}
