protected void Page_Load(object sender, EventArgs e) { string sequence = Request.QueryString["seq"]; string userId = Request.QueryString["userId"]; PolicyDao policyDao = new ChinaUnion_DataAccess.PolicyDao(); Policy policy = policyDao.Get(Int32.Parse(sequence)); if (policy != null) { PolicyReceiverLogDao policyReceiverLogDao = new PolicyReceiverLogDao(); PolicyReceiverLog policyReceiverLog = new PolicyReceiverLog(); policyReceiverLog.policySequence = policy.sequence; policyReceiverLog.readtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); policyReceiverLog.userId = userId; policyReceiverLogDao.Add(policyReceiverLog); Response.ContentType = "Application/pdf"; this.Response.Clear(); System.IO.Stream fs = this.Response.OutputStream; fs.Write(policy.attachment, 0, policy.attachment.Length); fs.Close(); this.Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { string sequence = Request.QueryString["seq"]; string userId = Request.QueryString["userId"]; logger.Info("sequence=" + sequence); logger.Info("userId=" + userId); if (!String.IsNullOrEmpty(sequence)) { PolicyDao policyDao = new ChinaUnion_DataAccess.PolicyDao(); Policy policy = policyDao.Get(Int32.Parse(sequence)); if (policy != null) { this.lblSubject.Text = policy.subject; // this.lblSendTime.Text = policy.creatTime; if (!String.IsNullOrEmpty(policy.content)) { this.lblContent.Text = " <br>"+policy.content.Replace("\r\n", " <br>").Replace("\n", " <br>"); ; } logger.Info("sequence=" + sequence); logger.Info("userId=" + userId); PolicyReceiverLogDao policyReceiverLogDao = new PolicyReceiverLogDao(); PolicyReceiverLog policyReceiverLog = new PolicyReceiverLog(); policyReceiverLog.policySequence = policy.sequence; policyReceiverLog.readtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); policyReceiverLog.userId = userId; policyReceiverLogDao.Add(policyReceiverLog); } } }
/// <summary> /// 删除数据 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Delete(PolicyReceiverLog entity) { string sql = "DELETE FROM tb_policy_read_log WHERE policy_sequence=@policy_sequence and userId=@userId and readtime=@readtime"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@policy_sequence", entity.policySequence); command.Parameters.AddWithValue("@userId", entity.userId); command.Parameters.AddWithValue("@readtime", entity.readtime); int i = command.ExecuteNonQuery(); mycn.Close(); return i; } }
public const string mysqlConnection = DBConstant.mysqlConnection;//"User Id=root;Host=115.29.229.134;Database=chinaunion;password=c513324665;charset=utf8"; /// <summary> /// 添加数据 /// </summary> /// <returns></returns> public int Add(PolicyReceiverLog entity) { string sql = "INSERT INTO tb_policy_read_log (policy_sequence,userId,readtime) VALUE (@policy_sequence,@userId,@readtime)"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@policy_sequence", entity.policySequence); command.Parameters.AddWithValue("@userId", entity.userId); command.Parameters.AddWithValue("@readtime", entity.readtime); int i = command.ExecuteNonQuery(); mycn.Close(); return i; } }
/// <summary> /// 修改数据 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Update(PolicyReceiverLog entity) { string sql = "UPDATE tb_policy_read_log SET policy_sequence=@policy_sequence,userId=@userId where policy_sequence=@policy_sequence and readtime=@readtime"; //string sql = "UPDATE cimuser SET userNickName=@userNickName WHERE userid=@userid"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@policy_sequence", entity.policySequence); command.Parameters.AddWithValue("@userId", entity.userId); command.Parameters.AddWithValue("@readtime", entity.readtime); int i = command.ExecuteNonQuery(); mycn.Close(); return i; } }
protected void Page_Load(object sender, EventArgs e) { string sequence = Request.QueryString["seq"]; string userId = Request.QueryString["userId"]; logger.Info("sequence=" + sequence); logger.Info("userId=" + userId); if (String.IsNullOrEmpty(sequence)) { string code = Request.QueryString["code"]; sequence = Request.QueryString["state"]; string search_scope = Request.QueryString["search_scope"]; string agentId = Request.QueryString["agentId"]; logger.Info("agentId=" + Request.QueryString["agentId"]); logger.Info("code=" + Request.QueryString["code"]); logger.Info("state=" + Request.QueryString["state"]); logger.Info("search_scope=" + Request.QueryString["search_scope"]); WechatUtil wechatUtil = new Util.WechatUtil(); HttpResult result = wechatUtil.getUserInfoFromWechat(code, agentId, MyConstant.ScretId); logger.Info("result=" + result.Html); if (result != null && result.Html != null && result.Html.Contains("UserId")) { WechatUserId returnMessage = (WechatUserId)JsonConvert.DeserializeObject(result.Html, typeof(WechatUserId)); userId = returnMessage.UserId; } } if (!String.IsNullOrEmpty(sequence)) { PolicyDao policyDao = new ChinaUnion_DataAccess.PolicyDao(); Policy policy = policyDao.Get(Int32.Parse(sequence)); if (policy != null) { this.lblSubject.Text = policy.subject; this.lblSendTime.Text = policy.creatTime; if (!String.IsNullOrEmpty(policy.content)) { this.lblContent.Text = policy.content.Replace("\r\n"," <br>").Replace("\n"," <br>"); } this.lblValidateStartTime.Text = policy.validateStartTime; this.lblValidateEndTime.Text = policy.validateEndTime; this.lblAttachment.Text = policy.attachmentName; this.lblAttachment.NavigateUrl = "BusinessPolicyAttachmentDetail.aspx?seq=" + policy.sequence + "&userId=" + userId; logger.Info("sequence=" + sequence); logger.Info("userId=" + userId); PolicyReceiverLogDao policyReceiverLogDao = new PolicyReceiverLogDao(); PolicyReceiverLog policyReceiverLog = new PolicyReceiverLog(); policyReceiverLog.policySequence = policy.sequence; policyReceiverLog.readtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); policyReceiverLog.userId = userId; policyReceiverLogDao.Add(policyReceiverLog); WechatQueryLog wechatQueryLog = new ChinaUnion_BO.WechatQueryLog(); wechatQueryLog.agentName = ""; wechatQueryLog.module = Util.MyConstant.module_Notice; wechatQueryLog.subSystem = "通知公告与促销政策"; wechatQueryLog.queryTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); wechatQueryLog.queryString = policy.type; wechatQueryLog.wechatId = userId; WechatQueryLogDao wechatQueryLogDao = new WechatQueryLogDao(); try { wechatQueryLogDao.Add(wechatQueryLog); } catch { } } } }
/// <summary> /// 查询集合 /// </summary> /// <returns></returns> public IList<PolicyReceiverLog> GetList(String policySequence) { string sql = "SELECT policy_sequence,userId,readtime FROM tb_policy_read_log where policy_Sequence=@policy_Sequence"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@policy_Sequence", policySequence); MySqlDataReader reader = command.ExecuteReader(); IList<PolicyReceiverLog> list = new List<PolicyReceiverLog>(); PolicyReceiverLog policyReceiver = null; while (reader.Read()) { policyReceiver = new PolicyReceiverLog(); policyReceiver.policySequence = reader["policy_sequence"] == DBNull.Value ? null : reader["policy_sequence"].ToString(); policyReceiver.userId = reader["userId"] == DBNull.Value ? null : reader["userId"].ToString(); policyReceiver.readtime = reader["readtime"] == DBNull.Value ? null : reader["readtime"].ToString(); list.Add(policyReceiver); } mycn.Close(); return list; } }
/// <summary> /// 查询集合 /// </summary> /// <returns></returns> public IList<PolicyReceiverLog> GetList(String subject, String userId, String readTime) { string sql = "SELECT t1.policy_sequence,t1.userId,t1.readtime,t2.subject,t2.content,t3.type,t3.agentNo,t3.agentName,t3.branchNo,t3.branchName,t3.regionName,t3.contactId,t3.contactName,t3.contactEmail,t3.contactTel,t3.contactWechat FROM tb_policy_read_log t1,tb_policy t2,agent_wechat_account t3 "; sql = sql + " where t1.policy_sequence = t2.sequence and t1.userId = t3.contactId "; if (!String.IsNullOrEmpty(subject)) { sql = sql + " and ((t2.subject like \"%" + subject + "%\")"; sql = sql + " or (t2.content like \"%" + subject + "%\"))"; } if (!String.IsNullOrEmpty(userId)) { sql = sql + " and ((t3.agentNo like \"%" + userId + "%\")"; sql = sql + " or (t3.agentName like \"%" + userId + "%\")"; sql = sql + " or (t3.contactId like \"%" + userId + "%\")"; sql = sql + " or (t3.contactName like \"%" + userId + "%\")"; sql = sql + " or (t3.contactWechat like \"%" + userId + "%\")"; sql = sql + " or (t3.branchNo like \"%" + userId + "%\")"; sql = sql + " or (t3.branchName like \"%" + userId + "%\"))"; } if (!String.IsNullOrEmpty(readTime)) { sql = sql + " and left(readtime,10)<=\""+ readTime + "\""; } using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); MySqlDataReader reader = command.ExecuteReader(); IList<PolicyReceiverLog> list = new List<PolicyReceiverLog>(); PolicyReceiverLog policyReceiver = null; while (reader.Read()) { policyReceiver = new PolicyReceiverLog(); policyReceiver.policySequence = reader["policy_sequence"] == DBNull.Value ? null : reader["policy_sequence"].ToString(); policyReceiver.userId = reader["userId"] == DBNull.Value ? null : reader["userId"].ToString(); policyReceiver.readtime = reader["readtime"] == DBNull.Value ? null : reader["readtime"].ToString(); Policy policy = new Policy(); policy.subject = reader["subject"] == DBNull.Value ? null : reader["subject"].ToString(); policy.content = reader["content"] == DBNull.Value ? null : reader["content"].ToString(); policyReceiver.policy = policy; AgentWechatAccount agentContact = new AgentWechatAccount(); agentContact.type = reader["type"] == DBNull.Value ? null : reader["type"].ToString(); // agentContact.status = reader["status"] == DBNull.Value ? null : reader["status"].ToString(); agentContact.agentNo = reader["agentNo"] == DBNull.Value ? null : reader["agentNo"].ToString(); agentContact.agentName = reader["agentName"] == DBNull.Value ? null : reader["agentName"].ToString(); agentContact.branchNo = reader["branchNo"] == DBNull.Value ? null : reader["branchNo"].ToString(); agentContact.branchName = reader["branchName"] == DBNull.Value ? null : reader["branchName"].ToString(); agentContact.regionName = reader["regionName"] == DBNull.Value ? null : reader["regionName"].ToString(); agentContact.contactId = reader["contactId"] == DBNull.Value ? null : reader["contactId"].ToString(); agentContact.contactEmail = reader["contactEmail"] == DBNull.Value ? null : reader["contactEmail"].ToString(); agentContact.contactTel = reader["contactTel"] == DBNull.Value ? null : reader["contactTel"].ToString(); agentContact.contactName = reader["contactName"] == DBNull.Value ? null : reader["contactName"].ToString(); agentContact.contactWechat = reader["contactWechat"] == DBNull.Value ? null : reader["contactWechat"].ToString(); policyReceiver.agentContact = agentContact; list.Add(policyReceiver); } mycn.Close(); return list; } }