/// <summary> /// 添加报名信息 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1">报名信息json</param> /// <param name="P2"></param> /// <param name="strUserName"></param> public void ADDQYHDITEM(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { SZHL_QYHD_Result item = JsonConvert.DeserializeObject <SZHL_QYHD_Result>(P1); SZHL_QYHDN qyhd = new SZHL_QYHDNB().GetEntity(d => d.ID == item.HDID); if (qyhd == null) { msg.ErrorMsg = "活动已截止"; return; } if (qyhd.StartTime > DateTime.Now) { msg.ErrorMsg = "活动报名未开始"; return; } if (qyhd.EndTime < DateTime.Now) { msg.ErrorMsg = "活动报名已截止"; return; } if (item.ID != 0) { new SZHL_QYHD_ResultB().Update(item); } else { item.CRUser = UserInfo.User.UserName; item.CRDate = DateTime.Now; item.ComId = UserInfo.User.ComId; new SZHL_QYHD_ResultB().Insert(item); } msg.Result = item; }
/// <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; }