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