public void Get() { DataTable dt_base = ImportExcelFile(@"C:\Users\Administrator\Desktop\test2016.xls"); DataTable dt = Distinct(dt_base);//自身去重 List <EMPLOYEE> emplist = sbo.QueryAllEmp(); DataTable dtNew1 = dt.Clone(); foreach (var item in emplist) { DataRow[] drArr1 = dt.Select(" B ='" + item.MOBILE + "'"); for (int i = 0; i < drArr1.Length; i++) { // dtNew1.ImportRow(drArr1[i]); dt.Rows.Remove(drArr1[i]);//删除重复数据 } } WeiPage wp = new WeiPage(); string url = "https://api.weixin.qq.com/cgi-bin/qrcode/create?access_token=" + wp.Token(AppConfig.FWHOriginalID); //这里需要修改 int ewmid_max = sbo.GetMaxEwmId();//获取最大的二维码id string Ticket = ""; int j = 0; for (int i = (ewmid_max + 1); i < (ewmid_max + dt.Rows.Count + 1); i++) { string d = @"{ ""action_name"": ""QR_LIMIT_SCENE"", ""action_info"": {""scene"": {""scene_id"": {0}}} }"; d = d.Replace("{0}", i.ToString()); string mes = WeiPage.HttpXmlPostRequest(url, d, Encoding.UTF8); JsonData info = JsonMapper.ToObject(mes); string[] b = mes.Split('\"'); string ticket = info["ticket"].ToString(); Ticket += "https://mp.weixin.qq.com/cgi-bin/showqrcode?ticket=" + ticket + "\r\n"; EMPLOYEE emp = new EMPLOYEE(); emp.USERID = dt.Rows[j]["B"].ToString(); emp.NAME = dt.Rows[j]["A"].ToString(); emp.MOBILE = dt.Rows[j]["B"].ToString(); emp.StoreName = dt.Rows[j]["C"].ToString(); emp.AreaName = dt.Rows[j]["D"].ToString(); emp.EwmId = i; emp.EwmUrl = "https://mp.weixin.qq.com/cgi-bin/showqrcode?ticket=" + ticket; sbo.SaveEMPLOYEE(emp); j++; } string ti = Ticket; }
public ActionResult SaveEWM(QMActivity CuObj, FormCollection form) { JsonSMsg rMsg = new JsonSMsg(); try { CuObj.MdName = CuObj.MdName.ToString(); //double x = 0; //double y = 0; //bd_decrypt(CuObj.Lat.Value, CuObj.Lng.Value, ref y, ref x); //CuObj.Lat = y; //CuObj.Lng = x; //CuObj.MIMAGE_ID = form["MIMAGE_ID"]; int num = _service.SaveQMActivity(CuObj); WeiPage wp = new WeiPage(); string url = "https://api.weixin.qq.com/cgi-bin/qrcode/create?access_token=" + wp.Token(AppConfig.FWHOriginalID); //这里需要修改 string d = @"{ ""action_name"": ""QR_LIMIT_SCENE"", ""action_info"": {""scene"": {""scene_id"": {0}}} }"; d = d.Replace("{0}", num.ToString()); string mes = WeiPage.HttpXmlPostRequest(url, d, Encoding.UTF8); //Response.Write(mes); string[] b = mes.Split('\"'); string ticket = Server.UrlEncode(b[3]); CuObj.Id = num; CuObj.Ticket = "https://mp.weixin.qq.com/cgi-bin/showqrcode?ticket=" + ticket; CuObj.MdSel = "qrscene_" + num.ToString(); num = _service.SaveQMActivity(CuObj); if (num > 0) { rMsg.Status = 0; rMsg.Message = "保存成功"; } else { rMsg.Status = -1; rMsg.Message = "保存失败"; } } catch (Exception ex) { rMsg.Status = -1; rMsg.Message = ex.Message; } return(Json(rMsg)); }
public void opEwmId() { WeiPage wp = new WeiPage(); string url = "https://api.weixin.qq.com/cgi-bin/qrcode/create?access_token=" + wp.Token("gh_b43dad5de37a"); //这里需要修改 string Ticket = ""; for (int i = 1; i <= 10; i++) { string d = @"{ ""action_name"": ""QR_LIMIT_SCENE"", ""action_info"": {""scene"": {""scene_id"": {0}}} }"; d = d.Replace("{0}", i.ToString()); string mes = WeiPage.HttpXmlPostRequest(url, d, Encoding.UTF8); JsonData info = JsonMapper.ToObject(mes); string[] b = mes.Split('\"'); string ticket = info["ticket"].ToString(); Ticket += i + "|https://mp.weixin.qq.com/cgi-bin/showqrcode?ticket=" + ticket + "\r\n"; } }
public ActionResult SaveEmp(EMPLOYEE CuObj, FormCollection form) { JsonSMsg rMsg = new JsonSMsg(); try { //CuObj.NAME = CuObj.NAME.ToString(); //CuObj.MOBILE = CuObj.MOBILE.ToString(); CuObj.USERID = CuObj.MOBILE.ToString(); CuObj.EwmId = _service.GetEwmId() + 1; string deptId = form["DeptId"]; string parentDeptId = form["ParentDeptId"]; //设置StoreName(所属部门),AreaName(部门所属区域) 的值 if (deptJArray == null) { setDeptJArray(); } foreach (JObject dept in deptJArray) { if (dept["id"].ToString() == deptId) { CuObj.StoreName = dept["name"].ToString(); } if (dept["id"].ToString() == parentDeptId) { CuObj.AreaName = dept["name"].ToString(); } } WeiPage wp = new WeiPage(); string url = "https://api.weixin.qq.com/cgi-bin/qrcode/create?access_token=" + wp.Token(AppConfig.FWHOriginalID); //这里需要修改 string d = @"{ ""action_name"": ""QR_LIMIT_SCENE"", ""action_info"": {""scene"": {""scene_id"": {0}}} }"; d = d.Replace("{0}", CuObj.EwmId.ToString()); string mes = WeiPage.HttpXmlPostRequest(url, d, Encoding.UTF8); //Response.Write(mes); string[] b = mes.Split('\"'); string ticket = Server.UrlEncode(b[3]); //CuObj.Id = num; CuObj.EwmUrl = "https://mp.weixin.qq.com/cgi-bin/showqrcode?ticket=" + ticket; //CuObj.MdSel = "qrscene_" + num.ToString(); int num = _service.SaveEMPLOYEE(CuObj); if (num > 0) { rMsg.Status = 0; rMsg.Message = "保存成功"; } else { rMsg.Status = -1; rMsg.Message = "保存失败"; } } catch (Exception ex) { rMsg.Status = -1; rMsg.Message = ex.Message; } return(Json(rMsg)); }
/// <summary> /// 佰草集邀请海报1 /// </summary> /// <param name="openid"></param> /// <returns></returns> public string SeadSeaNews_BCJ(string openid, int SeaSource) { string img = "/assets/img/poster.jpg"; img = Server.MapPath(img); string headimg = "/wechat/spa/image/logo.jpg"; string qrimg = "/wechat/spa/image/logo.jpg"; OAauth_Log oa = mss.GetOA(openid); if (oa != null) { if (!oa.SeaSource.HasValue) { oa.SeaSource = SeaSource; } if (!string.IsNullOrEmpty(oa.MEDIA_ID) && oa.MEDIA_Time.HasValue && oa.MEDIA_Time > DateTime.Now) { return(oa.MEDIA_ID); //如果已有海报,并且未过期,则直接返回之前的海报。 } if (string.IsNullOrEmpty(oa.Ticket)) //如果没有生成过邀请二维码,则生成一个。 { //string access_token = w.Token(w.mjuserid); string jason = "{\"action_name\": \"QR_LIMIT_SCENE\", \"action_info\": {\"scene\": {\"scene_id\": " + (oa.ID + 10000) + "}}}"; //oa的id增加一万 string resMessage = WeiPage.HttpXmlPostRequest("https://api.weixin.qq.com/cgi-bin/qrcode/create?access_token=" + Token(mjuserid), jason, Encoding.UTF8); string[] a = resMessage.Split('\"'); if (a.Length > 3) { oa.Ticket = Server.UrlEncode(a[3]); DownQRImage(oa.Ticket); qrimg = "/wechat/QRImage/" + oa.Ticket + ".jpg"; } } else { qrimg = "/wechat/QRImage/" + oa.Ticket + ".jpg"; } qrimg = Server.MapPath(qrimg); if (!string.IsNullOrEmpty(oa.DownPic)) { headimg = oa.DownPic; } else if (!string.IsNullOrEmpty(oa.headimgurl)) { string down = DownHeadImage(oa); if (!string.IsNullOrEmpty(down)) { headimg = down; } } headimg = Server.MapPath(headimg); string img2 = @"D:\ASPNETTempFiles\seanews\"; if (!System.IO.Directory.Exists(img2)) { Directory.CreateDirectory(img2); } oa.SeaImg = Guid.NewGuid().ToString(); img2 += oa.SeaImg + ".jpg"; if (File.Exists(img) && File.Exists(headimg) && File.Exists(qrimg)) { ImageWriter iw = new ImageWriter(); System.Drawing.Bitmap bm = new System.Drawing.Bitmap(headimg); System.Drawing.Image newImage = CutEllipse(bm, new Rectangle(0, 0, bm.Width, bm.Height), new Size(200, 200)); using (Image image = Image.FromFile(img)) { if (IsPixelFormatIndexed(image.PixelFormat)) { Bitmap bmp = new Bitmap(image.Width, image.Height, PixelFormat.Format32bppArgb); using (Graphics g = Graphics.FromImage(bmp)) { g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic; g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality; g.CompositingQuality = System.Drawing.Drawing2D.CompositingQuality.HighQuality; g.DrawImage(image, 0, 0); } iw.SaveWatermark(bmp, (Bitmap)newImage, ImageWriter.WatermarkPosition.LeftTop, 120, 120, new System.Drawing.Bitmap(qrimg), ImageWriter.WatermarkPosition.LeftBottom, 130, 30, img2, oa.Nickname);; // f.FILE_NAME, Server.MapPath("~/assets/images/shuiyin.png"), Server.MapPath("~/assets/images/shuiyin2.png"), Server.MapPath("~/assets/images/shuiyin3.png"), 0.3f, ImageWriter.WatermarkPosition.Center, 10, f.FILE_NAME); } else { iw.SaveWatermark(new System.Drawing.Bitmap(img), (Bitmap)newImage, ImageWriter.WatermarkPosition.LeftTop, 120, 120, new System.Drawing.Bitmap(qrimg), ImageWriter.WatermarkPosition.LeftBottom, 130, 30, img2, oa.Nickname); }; // f.FILE_NAME, Server.MapPath("~/assets/images/shuiyin.png"), Server.MapPath("~/assets/images/shuiyin2.png"), Server.MapPath("~/assets/images/shuiyin3.png"), 0.3f, ImageWriter.WatermarkPosition.Center, 10, f.FILE_NAME); } } if (File.Exists(img2)) { List <string> imglist = new List <string>(); imglist.Add(img2); string a = HttpUploadFile("https://api.weixin.qq.com/cgi-bin/media/upload?access_token=" + Token(mjuserid) + "&type=image", "图片", "application/x-jpg", new System.Collections.Specialized.NameValueCollection { }, imglist); Rootobject root = JsonConvert.DeserializeObject <Rootobject>(a); if (root.media_id != null) { oa.MEDIA_ID = root.media_id; oa.MEDIA_Time = DateTime.Now.AddDays(3).AddHours(-2); mss.SaveOA(oa); return(root.media_id); // string message = @"{ // ""touser"":""{0}"", // ""msgtype"":""image"", // ""image"": // { // ""media_id"":""{1}"" // } //}"; // message = message.Replace("{0}", oa.FromUserName).Replace("{1}", root.media_id); // string Access_token = Token(mjuserid); // var postUrl = "https://api.weixin.qq.com/cgi-bin/message/custom/send?access_token=" + Access_token; // string d = message; // //d = d.Replace("{0}", "oS7pm1iNL2P2pjdgHO3xC2NRdWE8").Replace("{1}", Message); // string resMessage = HttpXmlPostRequest(postUrl, d, Encoding.UTF8); } } } return("err"); }
/// <summary> /// 海报1 /// </summary> /// <param name="openid"></param> /// <returns></returns> public OAauth_Log SeadSeaNews(OAauth_Log oa) { string img = "/assets/img/bottom.jpg"; img = Server.MapPath(img); string headimg = "/wechat/spa/image/logo.jpg"; string qrimg = "/wechat/spa/image/logo.jpg"; if (oa != null) { if (string.IsNullOrEmpty(oa.Ticket)) //如果没有生成过邀请二维码,则生成一个。 { string jason = "{\"action_name\": \"QR_LIMIT_SCENE\", \"action_info\": {\"scene\": {\"scene_id\": " + (oa.ID + 10000) + "}}}"; //oa的id增加一万 string resMessage = WeiPage.HttpXmlPostRequest("https://api.weixin.qq.com/cgi-bin/qrcode/create?access_token=" + Token(mjuserid), jason, Encoding.UTF8); string[] a = resMessage.Split('\"'); if (a.Length > 3) { oa.Ticket = Server.UrlEncode(a[3]); DownQRImage(oa.Ticket); qrimg = "/wechat/QRImage/" + oa.Ticket + ".jpg"; } } else { qrimg = "/wechat/QRImage/" + oa.Ticket + ".jpg"; } qrimg = Server.MapPath(qrimg); if (!string.IsNullOrEmpty(oa.DownPic)) { headimg = oa.DownPic; } else if (!string.IsNullOrEmpty(oa.headimgurl)) { string down = DownHeadImage(oa); if (!string.IsNullOrEmpty(down)) { headimg = down; } } headimg = Server.MapPath(headimg); string img2 = @"E:\ASPNETTempFiles\seanews\"; if (!System.IO.Directory.Exists(img2)) { Directory.CreateDirectory(img2); } oa.SeaImg = Guid.NewGuid().ToString(); img2 += oa.SeaImg + ".jpg"; if (File.Exists(img) && File.Exists(headimg) && File.Exists(qrimg)) { ImageWriter iw = new ImageWriter(); System.Drawing.Bitmap bm = new System.Drawing.Bitmap(headimg); System.Drawing.Image newImage = CutEllipse(bm, new Rectangle(0, 0, bm.Width, bm.Height), new Size(200, 200)); iw.SaveWatermark(new System.Drawing.Bitmap(img), (Bitmap)newImage, ImageWriter.WatermarkPosition.LeftTop, 90, 70, new System.Drawing.Bitmap(qrimg), ImageWriter.WatermarkPosition.LeftBottom, 220, 50, img2, oa.Nickname);; // f.FILE_NAME, Server.MapPath("~/assets/images/shuiyin.png"), Server.MapPath("~/assets/images/shuiyin2.png"), Server.MapPath("~/assets/images/shuiyin3.png"), 0.3f, ImageWriter.WatermarkPosition.Center, 10, f.FILE_NAME); } if (File.Exists(img2)) { List <string> imglist = new List <string>(); imglist.Add(img2); string a = HttpUploadFile("https://api.weixin.qq.com/cgi-bin/media/upload?access_token=" + Token(mjuserid) + "&type=image", "图片", "application/x-jpg", new System.Collections.Specialized.NameValueCollection { }, imglist); Rootobject root = JsonConvert.DeserializeObject <Rootobject>(a); if (root.media_id != null) { oa.MEDIA_ID = root.media_id; oa.MEDIA_Time = DateTime.Now.AddDays(3).AddHours(-2); mss.SaveOA(oa); return(oa); } } } return(oa); }
public void ApiDemo() { string url = "http://test2.censh.cn/customer/account/sso"; string d = @"{ ""callback"": ""wechat.censh.com"", ""channel"" :""wx"" ,""unique"":""oQaIMwPgnsBpwQYfwLQnUBbmQKS10"" }"; string mes = WeiPage.HttpXmlPostRequest(url, d, Encoding.UTF8); }