private void MainToMessage(HttpContext context) { string ls_GoodsImg_Code = "", ls_Code = ""; try { ls_GoodsImg_Code = context.Request["id"]; ls_Code = context.Request["code"]; } catch { context.Response.Write(""); return; } if (string.IsNullOrEmpty(ls_Code) && string.IsNullOrEmpty(ls_GoodsImg_Code)) { context.Response.Write(""); return; } else { GyShop_Page.SetSession(); if (ls_GoodsImg_Code == "0")//获取缩略图 { context.Response.Write(Of_ThumbnaiIimg(ls_Code)); return; } if (ls_GoodsImg_Code == "1")//获取图文详情 { context.Response.Write(Of_GoodsImg(ls_Code)); return; } else { context.Response.Write(""); return; } } }
private void SendMessage(HttpContext context) { string Express_type = context.Request.Form["Express_type"].ToString(); string Express_code = context.Request.Form["Express_code"].ToString(); string goo_str = context.Request.Form["goo_str"].ToString(); string ls_num = context.Request.Form["num"].ToString(); string out_no = context.Request.Form["out_no"].ToString(); if (string.IsNullOrEmpty(Express_type) || string.IsNullOrEmpty(Express_code) || string.IsNullOrEmpty(goo_str) || string.IsNullOrEmpty(ls_num)) { HttpContext.Current.Response.Write("参数不完整"); return; } GyShop_Page.SetSession(); string AppID = ""; string AppSecret = ""; string template_id = ""; string Mobile = ""; string WeixinID = ""; AppID = publicfuns.of_GetMySysSet("weixin", "appid").Replace(" ", ""); AppSecret = publicfuns.of_GetMySysSet("weixin", "appsecret").Replace(" ", ""); template_id = publicfuns.of_GetMySysSet("weixin", "templateid").Replace(" ", ""); if (AppID == "" || AppSecret == "" || template_id == "") { HttpContext.Current.Response.Write("公众号信息不完整!"); return; } string ls_Sql = "SELECT weixinid FROM customer where mobile=@mobile"; GysoftParameter[] Pa = { new GysoftParameter("@mobile", Mobile) }; WeixinID = SqlHelper.ExecuteScalar(ls_Sql, Pa); if (WeixinID == "" || WeixinID == null) { HttpContext.Current.Response.Write("该手机号未绑定微信!"); return; } string access_token = ""; SysVisitor.Current.UserWeixinID = WeixinID; string touser = WeixinID; string url = ""; string menu = "{"; menu += "\"touser\":\"" + touser + "\","; menu += "\"template_id\":\"" + template_id + "\","; menu += "\"url\":\"" + url + "\","; menu += "\"topcolor\":\"#FF0000\","; menu += "\"data\":{"; menu += "\"keyword1\": {"; menu += "\"value\":\"" + Express_type + "\","; menu += "\"color\":\"#173177\""; menu += "},"; menu += "\"keyword2\":{"; menu += "\"value\":\"" + Express_code + "\","; menu += "\"color\":\"#173177\""; menu += "},"; menu += "\"keyword3\":{"; menu += "\"value\":\"" + goo_str + "\r\n 出货单号为:" + out_no + "\","; menu += "\"color\":\"#173177\""; menu += "},"; menu += "\"keyword4\":{"; menu += "\"value\":\"" + ls_num + "\","; menu += "\"color\":\"#173177\""; menu += "}"; menu += "}"; menu += "}"; JObject json = JObject.Parse(menu); menu = json.ToString(); string json_access_token = getPageInfo(string.Format("https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid={0}&secret={1}", AppID, AppSecret)); DataTable dt = Json.JsonToDataTable(json_access_token); try { access_token = dt.Rows[0]["access_token"].ToString(); } catch (Exception ex) { HttpContext.Current.Response.Write(json_access_token + ex.Message + AppID + "|" + AppSecret + "|" + dt.Rows[0][0].ToString()); return; } string content = Of_PostStr(string.Format("https://api.weixin.qq.com/cgi-bin/message/template/send?access_token={0}", access_token), menu); HttpContext.Current.Response.Write(content); }
/// <summary> /// 模板消息,客服消息接口 /// </summary> protected void Page_Load(object sender, EventArgs e) { Encoding UTF8 = Encoding.GetEncoding("UTF-8"); Response.ContentEncoding = UTF8; string AppID = ""; string AppSecret = ""; string template_id = ""; string Mobile = ""; string WeixinID = ""; string Content = ""; Response.ContentType = "text/plain"; if (Request.HttpMethod.ToLower() == "get") //接口认证,用get访问 { #region 模板消息 if (!string.IsNullOrEmpty(Request.QueryString["mobile"]) && !string.IsNullOrEmpty(Request.QueryString["content"])) { Mobile = Request.QueryString["mobile"]; Content = Server.UrlDecode(Request.QueryString["content"]); if (Mobile == null || Content == null) { Response.Write("Error"); return; } string[] str = Content.Split('|'); if (str.Length < 4) { Response.Write("消息参数不足,参数按顺序为快递类型、快递单号、商品信息、商品数量、出货单号(可不加) 并用|隔开"); return; } GyShop_Page.SetSession(); // txt_Code.Text = publicfuns.of_GetMySysSet("weixin", "code"); AppID = publicfuns.of_GetMySysSet("weixin", "appid").Replace(" ", ""); AppSecret = publicfuns.of_GetMySysSet("weixin", "appsecret").Replace(" ", ""); template_id = publicfuns.of_GetMySysSet("weixin", "templateid").Replace(" ", ""); if (AppID == "" || AppSecret == "" || template_id == "") { Response.Write("公众号信息不完整!"); return; } string ls_Sql = "SELECT weixinid FROM customer where mobile=@mobile"; GysoftParameter[] Pa = { new GysoftParameter("@mobile", Mobile) }; WeixinID = SqlHelper.ExecuteScalar(ls_Sql, Pa); if (WeixinID == "" || WeixinID == null) { Response.Write("该手机号未绑定微信!"); return; } //接受信息 快递公司 运单号 商品信息 发货数量 string access_token = ""; SysVisitor.Current.UserWeixinID = WeixinID; string touser = WeixinID; // "owF65jrL27XSMidPDSnsrcFAhOK8";//用户微信ID //string template_id = "ZkjAZNDSU9RRQYQLwo-51oMc4FDVF1yp3oeh8fGTdKA";//模板ID string keyword1 = str[0]; //快递类型 string keyword2 = str[1]; //快递单号 string keyword3 = str[2]; //商品信息 string keyword4 = str[3]; //商品数量 string outone = ""; try { outone = str[4];//出货单号 } catch { } string url = "";// SysVisitor.Current.WebUrl + "/Dw_OutMany.aspx?UserKey = " + UserInfo.GetUserKey() + "&OutNo=" + str[4];//跳转URL 为空时Android端不可点击,IOS端点击进去为空页面 string menu = "{"; menu += "\"touser\":\"" + touser + "\","; menu += "\"template_id\":\"" + template_id + "\","; menu += "\"url\":\"" + url + "\","; menu += "\"topcolor\":\"#FF0000\","; menu += "\"data\":{"; menu += "\"first\":{"; menu += "\"value\":\"" + "你订购的XXX已发货" + "\","; menu += "\"color\":\"#173177\""; menu += "},"; menu += "\"keyword1\": {"; menu += "\"value\":\"" + keyword1 + "\","; menu += "\"color\":\"#173177\""; menu += "},"; menu += "\"keyword2\":{"; menu += "\"value\":\"" + keyword2 + "\","; menu += "\"color\":\"#173177\""; menu += "},"; menu += "\"keyword3\":{"; menu += "\"value\":\"" + keyword3 + "\r\n 出货单号为:" + outone + "\","; menu += "\"color\":\"#173177\""; menu += "},"; menu += "\"keyword4\":{"; menu += "\"value\":\"" + keyword4 + "\","; menu += "\"color\":\"#173177\""; menu += "},"; menu += "\"remark\":{"; menu += "\"value\":\"" + "详情请咨询XXX" + "\","; menu += "\"color\":\"#173177\""; menu += "}"; menu += "}"; menu += "}"; JObject json = JObject.Parse(menu); //json["data"]["keyword1"]["value"] = "天天快递"; //json.Add("data",(new JProperty("keyword5", // new JObject(new JProperty("value", "1234"), new JProperty("color", "#131313"))))); menu = json.ToString(); string json_access_token = getPageInfo(string.Format("https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid={0}&secret={1}", AppID, AppSecret)); DataTable dt = Json.JsonToDataTable(json_access_token); try { access_token = dt.Rows[0]["access_token"].ToString(); } catch (Exception ex) { Response.Write(json_access_token + ex.Message + AppID + "|" + AppSecret + "|" + dt.Rows[0][0].ToString()); return; } string content = Of_PostStr(string.Format("https://api.weixin.qq.com/cgi-bin/message/template/send?access_token={0}", access_token), menu); Response.Write(content); } else { Response.Write("error"); Response.End(); } #endregion if (!string.IsNullOrEmpty(Request.QueryString["message"])) { } } }
protected void Page_Load(object sender, EventArgs e) { Encoding gb2312 = Encoding.GetEncoding("gb2312"); Response.ContentEncoding = gb2312; #region 处理Post请求 if (Request.RequestType == "POST") { GyShop_Page.SetSession(); string Edit = Request.Form["Edit"].ToString(); string scr = Request.Form["imgscr"].ToString();//缩略图路径 string user = Request.Form["username"].ToString(); string passwd = Request.Form["password"].ToString(); string goods_no = Request.Form["goods_no"].ToString(); string text = Server.UrlDecode(Request.Form["text"].ToString()); text = HttpUtility.UrlDecode(text, Encoding.GetEncoding("UTF-8")); string str = SureSaleInfo(user, passwd, as_Code);//SaleInfo.SureSaleInfo(user, passwd); #region 保存产品图文详情 if (str == "OK" && Edit == "false" || Edit == "true") { int count = 0; count = SqlHelper.ExecuteScalarNum("select count(*) from Goodsno_picture where Goo_code=@Goo_code", "@Goo_code=" + goods_no); n_create_sql lnv_sql = new n_create_sql(); lnv_sql.of_SetTable("Goodsno_picture"); if (count <= 0) { lnv_sql.of_AddCol("Goo_code", goods_no); } lnv_sql.of_AddCol("Memo", text); lnv_sql.of_AddCol("Human", user); lnv_sql.of_AddCol("Insdate", DateTime.Now.ToString()); lnv_sql.of_AddCol("Same_code", ""); if (scr != "") { lnv_sql.of_AddCol("ThumbnaiIimg", scr); } int li_count = 0; if (count <= 0) { li_count = lnv_sql.of_execute();//insert } else { li_count = lnv_sql.of_execute("Goo_code=@Goo_code", "@Goo_code=" + goods_no);//update } if (li_count > 0) { Response.Write("OK"); } else { Response.Write("Error"); } return; } #endregion if (str == "OK" && Edit == "DefaulePictrueAdd")//增加首页轮播图 { string strSql = "insert into mysysset(itemType,itemName,itemvalue,memo) values('微信商城焦点图',@itemName,@itemvalue,@memo)"; GysoftParameter[] Pa = { new GysoftParameter("@itemName", goods_no), //title new GysoftParameter("@itemvalue", scr), //Pictrue new GysoftParameter("@memo", text) }; //href int li_Rel = 0; li_Rel = SqlHelper.ExecuteNonQuery(strSql, Pa); if (li_Rel > 0) { Response.Write("OK"); } else { Response.Write("Error;可能标题重复"); } return; } if (str == "OK" && Edit == "DefaulePictrueDel")//删除首页轮播图 { string StrSql = "DELETE from mysysset WHERE itemType='微信商城焦点图' AND itemvalue=@itemvalue"; GysoftParameter[] Pa = { new GysoftParameter("@itemvalue", scr) }; int li_Rel = SqlHelper.ExecuteNonQuery(StrSql, Pa); if (li_Rel > 0) { Response.Write("OK"); } else { Response.Write("Error"); } return; } else { str = HttpUtility.UrlDecode(str, Encoding.GetEncoding("UTF-8")); Response.Write(str); return; } } #endregion #region 处理Get请求 GyShop_Page.SetSession(); url = HttpContext.Current.Request.Url.Query; string username = Request["username"]; string password = Request["password"]; string code1 = Request["code"]; string askey = Request["askey"]; string ls_Rel = "Error"; if (Request["askey"] == null) { if (url == "" || Request["username"] == null || Request["password"] == null) { Response.Write("Error"); return; } ls_Rel = SureSaleInfo(username, password, code1);//SaleInfo.SureSaleInfo(username, password); if (ls_Rel == "OK" && askey == null) { string ls_isdebug = ConfigurationManager.AppSettings["debug"].ToString(); if (ls_isdebug == "Y") { Response.Write("软件正在维护中,请稍后再试"); return; } Response.Write("OK"); return; } else { Response.Write(ls_Rel); } } else if (askey != null) { try { askey = baseclass.DES.of_DecryStrVc(askey, Key); } catch { Response.Write("参数不能被识别"); return; } askey = HttpUtility.UrlDecode(askey, Encoding.GetEncoding("UTF-8")); if (askey == "menu")//拉取商品种类列表 { string sql = "Select typeNo,typeName From goodtype Where isWeb='Y' And isnull(visible,'Y')='Y' order by seq"; DataTable dt = SqlHelper.ExecuteDataTable(sql); string str = Json.DataTableToJson(dt); Response.Write(str); return; } if (askey == "DefaultPicture")//拉取首页图片 { string strSql = "select itemName,itemvalue,memo from mysysset where itemType='微信商城焦点图' order by itemName desc"; DataTable ldt_PPTBox = SqlHelper.ExecuteDataTable(strSql); string str = Json.DataTableToJson(ldt_PPTBox); Response.Write(str); return; } else { string[] str = askey.Split('|'); #region 拉取产品信息列表 if (str.Length == 3) { string row = str[0].Trim(); string menu = str[1].Trim(); string name = str[2].Trim(); int li_PageIndex = 1; string ls_sql = @"select goodsno.goo_name,goodsno.goo_code,goodsno.goo_no from goodsno,goodmate,goodtype where 1=1 and goo_type=typeno and goo_mate*=matecode and goodsno.Goodfunc in ('C','X') and goodtype.isweb='Y' and goodmate.isweb='Y' and goodsno.isweb='Y'"; n_findby_dw lnv_sql = new n_findby_dw(); lnv_sql.of_setSQL(ls_sql); lnv_sql.of_SetOr("goo_no", "goodsno.goo_no", "like", name); lnv_sql.of_SetOr("goo_no", "goodsno.goo_name", "like", name); lnv_sql.of_SetCol("goo_type", "goodsno.goo_type", "=", menu); int count = 0; DataTable ldt_Goods = new DataTable(); ldt_Goods = lnv_sql.Of_GetPageDataTable("goodsno.goo_code", Convert.ToInt32(row), li_PageIndex, ref count); string str_dt = Json.DataTableToJson(ldt_Goods); Response.Write(str_dt); return; } #endregion #region 为经销商微信生成初始密码,获取初始密码 if (str.Length == 4) { string generate = str[0].Trim(); string value = str[1].Trim(); string user = str[2].Trim(); string passwd = str[3].Trim(); string code = as_Code; ls_Rel = SureSaleInfo(user, passwd, code); if (ls_Rel == "OK") { return; //此接口不再使用 if (generate == "generate" && value == "set") //校验值set为生成密码操作 get为获取密码操作 { string ls_sql = "select count(*) WeixinPwd from customer where WeixinPwd is null"; string ls_Temp = SqlHelper.ExecuteScalar(ls_sql); int ls_count = 0; try { ls_count = Convert.ToInt32(ls_Temp); } catch { ls_count = 0; } if (ls_count == 0)//不存在值为空的密码列 { Response.Write("1"); return; } try { int RandKey = 0; Random ran = new Random();//Random对象放在循环外面,否则大概率重复 for (int i = 0; i < ls_count; i++) { RandKey = ran.Next(1000, 9999); string WeixinPwd = baseclass.DES.of_EncryStrVc(RandKey.ToString(), ls_DESKey); string ls_Sql = "set rowcount 1 update customer set WeixinPwd=@WeixinPwd where WeixinPwd is null"; GysoftParameter[] Pa = { new GysoftParameter("@WeixinPwd", WeixinPwd) }; SqlHelper.ExecuteNonQuery(ls_Sql, Pa); } Response.Write("0"); return; } catch (Exception ex) { Response.Write(ex.Message); return; } } if (generate == "generate" && value == "get")//获取经销商初始密码 { string ls_Sql = "select mobile,WeixinPwd from customer"; DataTable ldt_pwd = SqlHelper.ExecuteDataTable(ls_Sql); string ls_pwd = Json.DataTableToJson(ldt_pwd); Response.Write(ls_pwd); return; } } } #endregion #region 获取产品图文详情 string[] str1 = askey.Split('!'); if (str1.Length == 3) { string goocode = str1[0].Trim(); string user = str1[1].Trim(); string passwd = str1[2].Trim(); string code = as_Code; ls_Rel = SureSaleInfo(user, passwd, code); if (ls_Rel == "OK") { string ls_Sql = "select Memo from Goodsno_picture where Goo_code=@Goo_code"; GysoftParameter[] Pa = { new GysoftParameter("@Goo_code", goocode) }; //DataTable ldt_user = SqlHelper.ExecuteDataTable(CommandType.Text, ls_Sql, Pa); //string ls_json = Json.DataTableToJson(ldt_user); //if (ls_json == "[]") //{ Response.Write(""); } //else //Response.Write(ls_json); string ldt_user = SqlHelper.ExecuteScalar(ls_Sql, Pa); Response.Write(ldt_user); return; } } #endregion else { Response.Write("error" + "key:" + Key + " askey:" + askey); return; } } } #endregion }