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;
}
}
