protected void tj_Click(object sender, EventArgs e)
{
Label1_error.Text = "";
FileName = System.Web.HttpContext.Current.Server.MapPath("~/");
dac = new DataAccess.Class1(FileName);
if (label_wxid.Text.Trim() == "-1")
{
//ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('没有获得微信号，请重新刷新一次！');", true);
Label1_error.Text = "没有获得微信号，请退出重新刷新一次！";
return;
}
//ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('text：" + dropProv.SelectedValue + "！ values :"+dropProv.SelectedItem.Text+ "');", true);
string bmnametemp1 = dropProv.SelectedItem.Text.Trim();
string bmidtempid = dropProv.SelectedValue.Trim();
string nametemp1 = name.Text.ToString().Trim();
string sqlstring = "select ID from person where 姓名=ltrim(Rtrim('" + nametemp1.Trim() + "'))";
DataTable dt = dac.return_select(sqlstring);
if (dt.Rows.Count <= 0)
{
//ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('没有在电厂花名册中找到：“"+nametemp1.Trim()+"”!');", true);
Label1_error.Text = "没有在电厂花名册中找到：“" + nametemp1.Trim() + "”!";
return;
}
string peridtempid = dt.Rows[0]["ID"].ToString();
sqlstring = "select isnull(微信ID,'') 微信ID from person where 姓名=ltrim(Rtrim('" + nametemp1.Trim() + "'))";
dt = dac.return_select(sqlstring);
if (dt.Rows[0]["微信ID"].ToString().Trim() != "")
{
//ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('“" + nametemp1.Trim() + "”已经绑定了微信号!');", true);
Label1_error.Text = "“" + nametemp1.Trim() + "”已经绑定了微信号!";
return;
}
sqlstring = "select ID from permoney where 部门ID='" + bmidtempid + "' and 员工ID='" + peridtempid + "'";
//ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('"+sqlstring+"！');", true);
dt = dac.return_select(sqlstring);
if (dt.Rows.Count <= 0)
{
//ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('没有在电厂工资名单的“"+bmnametemp1+"”部门中找到姓名为：“"+nametemp1+"”的员工！');", true);
Label1_error.Text = "没有在电厂工资名单的“" + bmnametemp1 + "”部门中找到姓名为：“" + nametemp1 + "”的员工！";
return;
}
sqlstring = "update person set 微信ID=ltrim(rtrim('" + label_wxid.Text.Trim() + "')) where ID='" + peridtempid + "'";
dac.insert_update_delete(sqlstring);
//ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('绑定完毕！');", true);
Label1_error.Text = "绑定完毕！";
Response.Redirect("money_sql.aspx?accken=" + label_wxid.Text.Trim());
return;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FileName = System.Web.HttpContext.Current.Server.MapPath("~/");
dac = new DataAccess.Class1(FileName);
get_titleid();
}
}
protected void Drpmonth_SelectedIndexChanged(object sender, EventArgs e)
{
FileName = System.Web.HttpContext.Current.Server.MapPath("~/");
dac = new DataAccess.Class1(FileName);
Label1_error.Text = "";
string monthtemp1 = Dropmonth.SelectedItem.Text.Trim();
if (monthtemp1.Trim() == "")
{
Label1_error.Text = "请选择月份！";
return;
}
string sqlstring = "";
DataTable dt;
//LogTextHelper.Info("我选择了月份"+monthtemp1);
dt = dac.person_money_all(label_perid.Text.Trim(), monthtemp1);
//LogTextHelper.Info("员工ID="+perid_all+"查询出的工资有" + dt.Rows.Count.ToString()+"条记录！");
Repeater_money.DataSource = dt;
Repeater_money.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string signature = Request["signature"];
string timestamp = Request["timestamp"];
string nonce = Request["nonce"];
string echostr = Request["echostr"];
if (Request.HttpMethod == "GET")
{
//get method - 仅在微信后台填写URL验证时触发
if (CheckSignature.Check(signature, timestamp, nonce, Token))
{
WriteContent(echostr); //返回随机字符串则表示验证通过
}
else
{
WriteContent("failed:" + signature + "," + CheckSignature.GetSignature(timestamp, nonce, Token) + "。" +
"看这里：：如果你在浏览器中看到这句话，说明此地址可以被作为微信公众账号后台的Url，请注意保持Token一致。");
}
Response.End();
}
else
{
//post method - 当有用户想公众账号发送消息时触发
if (!CheckSignature.Check(signature, timestamp, nonce, Token))
{
WriteContent("参数错误！");
return;
}
//post method - 当有用户想公众账号发送消息时触发
var postModel = new PostModel()
{
Signature = Request.QueryString["signature"],
Msg_Signature = Request.QueryString["msg_signature"],
Timestamp = Request.QueryString["timestamp"],
Nonce = Request.QueryString["nonce"],
//以下保密信息不会（不应该）在网络上传播，请注意
Token = Token,
EncodingAESKey = WeixinEncodingAESKey, // "mNnY5GekpChwqhy2c4NBH90g3hND6GeI4gii2YCvKLY",//根据自己后台的设置保持一致
AppId = WeixinAppId // "wx669ef95216eef885"//根据自己后台的设置保持一致
};
//v4.2.2之后的版本，可以设置每个人上下文消息储存的最大数量，防止内存占用过多，如果该参数小于等于0，则不限制
var maxRecordCount = 10;
var messageHandler = new CustomMessageHandler(Request.InputStream, postModel, maxRecordCount);
try
{
//自定义MessageHandler，对微信请求的详细判断操作都在这里面。
//使用完整的应用凭证获取Token
//Senparc.Weixin.MP.Containers.AccessTokenContainer.TryGetAccessToken(postModel.AppId, WeixinAppSecret);
string access_token = Senparc.Weixin.MP.Containers.AccessTokenContainer.TryGetAccessToken(WeixinAppId, WeixinAppSecret);
//string access_token = Senparc.Weixin.MP.Containers.AccessTokenContainer.GetAccessToken(WeixinAppId);
//LogTextHelper.Info("access_token是：" + access_token);
LogTextHelper.Info("\r\n\r\n第一步：用户名是(weixin)：" + messageHandler.RequestMessage.FromUserName);
//保存这次来访的accekn
FileName = System.Web.HttpContext.Current.Server.MapPath("~/");
dac = new DataAccess.Class1(FileName);
dac.set_accken(messageHandler.RequestMessage.FromUserName.Trim());
////测试时可开启此记录，帮助跟踪数据，使用前请确保App_Data文件夹存在，且有读写权限。
//messageHandler.RequestDocument.Save(
// Server.MapPath("~/App_Data/" + DateTime.Now.Ticks + "_Request_" +
// messageHandler.RequestMessage.FromUserName + ".txt"));
//执行微信处理过程
messageHandler.Execute();
//测试时可开启，帮助跟踪数据
//messageHandler.ResponseDocument.Save(
// Server.MapPath("~/App_Data/" + DateTime.Now.Ticks + "_Response_" +
// messageHandler.ResponseMessage.ToUserName + ".txt"));
//WriteContent(messageHandler.ResponseDocument.ToString());
return;
}
catch (Exception ex)
{
using (TextWriter tw = new StreamWriter(Server.MapPath("~/App_Data/Error_" + DateTime.Now.Ticks + ".txt")))
{
tw.WriteLine(ex.Message);
tw.WriteLine(ex.InnerException.Message);
if (messageHandler.ResponseDocument != null)
{
tw.WriteLine(messageHandler.ResponseDocument.ToString());
}
tw.Flush();
tw.Close();
}
}
finally
{
Response.End();
}
}
}
