3163 lines
138 KiB
C#
3163 lines
138 KiB
C#
using AppletMvcService.Common;
|
||
using CRM.Core.Common.WebHelper;
|
||
using CRM.Core.DTO.Ord;
|
||
using CRM.Core.DTO.Res;
|
||
using Newtonsoft.Json;
|
||
using OfficeOpenXml;
|
||
using Oracle.ManagedDataAccess.Client;
|
||
using System;
|
||
using System.Collections.Generic;
|
||
using System.Configuration;
|
||
using System.Data;
|
||
using System.Data.SQLite;
|
||
using System.Drawing;
|
||
using System.IO;
|
||
using System.Linq;
|
||
using System.Net;
|
||
using System.Net.Http;
|
||
using System.Security.Cryptography;
|
||
using System.Text;
|
||
using System.Text.RegularExpressions;
|
||
using System.Web;
|
||
using System.Web.Configuration;
|
||
using System.Web.Script.Serialization;
|
||
using System.Windows.Forms;
|
||
using WeChatServerServices.WxDbJob;
|
||
using WX.CRM.BLL.Res;
|
||
using WX.CRM.BLL.SSO;
|
||
using WX.CRM.BLL.Util;
|
||
using WX.CRM.BLL.weapp;
|
||
using WX.CRM.BLL.Wx;
|
||
using WX.CRM.Common;
|
||
using WX.CRM.Common.Employee;
|
||
using WX.CRM.CRMServices.SSO;
|
||
using WX.CRM.CRMServices.WeiXin;
|
||
using WX.CRM.DAL;
|
||
using WX.CRM.DAL.Redis;
|
||
using WX.CRM.IBLL.Util;
|
||
using WX.CRM.Model.DTO;
|
||
using WX.CRM.Model.Entity;
|
||
using WX.CRM.Model.EntitySync;
|
||
using WX.CRM.Model.MAP;
|
||
using WX.Interface.Security;
|
||
|
||
namespace TEST1
|
||
{
|
||
public partial class Form1 : Form
|
||
{
|
||
public Form1()
|
||
{
|
||
InitializeComponent();
|
||
}
|
||
|
||
private void button1_Click(object sender, EventArgs e)
|
||
{
|
||
try
|
||
{
|
||
//DateTime time = DateTimeTool.GetTimeFromLinuxShortTime(0);
|
||
//string s = time.ToString("yyyy-MM-dd HH:mm:ss:ffff");
|
||
//string x = "";
|
||
// new Wx_PushDataManagerBySQL_BL().web_push_updateServiceOnlineInsert("ivanxu2",DateTime.Now);
|
||
|
||
//var att = "UploadFile/att/87680350-c26f-403f-a154-e083a388a90f.jpg";
|
||
//var filename = Path.GetFileName(att);
|
||
|
||
//var filePaths = att.Replace(filename, "");//去掉开头的/,然后再按照/拆分文件路径
|
||
//var dic = @"D:\web\Core.Web\"; //上传文件的一级目录
|
||
//var fullPath = Path.Combine(dic, filePaths);
|
||
|
||
|
||
//DateTime startDate = DateTime.Parse("2008-1-1");
|
||
//DateTime endDate = DateTime.Parse("2010-10-31");
|
||
//int totalMonth = endDate.Year * 12 + endDate.Month - startDate.Year * 12 - startDate.Month;
|
||
|
||
//MessageBox.Show(totalMonth.ToString());
|
||
|
||
//var sDate = Convert.ToDateTime("2017/12/13 16:00:08");
|
||
//var eDate = Convert.ToDateTime("2018/12/13 16:00:08");
|
||
////var allMonth = Math.Abs(eDate.Month - sDate.Month) + 12 * (eDate.Year - sDate.Year);
|
||
////var useMonth = Math.Abs(DateTime.Now.Month - sDate.Month) + 12 * (DateTime.Now.Year - sDate.Year);
|
||
//var allMonth = eDate.Year * 12 + eDate.Month - sDate.Year * 12 - sDate.Month;
|
||
//var useMonth = DateTime.Now.Year * 12 + DateTime.Now.Month - sDate.Year * 12 - sDate.Month;
|
||
//decimal avgPrice = decimal.Parse("99") / allMonth;
|
||
//MessageBox.Show("allMonth:" + allMonth.ToString());
|
||
//MessageBox.Show("useMonth:" + useMonth.ToString());
|
||
//MessageBox.Show("月份差：" + (allMonth - useMonth - 1));
|
||
|
||
//MessageBox.Show("平均价格：" + avgPrice.ToString("f2"));
|
||
|
||
//MessageBox.Show((avgPrice * (allMonth - useMonth - 1)).ToString());
|
||
|
||
//var str = "8157:50% 6068:25% 8211:25%";
|
||
//int index = str.IndexOf(" ");
|
||
//if (index > -1)
|
||
//{
|
||
// var arr = Regex.Split(str, @"\s{2,}");
|
||
// foreach (var item in arr)
|
||
// {
|
||
// MessageBox.Show(item);
|
||
// }
|
||
//}
|
||
//else
|
||
//{
|
||
// MessageBox.Show("未找到");
|
||
//}
|
||
|
||
//var dd = Convert.ToDateTime("2019-01-01").AddDays(30) - DateTime.Now;
|
||
//MessageBox.Show(dd.Ticks.ToString());
|
||
//MessageBox.Show(dd.TotalSeconds.ToString());
|
||
//MessageBox.Show(dd.Days + "天" + dd.Hours + "小时");
|
||
|
||
|
||
//List<string> str = new List<string>() { "z", "c", "b" };
|
||
//MessageBox.Show(string.Join(",", str));
|
||
//str.Reverse();
|
||
//MessageBox.Show(string.Join(",", str));
|
||
|
||
//var ch = 1001;
|
||
|
||
//var list = new List<dynamic>() { new { companyCode = "DNZZ", min = 1, max = 999 }, new { companyCode = "DNZZ", min = 1001, max = 1999 }, new { companyCode = "QBJZ", min = 2100, max = 2199 } };
|
||
|
||
//var company = list.FirstOrDefault(p => p.min <= ch && p.max >= ch);
|
||
|
||
//MessageBox.Show(company.companyCode);
|
||
|
||
|
||
|
||
//var aa = int.Parse("20000010");
|
||
//MessageBox.Show(aa.ToString());
|
||
|
||
//var url = "http://192.168.4.231:806/ResourceService.svc/Distribute";
|
||
//var url = "http://localhost:18739/ResourceService.svc/Distribute";
|
||
|
||
//var para = new { eid = 10000, mobile = "13416115228", typeid = 2222, fromtag = "aaa" }.ToJson();
|
||
|
||
//var response = Utility.PostAjaxData(url, para, Encoding.UTF8);
|
||
//MessageBox.Show(response);
|
||
|
||
//var str = "ab";
|
||
//var arr = new List<string>(str.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries));
|
||
//foreach (var item in arr)
|
||
//{
|
||
// MessageBox.Show(item);
|
||
//}
|
||
|
||
//var str = "111122";
|
||
//var s = str.Substring(0, 4);
|
||
//MessageBox.Show(s);
|
||
|
||
//System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
|
||
|
||
|
||
//SecurityHelper sHelper = new SecurityHelper();
|
||
|
||
////cntent:pYgbH3bL3pCLYP+vWdrHTGhfctlMOkSBBFq1/oguDh4hCEP33LaBJvyWE+LRNanUsJyCmzY50fR5yL/hCeE0LkUJxTI+3bkkfu+hbHw21rHbjeF8Sq+et+Kp7awUfmj2I6iSr5anZ4viSxIEtl4Tx9D3P33tok1Bwxm4N5It+Urw8KoLcUGZxsP6njgKUibshv0YAb7ZE3TxqzFtoLobyqqFA7zlM1zSPSsFO2WBQ3JJv/5Ml9BE/uJ0aKL3BWTgh16SejnkviITmnnwT5KGXvHW2VlriT02，clientid:UPWEBSITE，sign:QHfgo3euyBmLgLnBYb6KIQ==
|
||
//var clientid = "UPWEBSITE";
|
||
//var content = "pYgbH3bL3pCLYP+vWdrHTGhfctlMOkSBBFq1/oguDh4hCEP33LaBJvyWE+LRNanUsJyCmzY50fR5yL/hCeE0LkUJxTI+3bkkfu+hbHw21rHbjeF8Sq+et+Kp7awUfmj2I6iSr5anZ4viSxIEtl4Tx9D3P33tok1Bwxm4N5It+Urw8KoLcUGZxsP6njgKUibshv0YAb7ZE3TxqzFtoLobyqqFA7zlM1zSPSsFO2WBQ3JJv/5Ml9BE/uJ0aKL3BWTgh16SejnkviITmnnwT5KGXvHW2VlriT02";
|
||
//var sign = "QHfgo3euyBmLgLnBYb6KIQ==";
|
||
|
||
//for (int i = 0; i < 10; i++)
|
||
//{
|
||
// sw.Start();
|
||
// sHelper.CheckClientValid(clientid, content, sign);
|
||
// sw.Stop();
|
||
// TimeSpan ts = sw.Elapsed;
|
||
// LogHelper.Info("----" + ts.Milliseconds.ToString() + "ms");
|
||
//}
|
||
//MessageBox.Show("ok");
|
||
|
||
//var json = "{}";
|
||
////var json = "{\"eid\":26201,\"callback\":\"http://app.hc.dn8188.com/activity/00000269.html?unionid=o5bj2wciVgHv7E1QwLa1vqxws0Ko&username=up0000022\",\"isWeb\":true,\"business_name\":\"永顺盈家季度版\",\"business_type\":0,\"tradetype\":1,\"payeename\":\"\",\"payerno\":\"20000044\"}";
|
||
////var json = "{\"callback\":\"http://app.hc.dn8188.com/activity/00000269.html?unionid=o5bj2wciVgHv7E1QwLa1vqxws0Ko&username=up0000022\",\"isWeb\":true,\"business_name\":\"永顺盈家季度版\",\"business_type\":0,\"tradetype\":1,\"payeename\":\"\",\"payerno\":\"20000044\"}";
|
||
|
||
//var data = JsonHelper.JsonDivertToObj<CeShi>(json);
|
||
|
||
//if (data.eid.HasValue)
|
||
// MessageBox.Show(data.eid.ToString());
|
||
//else
|
||
// MessageBox.Show("ok");
|
||
|
||
//var txt = "aa啊打发111";
|
||
////string rgs = "^(?!\\D+$)(?![^a-z]+$)[a-zA-Z\\d]$";
|
||
////string rgs = "^\\w+$";
|
||
//string rgs = "[\u4E00-\u9FA5]";
|
||
//Regex reg = new Regex(rgs);
|
||
//MessageBox.Show(reg.IsMatch(txt).ToString());
|
||
|
||
|
||
//var rejectStr = "[1,2,3]".Replace("[", "").Replace("]", "");
|
||
//var list = new List<string>(rejectStr.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries)).Select<string, int>(x => Convert.ToInt32(x));
|
||
|
||
//MessageBox.Show(list.ToJson());
|
||
|
||
//var para = new { uid = "pengjb" };
|
||
//MessageBox.Show(para.ToJson());
|
||
//var ret = BlowFish.encode("{\"uid\": \"pengjb\"}");
|
||
//var ret = BlowFish.encode(para.ToJson());
|
||
|
||
////MessageBox.Show(Convert.ToBase64String(Encoding.UTF8.GetBytes(ret)));
|
||
//MessageBox.Show(ret);
|
||
|
||
//var roles = "[CKHT][SH][TNBHG]";
|
||
//if (!roles.Contains("[CKHT]") || !roles.Contains("[SH]") || !roles.Contains("[TNBHG]"))
|
||
//{
|
||
// MessageBox.Show("TNBHG");
|
||
//}
|
||
//else
|
||
//{
|
||
// MessageBox.Show("error");
|
||
//}
|
||
|
||
//var model = new JionActiveDto()
|
||
//{
|
||
// account = "15810583121",
|
||
// accounttype = 0,
|
||
// campaignId = "TNB26001",
|
||
//};
|
||
//var json = JsonConvert.SerializeObject(model);
|
||
//var para = new SecurityHelper().createSignEncodingStr(json);
|
||
//MessageBox.Show(para);
|
||
|
||
//var enstr = new WX.Interface.Security.EncDecUtil().encyptData(JsonHelper.ObjDivertToJson(new { result = false, retcode = 10015 }), "1622a92d");
|
||
//MessageBox.Show(enstr);
|
||
|
||
|
||
//var url = "http://localhost:18739/ResourceService.svc/SyncRegUser?content=a&clientid=a&sign=a";
|
||
|
||
//var response = Utility.PostData(url, Encoding.UTF8);
|
||
//MessageBox.Show(response);
|
||
|
||
|
||
//Join?content={content}&clientid={clientid}&sign={sign}
|
||
//var model = new JionActiveDto()
|
||
//{
|
||
// account = "13800138000",
|
||
// accounttype = 0,
|
||
// campaignId = "test"
|
||
//};
|
||
//var json = JsonConvert.SerializeObject(model);
|
||
//var para = new SecurityHelper().createSignEncodingStr(json);
|
||
////Console.WriteLine(para);
|
||
////var url = "http://47.107.128.102:8096/ResourceService.svc/Join";
|
||
//var url = "http://192.168.11.45:806//ResourceService.svc/Join";
|
||
//var rep = Utility.PostData(url + "?" + para, Encoding.UTF8);
|
||
////Console.WriteLine(rep);
|
||
//MessageBox.Show(rep);
|
||
|
||
//var jiemi = new SecurityHelper().decyptData("UPWEBSITE", rep);
|
||
//Console.WriteLine(jiemi);
|
||
|
||
|
||
|
||
|
||
//var url = "http://47.107.128.102:7033/ExamService.svc/Save";
|
||
////var url = "http://192.168.11.46:8096/ExamService.svc/Save";
|
||
//var url = "http://192.168.11.46:8096/ResSaleRule.svc/Save";
|
||
//var url = "http://localhost:55047/ResSaleRule.svc/Save";
|
||
|
||
|
||
//var para = JsonConvert.SerializeObject(new { appid = "a", appuserid = "a", papaerid = 34, subject = "[{\"subjectId\":1, \"answer\":\"A\"},{\"subjectId\":2, \"answer\":\"A\"}]" });
|
||
////var subjectpara = new List<int>() { 1, 2 };
|
||
////var para = JsonConvert.SerializeObject(new { appid = "a", appuserid = "a", papaerid = 1, subject = subjectpara });
|
||
////MessageBox.Show(para);
|
||
//var res = Utility.PostAjaxData(url, para, Encoding.UTF8);
|
||
//var list = new List<int>() { 1, 2, 3 };
|
||
//var para = "[{\"EID\":6029,\"INNERUSERID\":1257205535.0,\"UNAME\":\"陈凤兰\",\"LEVELNO\":2.0,\"NUM\":20.0,\"RATE\":17.142857142857142857142857140,\"ISLIMIT\":0.0,\"LIMITNUM\":null,\"ISVALID\":1.0,\"CTIME\":\"2021-04-16 16:31:31\",\"SALEGROUPID\":15.0,\"DEPTRATE\":60.0}]";
|
||
////var para = JsonConvert.SerializeObject(new { appid = "a", appuserid = "a", papaerid = 34, subject = "[{\"subjectId\":1, \"answer\":\"A\"},{\"subjectId\":2, \"answer\":\"A\"}]" });
|
||
////var subjectpara = new List<int>() { 1, 2 };
|
||
////var para = JsonConvert.SerializeObject(new { appid = "a", appuserid = "a", papaerid = 1, subject = subjectpara });
|
||
////MessageBox.Show(para);
|
||
//var res = Utility.PostAjaxData(url, para, Encoding.UTF8);
|
||
//var url = "http://192.168.11.46:8096/ResSaleRule.svc/Reset";
|
||
//var ch = 1000;
|
||
//var para = new { ch }.ToJson();
|
||
//var rsp = Utility.PostAjaxData(url, para, Encoding.UTF8);
|
||
////var rsp = Utility.PostData(url + "?ch=1000", Encoding.UTF8);
|
||
////var rsp = Utility.HttpPostData(url, "ch=1000", Encoding.UTF8);
|
||
|
||
//var rspObj = JsonConvert.DeserializeAnonymousType(rsp, new { result = false, retcode = 0, retmsg = string.Empty });
|
||
|
||
//MessageBox.Show(rspObj.ToJson());
|
||
|
||
//using (StreamReader sr = new StreamReader("C:\\Users\\Administrator\\Desktop\\463_1_1708111651247040\\coursechapter.txt", Encoding.UTF8))
|
||
//{
|
||
// var str = sr.ReadToEnd();
|
||
|
||
// var list = str.ToObject<List<exambank>>();
|
||
|
||
// var data = list.Where(p => p.igrade == 1 && p.itype == 1);
|
||
|
||
// using (ExcelPackage package = new ExcelPackage())
|
||
// {
|
||
// ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("exam_subject");
|
||
// worksheet.Cells[1, 1].Value = "id";
|
||
// worksheet.Cells[1, 2].Value = "itembankid";
|
||
// worksheet.Cells[1, 3].Value = "subjecttype";
|
||
// worksheet.Cells[1, 4].Value = "subject";
|
||
// worksheet.Cells[1, 5].Value = "options";
|
||
// worksheet.Cells[1, 6].Value = "rightanswer";
|
||
// worksheet.Cells[1, 7].Value = "remark";
|
||
// worksheet.Cells[1, 8].Value = "itembanktype";
|
||
|
||
// var i = 2;
|
||
// foreach (var item in data)
|
||
// {
|
||
// var filename = "C:\\Users\\Administrator\\Desktop\\463_1_1708111651247040\\coursesubject" + item.ichapterid + ".txt";
|
||
// using (var file = new StreamReader(filename, Encoding.UTF8))
|
||
// {
|
||
// var subjectList = file.ReadToEnd().ToObject<List<subject>>();
|
||
// foreach (var subject in subjectList)
|
||
// {
|
||
// var type = 1;
|
||
// if(subject.ctitle.Contains("Ⅱ") && subject.ctitle.Contains("Ⅲ"))
|
||
// {
|
||
// type = 2;
|
||
// }
|
||
// var question = subject.cquestion;
|
||
// question = question.Replace(" B.", "\r\n").Replace(" C.", "\r\n").Replace(" D.", "\r\n").Replace(" B．", "\r\n").Replace(" C．", "\r\n").Replace(" D．", "\r\n");
|
||
// question = question.Replace("A:", "").Replace("B:", "").Replace("C:", "").Replace("D:", "").Replace("A.", "").Replace("B.", "").Replace("C.", "").Replace("D.", "").Replace("A．", "").Replace("B．", "").Replace("C．", "").Replace("D．", "").Replace("A、", "").Replace("B、", "").Replace("C、", "").Replace("D、", "").Replace("\r\n", "##");
|
||
// worksheet.Cells[i, 1].Value = subject.isubjectid;
|
||
// worksheet.Cells[i, 2].Value = item.ichapterid;
|
||
// worksheet.Cells[i, 3].Value = type;
|
||
// worksheet.Cells[i, 4].Value = subject.ctitle;
|
||
// worksheet.Cells[i, 5].Value = question;
|
||
// worksheet.Cells[i, 6].Value = subject.canswer;
|
||
// worksheet.Cells[i, 7].Value = subject.cdescription;
|
||
// worksheet.Cells[i, 8].Value = 1;
|
||
// i++;
|
||
// }
|
||
// }
|
||
// }
|
||
|
||
// using (SaveFileDialog saveFileDialog1 = new SaveFileDialog())
|
||
// {
|
||
// saveFileDialog1.Title = "另存为";
|
||
// saveFileDialog1.FileName = "题目.xlsx"; //设置默认另存为的名字，可选
|
||
// saveFileDialog1.Filter = "Excel 文件(*.xls)|*.xls|Excel 文件(*.xlsx)|*.xlsx|所有文件(*.*)|*.*";
|
||
// saveFileDialog1.AddExtension = true;
|
||
// if (saveFileDialog1.ShowDialog() == DialogResult.OK)
|
||
// {
|
||
// package.SaveAs(new FileInfo(saveFileDialog1.FileName));
|
||
// }
|
||
// }
|
||
// }
|
||
|
||
|
||
|
||
//MessageBox.Show(data.ToJson());
|
||
|
||
//using (ExcelPackage package = new ExcelPackage())
|
||
//{
|
||
|
||
// ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("exam_itembank");
|
||
|
||
// worksheet.Cells[1, 1].Value = "id";
|
||
// worksheet.Cells[1, 2].Value = "title";
|
||
// worksheet.Cells[1, 3].Value = "type";
|
||
// worksheet.Cells[1, 4].Value = "typname";
|
||
|
||
// var i = 2;
|
||
// foreach (var item in data)
|
||
// {
|
||
// worksheet.Cells[i, 1].Value = item.ichapterid;
|
||
// worksheet.Cells[i, 2].Value = item.cchaptername;
|
||
// worksheet.Cells[i, 3].Value = 2;
|
||
// worksheet.Cells[i, 4].Value = "基础知识";
|
||
// i++;
|
||
// }
|
||
|
||
// using (SaveFileDialog saveFileDialog1 = new SaveFileDialog())
|
||
// {
|
||
// saveFileDialog1.Title = "另存为";
|
||
// saveFileDialog1.FileName = "newExcelName.xlsx"; //设置默认另存为的名字，可选
|
||
// saveFileDialog1.Filter = "Excel 文件(*.xls)|*.xls|Excel 文件(*.xlsx)|*.xlsx|所有文件(*.*)|*.*";
|
||
// saveFileDialog1.AddExtension = true;
|
||
// if (saveFileDialog1.ShowDialog() == DialogResult.OK)
|
||
// {
|
||
// package.SaveAs(new FileInfo(saveFileDialog1.FileName));
|
||
// }
|
||
// }
|
||
//}
|
||
//}
|
||
//var sysChannel = "27100,27199";
|
||
//decimal curChannel = 0;
|
||
//var channelArr = sysChannel.Split('|');
|
||
//var regChannel = 27100;
|
||
//foreach (var arr in channelArr)
|
||
//{
|
||
// var chs = arr.Split(',');
|
||
// var minChannel = int.Parse(chs[0]);
|
||
// var maxChannel = int.Parse(chs[1]);
|
||
// //MessageBox.Show(minChannel.ToString() + "|" + maxChannel.ToString());
|
||
// if (regChannel >= minChannel && regChannel <= maxChannel)
|
||
// {
|
||
// curChannel = regChannel;
|
||
// }
|
||
//}
|
||
//MessageBox.Show(curChannel.ToString());
|
||
|
||
//var name = "二维码已过期";
|
||
//var price = "¥9800";
|
||
//var productName = "二维码已过期";
|
||
//var dituPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "ditu.png");
|
||
//var wxPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "wx.png");
|
||
////var aliPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "wx.png");
|
||
//var qrcodePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "11.jpg");
|
||
//using (Image imgbig = new Bitmap(dituPath))
|
||
//{
|
||
// using (Graphics g = Graphics.FromImage(imgbig))
|
||
// {
|
||
// //var name_font = new Font("微软雅黑", 60, FontStyle.Bold);
|
||
// //g.DrawString(name, name_font, Brushes.Black, 40, 80);
|
||
|
||
// //var name_font = new Font("微软雅黑", 30, FontStyle.Bold);
|
||
// //g.DrawString(name, name_font, Brushes.Black, 40, 80);
|
||
|
||
// var productName_font = new Font("微软雅黑", 60, FontStyle.Bold);
|
||
// //var productName_format = new StringFormat{ Alignment = StringAlignment.Center };
|
||
// SizeF productName_size = g.MeasureString(productName, productName_font);
|
||
// var productName_x = (imgbig.Width - productName_size.Width) / 2;
|
||
// var productName_y = (imgbig.Width - productName_size.Height) / 2;
|
||
// //var productName_y = 200;
|
||
// g.DrawString(productName, productName_font, Brushes.Orange, productName_x, productName_y);
|
||
|
||
|
||
// //var price_font = new Font("微软雅黑", 40, FontStyle.Bold);
|
||
// //SizeF price_size = g.MeasureString(productName, productName_font);
|
||
// //var price_x = (imgbig.Width - productName_size.Width) / 2;
|
||
// ////var productName_y = (imgbig.Width - productName_size.Height) / 2;
|
||
// //var price_y = 290;
|
||
// //g.DrawString(price, price_font, Brushes.Black, price_x, price_y);
|
||
|
||
// ////二维码
|
||
// //var img = QRCodeHelper.CombinImage(Image.FromFile(qrcodePath), wxPath);
|
||
|
||
// ////计算图片大小
|
||
// //float w = imgbig.Width / 4;
|
||
|
||
// //float pw = w / (img.Width * (float)0.6);
|
||
// //float ph = w / (img.Height * (float)0.6);
|
||
// //if (pw > ph)
|
||
// //{
|
||
// // pw = ph;
|
||
// //}
|
||
|
||
// //int mw = (int)(pw * img.Width);
|
||
// //int mh = (int)(pw * img.Height);
|
||
|
||
// ////计算图片在二维上的x,y坐标
|
||
// //int x = (imgbig.Width - mw) / 2;
|
||
// //int y = (imgbig.Height - mh) / 2 + 80;
|
||
|
||
// //g.DrawImage(img, x, y, mw, mh);
|
||
// }
|
||
|
||
// imgbig.Save(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, Guid.NewGuid().ToString()) + ".jpg");
|
||
//}
|
||
|
||
//var mobile = "13416115228";
|
||
//if (!mobile.Contains(",") && mobile.Length > 11)
|
||
//{
|
||
// MessageBox.Show("1");
|
||
//}
|
||
//else
|
||
//{
|
||
// MessageBox.Show("2");
|
||
//}
|
||
//var time = DateTime.Parse("2021/5/1 9:00:00");
|
||
//var st = "|" + time.ToShortTimeString() + "|";
|
||
//var t = DateTime.Parse(DateTime.Now.ToShortDateString() + " " + (string.IsNullOrEmpty(time.ToShortTimeString()) ? "00:00:00" : time.ToShortTimeString())).AddDays(1);
|
||
|
||
//MessageBox.Show(st.ToString());
|
||
|
||
//var url = "http://localhost:18739/WeiXinService.svc/WeWorkAssignStatus/put";
|
||
|
||
//var t = new { appid = "ww89347c2378b6e050", userid = "SanBu1401", status = 3, errcode = -1, ch = 1000 };
|
||
|
||
//var rep = Utility.PostAjaxData(url, t.ToJson(), Encoding.UTF8);
|
||
|
||
//MessageBox.Show(rep.ToJson());
|
||
//var obj = Utility.JSONToObject<retObj>(rep);
|
||
|
||
|
||
//var model = new CRM.Core.DTO.Res.AssignStatusDto() {
|
||
// appid = "ww89347c2378b6e050",
|
||
// userid = "SanBu1401",
|
||
// status = 4,
|
||
// errcode = 400,
|
||
// ch = 1000
|
||
//};
|
||
|
||
//string json = Utility.ConvertToJSON<CRM.Core.DTO.Res.AssignStatusDto>(model);
|
||
//json = new SecurityHelper().createSignEncodingStr(json);
|
||
//string url = "http://192.168.11.46:8096/WeWorkService.svc/AssignStatus/Set";
|
||
//string retmsg = Utility.PostData(url + "?" + json, Encoding.UTF8);
|
||
|
||
|
||
//var url = "http://sys.hc.dn8188.com/Work/getqr.html";
|
||
|
||
//var rsp = Utility.PostAjaxData(url, new { appid = "ww89347c2378b6e050", userid = "CaoPing01" }.ToJson(), Encoding.UTF8);
|
||
|
||
//MessageBox.Show(rsp);
|
||
|
||
//var lastCode = "Q2002201";
|
||
|
||
//var prefix = lastCode.Substring(0, 5);
|
||
//var suffix = lastCode.Substring(5, lastCode.Length - 5);
|
||
|
||
//MessageBox.Show("prefix:" + prefix + "---suffix:" + suffix);
|
||
|
||
|
||
//var url = "http://192.168.11.46:8096/ResourceService.svc/Activity/Add";
|
||
|
||
//var para = new { tag = "test001", tagname = "测试001", ch = 1000 }.ToJson();
|
||
|
||
//var rsp = Utility.PostAjaxData(url, para, Encoding.UTF8);
|
||
|
||
//MessageBox.Show(rsp);
|
||
|
||
//var content = HttpUtility.UrlEncode("8fYIIKMSFVzOkfq4Rb8cxexjib9XKnBPRijYcQwZRsFyHSSN4LcMjbW/VevE1iST71iWy+dEiZ2IAV+yp6xmWrA0uvuCxVc7SP7OEDCm773ZrhymqbBBgMWp3hOXi+3naw6BcrRXY8sNfSTxTEPpjbI5so70ySp2oimmAQ0+x4ibIAyB17FdSytgM1n/7HQFxvywECj5qM9L5rnEtwihTLk434PZakz+GHBd3BGgxRQpvI6rFO5MOIZdOydQLL0rMlJraHfc2campw6Vi9nNvCpTkavqSx2g4TWlb07Hm3vYXUJAgd1GSJD7Q5JQ0LRB");
|
||
//var clientid = "UPWEBSITE";
|
||
//var sign = HttpUtility.UrlEncode("CojDhNj9GtKjHUpN/kMt0Q==");
|
||
//var para = "content=" + content + "&clientid=" + clientid + "&sign=" + sign;
|
||
|
||
//var time = (long)Utility.ConvertDateTimeInt(DateTime.Now);
|
||
//var message = JsonConvert.SerializeObject(new { account = "dn.crm", time });
|
||
//var para = new SecurityHelper().createSignEncodingStr(message);
|
||
|
||
//var assignUrl = "http://post.hc.dn8188.com/Rights/assign.html";
|
||
//var assign = new AssignQuery("dn0375611", 2153, 2153, "4_reg");
|
||
//var rsp = Utility.HttpPostData(assignUrl + "?" + para, assign.ToJson(), Encoding.UTF8);
|
||
|
||
//var ret = JsonConvert.DeserializeObject<WeworkUserAssignMessage>(rsp);
|
||
//LogHelper.Info("获取分配" + ret.ToJson());
|
||
|
||
//MessageBox.Show(ret.ToJson());
|
||
|
||
//Dictionary<string, decimal> gyjList = new Dictionary<string, decimal>() { { "1175", 0 }, { "1181", 0 } };
|
||
////Dictionary<string, decimal> gyjList = new Dictionary<string, decimal>() { { "1175", 3980 }, { "1181", 31572 } };
|
||
|
||
//OrderModuleDto order = new OrderModuleDto() { moduleid = "1175", opendays = 30 };
|
||
//List<OrderModuleDto> orderItem = new List<OrderModuleDto>() { new OrderModuleDto() { moduleid = "1181", opendays = 90 }, new OrderModuleDto() { moduleid = "1175", opendays = 30 } };
|
||
//decimal orderPrice = 8888;
|
||
//decimal shengyuPrice = 0;
|
||
|
||
//decimal modulePrice = 0;
|
||
////分母
|
||
//decimal deno = 0;
|
||
////分子
|
||
//decimal num = 0;
|
||
//foreach (var item in orderItem)
|
||
//{
|
||
// decimal gyj = 0;
|
||
// if (gyjList.TryGetValue(item.moduleid, out gyj))
|
||
// {
|
||
// //找到模块公允价
|
||
// //var gyj = gyjList.First(p => p.Key == item.moduleid).Value;
|
||
// if (gyj == 0)
|
||
// {
|
||
// gyj = orderPrice + shengyuPrice;
|
||
// }
|
||
// //公允价*时长
|
||
// deno += gyj * item.opendays.Value;
|
||
// }
|
||
// else
|
||
// {
|
||
// //deno = 1;
|
||
// deno += 1 * item.opendays.Value == 0 ? 1 : item.opendays.Value;
|
||
// }
|
||
//}
|
||
|
||
//if (gyjList.ContainsKey(order.moduleid))
|
||
//{
|
||
// //找到模块公允价
|
||
// decimal gyj = 0;
|
||
// //var gyj = gyjList.First(p => p.Key == order.moduleid).Value;
|
||
// if (gyjList.TryGetValue(order.moduleid, out gyj))
|
||
// {
|
||
// if (gyj == 0)
|
||
// {
|
||
// gyj = orderPrice + shengyuPrice;
|
||
// }
|
||
// }
|
||
// //公允价*时长
|
||
// num = (orderPrice + shengyuPrice) * gyj * order.opendays.Value;
|
||
|
||
// modulePrice = Convert.ToDecimal(num) / Convert.ToDecimal(Convert.ToDecimal(deno == 0 ? 1 : deno));
|
||
//}
|
||
//else
|
||
//{
|
||
// if (order.opendays.Value == 0)
|
||
// order.opendays = 1;
|
||
// modulePrice = Convert.ToDecimal(orderPrice + shengyuPrice) * (order.opendays.Value / deno);
|
||
//}
|
||
|
||
//MessageBox.Show(modulePrice.ToString());
|
||
|
||
//var aa = new List<int>() { 10 };
|
||
//var bb = 0;
|
||
//if (aa != null && aa.Any())
|
||
//{
|
||
// bb = aa.Max(p => p);
|
||
//}
|
||
//var cc = bb + 1;
|
||
//MessageBox.Show(bb.ToString());
|
||
//MessageBox.Show(cc.ToString());
|
||
|
||
//var key = "1633a92d";
|
||
//var str = "1005608116080815" + "100" + "2022-08-10 15:52:00" + "1660118006000" + key;
|
||
|
||
//MessageBox.Show(str);
|
||
//EncDecUtil util = new EncDecUtil();
|
||
//var sign = util.signData(str, key);
|
||
////var sign = HmacMD5(str, key);
|
||
|
||
//MessageBox.Show(sign.ToString());
|
||
|
||
|
||
|
||
|
||
//"g6lOqRTcz6I9OoK1dpRwAw =="
|
||
|
||
|
||
//var time = DateTimeTool.ConvertDateTimeLong(DateTime.Now);
|
||
|
||
//MessageBox.Show(time.ToString());
|
||
|
||
}
|
||
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
|
||
}
|
||
|
||
private void button2_Click(object sender, EventArgs e)
|
||
{
|
||
WX_RCONTACT_BL _rcontact = new WX_RCONTACT_BL();
|
||
var ret = true;
|
||
decimal pici = _rcontact.extractToBeFriendsDataFromMsg(2, "wxid_jo5nnmegwumv21", "wxid_d39x3018s3m812", DateTimeTool.GetTimeFromLinuxTime(1482917638000), ref ret);
|
||
}
|
||
|
||
private void button3_Click(object sender, EventArgs e)
|
||
{
|
||
//初始化一个OpenFileDialog类
|
||
OpenFileDialog fileDialog = new OpenFileDialog();
|
||
|
||
//判断用户是否正确的选择了文件
|
||
if (fileDialog.ShowDialog() == DialogResult.OK)
|
||
{
|
||
//获取用户选择文件的后缀名
|
||
string extension = Path.GetExtension(fileDialog.FileName);
|
||
//声明允许的后缀名
|
||
string clientid = Utility.GetSettingByKey("CRMClientKey");
|
||
WX.CRM.IBLL.Util.ISecurityHelper sHelper = new SecurityHelper();
|
||
StreamReader sr = new StreamReader(fileDialog.FileName, Encoding.Default);
|
||
String line;
|
||
List<string> mobileList = new List<string>();
|
||
Dictionary<string, string> dic = new Dictionary<string, string>();
|
||
RES_RESOURCEMOBILE_BL mobilebl = new RES_RESOURCEMOBILE_BL();
|
||
while ((line = sr.ReadLine()) != null)
|
||
{
|
||
string mobile = line.ToString();
|
||
|
||
//string phone = Utility.GetMobile(line.ToString());
|
||
if (string.IsNullOrWhiteSpace(mobile))
|
||
{
|
||
continue;
|
||
}
|
||
|
||
mobileList.Add(mobile.Trim());
|
||
}
|
||
|
||
|
||
using (ExcelPackage package = new ExcelPackage())
|
||
{
|
||
|
||
ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("test");
|
||
|
||
worksheet.Cells[1, 1].Value = "手机号";
|
||
worksheet.Cells[1, 2].Value = "resid";
|
||
worksheet.Cells[1, 3].Value = "加密手机号码";
|
||
worksheet.Cells[1, 4].Value = "星号手机号码";
|
||
|
||
var i = 2;
|
||
foreach (var item in mobileList)
|
||
{
|
||
worksheet.Cells[i, 1].Value = item;
|
||
worksheet.Cells[i, 2].Value = ResUtil.CreateResId(item);
|
||
worksheet.Cells[i, 3].Value = new SecurityHelper().encyptData(clientid, item);
|
||
worksheet.Cells[i, 4].Value = Utility.NumberFormat(item);
|
||
i++;
|
||
}
|
||
|
||
using (SaveFileDialog saveFileDialog1 = new SaveFileDialog())
|
||
{
|
||
saveFileDialog1.Title = "另存为";
|
||
saveFileDialog1.FileName = "newExcelName.xlsx"; //设置默认另存为的名字，可选
|
||
saveFileDialog1.Filter = "Excel 文件(*.xls)|*.xls|Excel 文件(*.xlsx)|*.xlsx|所有文件(*.*)|*.*";
|
||
saveFileDialog1.AddExtension = true;
|
||
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
|
||
{
|
||
package.SaveAs(new FileInfo(saveFileDialog1.FileName));
|
||
}
|
||
}
|
||
}
|
||
|
||
}
|
||
}
|
||
|
||
private void button4_Click(object sender, EventArgs e)
|
||
{
|
||
Wx_MsgConfig msg = new WX_RCONTACT_BL().GetMsgConfig("wxid_z8hkvrx4h2l322");
|
||
}
|
||
|
||
private void btnUpload_Click(object sender, EventArgs e)
|
||
{
|
||
//初始化一个OpenFileDialog类
|
||
OpenFileDialog fileDialog = new OpenFileDialog();
|
||
|
||
//判断用户是否正确的选择了文件
|
||
if (fileDialog.ShowDialog() == DialogResult.OK)
|
||
{
|
||
//获取用户选择文件的后缀名
|
||
string extension = Path.GetExtension(fileDialog.FileName);
|
||
//声明允许的后缀名
|
||
|
||
StreamReader sr = new StreamReader(fileDialog.FileName, Encoding.Default);
|
||
String line;
|
||
List<string> mobileList = new List<string>();
|
||
Dictionary<string, string> dic = new Dictionary<string, string>();
|
||
while ((line = sr.ReadLine()) != null)
|
||
{
|
||
string phone = Utility.GetMobile(line.ToString());
|
||
if (string.IsNullOrWhiteSpace(phone))
|
||
{
|
||
continue;
|
||
}
|
||
if (!dic.ContainsKey(phone))
|
||
{
|
||
mobileList.Add(phone);
|
||
dic.Add(phone, phone);
|
||
}
|
||
}
|
||
|
||
|
||
SaveFileDialog saveFile1 = new SaveFileDialog();
|
||
saveFile1.Filter = "文本文件(.txt)|*.txt";
|
||
saveFile1.FilterIndex = 1;
|
||
if (saveFile1.ShowDialog() == System.Windows.Forms.DialogResult.OK && saveFile1.FileName.Length > 0)
|
||
{
|
||
System.IO.StreamWriter sw = new System.IO.StreamWriter(saveFile1.FileName, false);
|
||
try
|
||
{
|
||
foreach (var item in mobileList)
|
||
{
|
||
sw.WriteLine(item); //只要这里改一下要输出的内容就可以了
|
||
}
|
||
}
|
||
catch
|
||
{
|
||
throw;
|
||
}
|
||
finally
|
||
{
|
||
sw.Close();
|
||
}
|
||
}
|
||
|
||
}
|
||
}
|
||
private void button18_Click(object sender, EventArgs e)
|
||
{
|
||
//初始化一个OpenFileDialog类
|
||
OpenFileDialog fileDialog = new OpenFileDialog();
|
||
|
||
//判断用户是否正确的选择了文件
|
||
if (fileDialog.ShowDialog() == DialogResult.OK)
|
||
{
|
||
//获取用户选择文件的后缀名
|
||
string extension = Path.GetExtension(fileDialog.FileName);
|
||
//声明允许的后缀名
|
||
string clientid = Utility.GetSettingByKey("CRMClientKey");
|
||
WX.CRM.IBLL.Util.ISecurityHelper sHelper = new SecurityHelper();
|
||
StreamReader sr = new StreamReader(fileDialog.FileName, Encoding.Default);
|
||
String line;
|
||
List<string> mobileList = new List<string>();
|
||
Dictionary<string, string> dic = new Dictionary<string, string>();
|
||
RES_RESOURCEMOBILE_BL mobilebl = new RES_RESOURCEMOBILE_BL();
|
||
while ((line = sr.ReadLine()) != null)
|
||
{
|
||
string resid = line.ToString();
|
||
|
||
//string phone = Utility.GetMobile(line.ToString());
|
||
if (string.IsNullOrWhiteSpace(resid))
|
||
{
|
||
continue;
|
||
}
|
||
|
||
//try
|
||
//{
|
||
// string phone = mobilebl.GetNumberByResId(resid.Trim());//手机号解密
|
||
// //if (!dic.ContainsKey(phone))
|
||
// //{
|
||
// mobileList.Add(phone);
|
||
|
||
//}
|
||
//catch (Exception ex)
|
||
//{
|
||
// LogHelper.Info("出错resid：" + resid);
|
||
//}
|
||
|
||
|
||
//// dic.Add(phone, phone);
|
||
////}
|
||
mobileList.Add(resid);
|
||
}
|
||
|
||
mobileList = mobilebl.GetNumberByResIdList(mobileList).ToList();
|
||
|
||
|
||
SaveFileDialog saveFile1 = new SaveFileDialog();
|
||
saveFile1.Filter = "文本文件(.txt)|*.txt";
|
||
saveFile1.FilterIndex = 1;
|
||
if (saveFile1.ShowDialog() == System.Windows.Forms.DialogResult.OK && saveFile1.FileName.Length > 0)
|
||
{
|
||
System.IO.StreamWriter sw = new System.IO.StreamWriter(saveFile1.FileName, false);
|
||
try
|
||
{
|
||
foreach (var item in mobileList)
|
||
{
|
||
sw.WriteLine(item); //只要这里改一下要输出的内容就可以了
|
||
}
|
||
}
|
||
catch
|
||
{
|
||
throw;
|
||
}
|
||
finally
|
||
{
|
||
sw.Close();
|
||
}
|
||
}
|
||
|
||
}
|
||
}
|
||
private void button5_Click(object sender, EventArgs e)
|
||
{
|
||
try
|
||
{
|
||
//var alive = new alive()
|
||
//{
|
||
// username = "test",
|
||
// lasttime = DateTime.Now.ToString()
|
||
//};
|
||
var url = "http://192.168.1.45:809/WxMessageSvr.svc/TSExecInfo/Put";
|
||
WebClient webClient = new WebClient();
|
||
webClient.Encoding = Encoding.UTF8;
|
||
webClient.Headers[HttpRequestHeader.ContentType] = "application/json";
|
||
//string result = webClient.UploadString(url, "POST", JsonConvert.SerializeObject(alive));
|
||
string result = webClient.UploadString(url, "POST", "{\"endTime\":0,\"isEnd\":0,\"isStart\":1,\"pici\":1206136209,\"starttime\":1516094559724}");
|
||
textBox1.Text = result;
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
LogHelper.Error(ex.ToString());
|
||
}
|
||
}
|
||
|
||
private void button6_Click(object sender, EventArgs e)
|
||
{
|
||
string number = textBox2.Text;
|
||
bool xx = Utility.CheckIsNum(number);
|
||
textBox2.Text += xx;
|
||
}
|
||
|
||
private void button7_Click(object sender, EventArgs e)
|
||
{
|
||
new Wx_DbRead().StartRead();
|
||
}
|
||
|
||
private void button8_Click(object sender, EventArgs e)
|
||
{
|
||
textBox4.Text = ResUtil.CreateResId(textBox3.Text);
|
||
}
|
||
|
||
private void button9_Click(object sender, EventArgs e)
|
||
{
|
||
//new VipMobileToMySql().SatartInsert();
|
||
}
|
||
|
||
private void button10_Click(object sender, EventArgs e)
|
||
{
|
||
//WSMG984VTfLKhFCfJh3mF20SaYp6IsFReQSCeo7c9zvimPfuFeUw1AJvUH8Mj+vZt01cnGUWoBthdHUfLRYrjwNoZa7YhvcN1OJQDtn30Gd5t0YbJSFEj84EIFh/iu0LUnlOba013+XWaKaikUiH830YxG+jU2qs0SaREh0hR64RE0ejkrIzAApjsl8WPYiCM6ybgipBla0/WIMFF8UJZIPXc6uW8vBGvynSyNsq90o=&clientid=UPWEBSITE&sign=pFS+IHDK0XNMXegM0z4ddw==
|
||
//bool isTrue = new SecurityHelper().CheckClientValid("TDORDERSITE", "WSMG984VTfLKhFCfJh3mF20SaYp6IsFReQSCeo7c9zvimPfuFeUw1AJvUH8Mj+vZt01cnGUWoBthdHUfLRYrjwNoZa7YhvcN1OJQDtn30Gd5t0YbJSFEj84EIFh/iu0LUnlOba013+XWaKaikUiH830YxG+jU2qs0SaREh0hR64RE0ejkrIzAApjsl8WPYiCM6ybgipBla0/WIMFF8UJZIPXc6uW8vBGvynSyNsq90o=", "pFS+IHDK0XNMXegM0z4ddw==");
|
||
|
||
string jiema = new SecurityHelper().decyptData("UPWEBSITE", "8fYIIKMSFVwfb1Z7PLyAQ+Q9hI1wsOpcPqSC///xauhfLDtzJHfiBOvKwiAndm6JHl2x4z+rF5zJ6hdCXJgQ1TFzMQDdBNN/uRESfmPwAgoeaUpeEuqUm3mGRksVDQzboZZL/K0KkC70ukVAiDf2gaGpMxbnnIfnkYS8bW332EJBRrPc1QSF0wuPhFgah2Ae18DMRL0MpRIDyQL3gD/trmHYIkGknYXpJrPtnDZoEsEaT82H4iUJ2w==");
|
||
string ssd = jiema;
|
||
//SecurityHelper sHelper =new SecurityHelper();
|
||
//string xxx = sHelper.decyptData("nj_crm", "fNZuPpG7nMK44T1fIOkL6g=="); //解密操作
|
||
//string sdfs = "";
|
||
//sdfs += "sdf";
|
||
}
|
||
|
||
private void button11_Click(object sender, EventArgs e)
|
||
{
|
||
//new SendCrmMsg().Send();
|
||
var msg = "测试测试";
|
||
var mobile = "13416115228";
|
||
var url = "http://localhost:55047/SmsService.svc/PutSms";
|
||
var resid = ResUtil.CreateResId(mobile);
|
||
//var para = "message=" + msg + "&resid=" + resid + "&mobile=" + mobile;
|
||
var para = JsonConvert.SerializeObject(new { message = msg, resid = resid, mobile = mobile });
|
||
var res = Utility.PostAjaxData(url, para, Encoding.UTF8);
|
||
|
||
MessageBox.Show(res);
|
||
}
|
||
|
||
private void button12_Click(object sender, EventArgs e)
|
||
{
|
||
//new SendBatchMsg().Send();
|
||
|
||
}
|
||
|
||
private void button13_Click(object sender, EventArgs e)
|
||
{
|
||
string content = "";
|
||
int status = 200;
|
||
try
|
||
{
|
||
SQLiteConnection cnn = new SQLiteConnection();
|
||
string dbfile = @"z:\dbuploadfile\20185\wxid_zrbb461j7p1c22-909ec4c-180524020129.db";
|
||
//string dbfile = @"\\192.168.1.171\weixin\dbuploadfile\20185\wxid_zrbb461j7p1c22-909ec4c-180524020129.db";
|
||
cnn.ConnectionString = "Data Source=" + dbfile;
|
||
cnn.Open();
|
||
|
||
#region rcontact 读取
|
||
try
|
||
{
|
||
string sql = @" select username,alias,chatroomFlag ,conRemark ,domainList ,nickname ,pyInitial ,quanPin ,showHead ,type ,weiboFlag ,
|
||
weiboNickname ,conRemarkPYFull ,conRemarkPYShort ,verifyFlag ,encryptUsername ,deleteFlag ,
|
||
contactLabelIds,ifnull((select min(createtime)/1000 from message x where x.talker=a.username),strftime('%s','now'))ctime from rcontact a
|
||
where a.type!=33
|
||
and a.username not like'gh_%'
|
||
and a.username not like'%@chatroom'
|
||
and a.username not like'%@stranger'
|
||
and a.username !='filehelper'
|
||
and a.type in(1,3,5,7,257)
|
||
"; //用SQLite Expert管理器看表或者CMD看
|
||
SQLiteCommand cmd = cnn.CreateCommand();
|
||
cmd.CommandText = sql;
|
||
|
||
SQLiteDataReader reader = cmd.ExecuteReader();
|
||
List<rcontact> rcontactList = new List<rcontact>();
|
||
string w = " ";
|
||
StringBuilder build = new StringBuilder();
|
||
try
|
||
{
|
||
while (reader.Read())
|
||
{
|
||
rcontact model = new rcontact();
|
||
|
||
model.username = reader.GetString(0);
|
||
build.Append("1" + w);
|
||
build.Append(model.username + w);//
|
||
model.alias = reader.GetString(1);
|
||
build.Append(model.alias + w);//
|
||
model.chatroomFlag = reader.GetInt64(2);
|
||
model.domainList = reader.GetString(4);
|
||
model.nickname = reader.GetString(5);
|
||
build.Append(model.nickname + w);//
|
||
model.conRemark = reader.GetString(3);
|
||
build.AppendLine(model.conRemark + w);//
|
||
model.pyInitial = reader.GetString(6);
|
||
model.quanPin = reader.GetString(7);
|
||
model.showHead = reader.GetInt64(8);
|
||
model.type = reader.GetInt64(9);
|
||
model.weiboFlag = reader.GetInt64(10);
|
||
model.weiboNickname = reader.GetString(11);
|
||
model.conRemarkPYFull = reader.GetString(12);
|
||
model.conRemarkPYShort = reader.GetString(13);
|
||
model.verifyFlag = reader.GetInt64(14);
|
||
model.encryptUsername = reader.GetString(15);
|
||
model.deleteFlag = reader.GetInt64(16);
|
||
model.contactLabelIds = reader.GetString(17);
|
||
model.ctime = Convert.ToInt64(reader.GetValue(18));
|
||
rcontactList.Add(model);
|
||
}
|
||
}
|
||
catch (Exception xs)
|
||
{
|
||
content += "[读取rcontact出错]";
|
||
status = 100;
|
||
LogHelper.Error("rcontact数据读取错误:" + xs.ToString());
|
||
}
|
||
finally
|
||
{
|
||
reader.Close();
|
||
}
|
||
textBox5.Text = build.ToString();
|
||
}
|
||
catch (Exception xx)
|
||
{
|
||
status = 100;
|
||
content += "[读取rcontact出错]";
|
||
LogHelper.Error(xx.ToString());
|
||
}
|
||
#endregion
|
||
|
||
cnn.Close();
|
||
|
||
}
|
||
catch (Exception xs)
|
||
{
|
||
status = 100;
|
||
content += "[直接报错]";
|
||
LogHelper.Error(xs.ToString());
|
||
}
|
||
}
|
||
|
||
private void button14_Click(object sender, EventArgs e)
|
||
{
|
||
//try
|
||
//{
|
||
|
||
// StringBuilder sub = new StringBuilder();
|
||
// DateTime time = Convert.ToDateTime("2017/3/20 9:08:17");
|
||
// List<ISVR_INTERFACECALLLOG> list = new List<ISVR_INTERFACECALLLOG>();
|
||
// SecurityHelper shelper = new SecurityHelper();
|
||
// using (crmContext db = new crmContext())
|
||
// {
|
||
// list = db.ISVR_INTERFACECALLLOG.Where(m => m.CLIENTURL == "ResourceService/JoinActive" && m.CTIME >= time).OrderByDescending(m => m.CTIME).ToList();
|
||
// }
|
||
// string w = " ";
|
||
// foreach (ISVR_INTERFACECALLLOG item in list)
|
||
// {
|
||
// sub.Append("1" + w);
|
||
// string content = shelper.decyptData("TDORDERSITE", item.CLIENTKEY.Substring(0, item.CLIENTKEY.IndexOf("&clientid=")));
|
||
// var model = JsonDivertToObj<JionActiveDto>(content);
|
||
// sub.Append(model.username + w);
|
||
// sub.Append(model.mobile + w);
|
||
// sub.Append(model.kword + w);
|
||
// sub.Append(ResUtil.CreateResId(model.mobile) + w);
|
||
// //sub.AppendLine(content);
|
||
// sub.AppendLine(item.CTIME.Value.ToString("yyyy/MM/dd hh:mm:ss"));
|
||
// }
|
||
// textBox5.Text = sub.ToString();
|
||
//}
|
||
//catch (Exception ex) { textBox5.Text = ex.ToString(); }
|
||
}
|
||
public static T JsonDivertToObj<T>(string json)
|
||
{
|
||
JavaScriptSerializer script = new JavaScriptSerializer();
|
||
T dic = script.Deserialize<T>(json);
|
||
return dic;
|
||
}
|
||
|
||
private void button15_Click(object sender, EventArgs e)
|
||
{
|
||
//new SendCrmMsg().Send();
|
||
}
|
||
|
||
private void button16_Click(object sender, EventArgs e)
|
||
{
|
||
SecurityHelper sHelper = new SecurityHelper();
|
||
long mobile = 15100000700;
|
||
int carNo = 11600700;
|
||
for (int i = 700; i < 750; i++)
|
||
{
|
||
mobile++;
|
||
carNo++;
|
||
SyncRegUserModel activeModel = new SyncRegUserModel();
|
||
activeModel.campaignId = "26300";
|
||
activeModel.companyId = 500;
|
||
activeModel.mobile = "mobile";
|
||
activeModel.platform = "P";
|
||
activeModel.regDate = DateTime.Now;
|
||
activeModel.userCardNo = carNo.ToString();
|
||
activeModel.username = "cs00_" + i;
|
||
activeModel.mobile = mobile.ToString();
|
||
string json = Utility.ConvertToJSON<SyncRegUserModel>(activeModel);
|
||
json = sHelper.createSignEncodingStr(json);
|
||
string url = "http://192.168.1.45:806/ResourceService.svc/SyncRegUserChangSha";
|
||
string retmsg = Utility.PostData(url + "?" + json, Encoding.UTF8);
|
||
|
||
//Utility.GetStream(retmsg);
|
||
}
|
||
|
||
}
|
||
|
||
private void button17_Click(object sender, EventArgs e)
|
||
{
|
||
string num = textBox6.Text;
|
||
num = num.Replace("+86", "");
|
||
if (num.Length == 12 && num.StartsWith("01"))//长度必须是12位，且是01开头，必然是手机号，去除前面的0
|
||
{
|
||
num = num.Substring(num.Length - 11, 11);
|
||
}
|
||
else if (num.Length > 12)//大于12位的，取后面的11位
|
||
{
|
||
num = num.Substring(num.Length - 11, 11);
|
||
}//小于等于11的不做处理
|
||
textBox7.Text = num;
|
||
}
|
||
|
||
private void button19_Click(object sender, EventArgs e)
|
||
{
|
||
string url = "https://api.weixin.qq.com/cgi-bin/material/batchget_material?access_token=8T9Mtqz5nRLl1ZH5_wMzuEMnd92DUTXJUr9JcpyupwZVlO7R0ncj7uXpW-aTE_7vX4kmzTvvGjzFrrzNbDRHbGd7o7akfC6hkyJUvjlzAaOulgFVYZfNLpSlOneIYB4YIHYcAAAEDU";
|
||
SuCai sucai = new SuCai();
|
||
sucai.count = 20;
|
||
sucai.offset = 0;
|
||
sucai.type = "image";
|
||
string resultJson = RequestHelper.CreatePostGetString(url, JsonConvert.SerializeObject(sucai), null, "", Encoding.UTF8, null);
|
||
LogHelper.Info("返回值：" + resultJson);
|
||
}
|
||
|
||
private void button20_Click(object sender, EventArgs e)
|
||
{
|
||
try
|
||
{
|
||
string xxx = textBox5.Text;
|
||
web_push_wxUserServiceModel t = JsonConvert.DeserializeObject<web_push_wxUserServiceModel>(xxx);
|
||
DateTime time = DateTimeTool.GetTimeFromLinuxShortTime(t.SubscribeTime);
|
||
new WX_UserInfo_BL().weapp_userinfo_Storage(t.OpenId, t.NickName, t.Gender, t.Language, t.City, t.Province, t.Country, t.AvatarUrl, t.Type, t.UnionId, t.Subscribe, time, t.AccountNum);
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
|
||
}
|
||
}
|
||
|
||
private void button21_Click(object sender, EventArgs e)
|
||
{
|
||
try
|
||
{
|
||
string url = "http://192.168.1.132:7099/WxMessageSvr/AppletMsg?signature=697704691c8e3b8abe145eb28576411ec30bd54c×tamp=1501724222&nonce=1941521468";
|
||
string result = WebClientRequest(url, "{\"ToUserName\":\"gh_096d7b6a4e5e\",\"FromUserName\":\"oV5div1PbGhFRbCliW7tqJEA-sac\",\"CreateTime\":1501724222,\"MsgType\":\"text\",\"Content\":\"9999\",\"Event\":null,\"EventKey\":null,\"Ticket\":null,\"Latitude\":null,\"Longitude\":null,\"Precision\":null,\"MsgId\":6449856421516440225,\"PicUrl\":null,\"MediaId\":null}", Encoding.UTF8);
|
||
}
|
||
catch (Exception exx) { }
|
||
}
|
||
|
||
|
||
public static string WebClientRequest(string url, string postData, Encoding coding, string method = "POST")
|
||
{
|
||
WebClient webClient = new WebClient();
|
||
webClient.Encoding = coding;
|
||
webClient.Headers[HttpRequestHeader.ContentType] = "application/json";
|
||
string result = webClient.UploadString(url, method, postData.ToString());
|
||
return result;
|
||
}
|
||
/// <summary>
|
||
/// 提取数据库不存在数据
|
||
/// </summary>
|
||
/// <param name="sender"></param>
|
||
/// <param name="e"></param>
|
||
private void button22_Click(object sender, EventArgs e)
|
||
{
|
||
try
|
||
{
|
||
//初始化一个OpenFileDialog类
|
||
OpenFileDialog fileDialog = new OpenFileDialog();
|
||
|
||
//判断用户是否正确的选择了文件
|
||
if (fileDialog.ShowDialog() == DialogResult.OK)
|
||
{
|
||
//获取用户选择文件的后缀名
|
||
string extension = Path.GetExtension(fileDialog.FileName);
|
||
//声明允许的后缀名
|
||
string clientid = Utility.GetSettingByKey("CRMClientKey");
|
||
WX.CRM.IBLL.Util.ISecurityHelper sHelper = new SecurityHelper();
|
||
StreamReader sr = new StreamReader(fileDialog.FileName, Encoding.Default);
|
||
String line;
|
||
RES_RESOURCEMOBILE_BL mobilebl = new RES_RESOURCEMOBILE_BL();
|
||
List<string> phoneList = new List<string>();
|
||
Dictionary<string, string> dicc = new Dictionary<string, string>();
|
||
while ((line = sr.ReadLine()) != null)
|
||
{
|
||
try
|
||
{
|
||
string phone = line.ToString();
|
||
if (string.IsNullOrWhiteSpace(phone))
|
||
{
|
||
continue;
|
||
}
|
||
string resid = ResUtil.CreateResId(phone);
|
||
|
||
string nphone = mobilebl.GetNumberByResId(resid);//手机号解密
|
||
if (string.IsNullOrEmpty(nphone))
|
||
{
|
||
if (!dicc.ContainsKey(phone))
|
||
{
|
||
dicc.Add(phone, phone);
|
||
}
|
||
//phoneList.Add(phone);
|
||
}
|
||
}
|
||
catch (Exception sd)
|
||
{
|
||
}
|
||
}
|
||
|
||
|
||
SaveFileDialog saveFile1 = new SaveFileDialog();
|
||
saveFile1.Filter = "文本文件(.txt)|*.txt";
|
||
saveFile1.FilterIndex = 1;
|
||
if (saveFile1.ShowDialog() == System.Windows.Forms.DialogResult.OK && saveFile1.FileName.Length > 0)
|
||
{
|
||
System.IO.StreamWriter sw = new System.IO.StreamWriter(saveFile1.FileName, false);
|
||
try
|
||
{
|
||
foreach (var item in dicc)
|
||
{
|
||
sw.WriteLine(item.Key); //只要这里改一下要输出的内容就可以了
|
||
}
|
||
}
|
||
catch
|
||
{
|
||
throw;
|
||
}
|
||
finally
|
||
{
|
||
sw.Close();
|
||
}
|
||
}
|
||
|
||
}
|
||
}
|
||
catch (Exception exs)
|
||
{
|
||
}
|
||
|
||
}
|
||
|
||
private void button23_Click(object sender, EventArgs e)
|
||
{
|
||
try
|
||
{
|
||
string dir = "E:\\phone";
|
||
DirectoryInfo d = new DirectoryInfo(dir);
|
||
FileSystemInfo[] fsinfos = d.GetFileSystemInfos();
|
||
Dictionary<string, string> dic = new Dictionary<string, string>();
|
||
List<string> mobileList = new List<string>();
|
||
foreach (FileSystemInfo fsinfo in fsinfos)
|
||
{
|
||
string filename = fsinfo.FullName;//输出文件的全部路径
|
||
|
||
|
||
StreamReader sr = new StreamReader(filename, Encoding.Default);
|
||
String line;
|
||
while ((line = sr.ReadLine()) != null)
|
||
{
|
||
string phone = Utility.GetMobile(line.ToString());
|
||
if (string.IsNullOrWhiteSpace(phone))
|
||
{
|
||
continue;
|
||
}
|
||
if (!dic.ContainsKey(phone))
|
||
{
|
||
mobileList.Add(phone);
|
||
dic.Add(phone, phone);
|
||
}
|
||
}
|
||
}
|
||
SaveFileDialog saveFile1 = new SaveFileDialog();
|
||
saveFile1.Filter = "文本文件(.txt)|*.txt";
|
||
saveFile1.FilterIndex = 1;
|
||
if (saveFile1.ShowDialog() == System.Windows.Forms.DialogResult.OK && saveFile1.FileName.Length > 0)
|
||
{
|
||
System.IO.StreamWriter sw = new System.IO.StreamWriter(saveFile1.FileName, false);
|
||
try
|
||
{
|
||
foreach (var item in mobileList)
|
||
{
|
||
sw.WriteLine(ResUtil.CreateResId(item)); //只要这里改一下要输出的内容就可以了
|
||
}
|
||
}
|
||
catch
|
||
{
|
||
throw;
|
||
}
|
||
finally
|
||
{
|
||
sw.Close();
|
||
}
|
||
}
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
|
||
}
|
||
}
|
||
|
||
private void button24_Click(object sender, EventArgs e)
|
||
{
|
||
//初始化一个OpenFileDialog类
|
||
OpenFileDialog fileDialog = new OpenFileDialog();
|
||
|
||
//判断用户是否正确的选择了文件
|
||
if (fileDialog.ShowDialog() == DialogResult.OK)
|
||
{
|
||
//获取用户选择文件的后缀名
|
||
string extension = Path.GetExtension(fileDialog.FileName);
|
||
//声明允许的后缀名
|
||
StreamReader sr = new StreamReader(fileDialog.FileName, Encoding.Default);
|
||
String line;
|
||
List<string> mobileList = new List<string>();
|
||
while ((line = sr.ReadLine()) != null)
|
||
{
|
||
string phone = line.ToString();
|
||
|
||
if (string.IsNullOrWhiteSpace(phone))
|
||
{
|
||
continue;
|
||
}
|
||
//mobileList.Add(phone + "," + ResUtil.CreateResId(phone));
|
||
|
||
mobileList.Add(ResUtil.CreateResId(phone));
|
||
}
|
||
|
||
SaveFileDialog saveFile1 = new SaveFileDialog();
|
||
saveFile1.Filter = "文本文件(.txt)|*.txt";
|
||
saveFile1.FilterIndex = 1;
|
||
if (saveFile1.ShowDialog() == System.Windows.Forms.DialogResult.OK && saveFile1.FileName.Length > 0)
|
||
{
|
||
System.IO.StreamWriter sw = new System.IO.StreamWriter(saveFile1.FileName, false);
|
||
try
|
||
{
|
||
foreach (var item in mobileList)
|
||
{
|
||
sw.WriteLine(item); //只要这里改一下要输出的内容就可以了
|
||
}
|
||
}
|
||
catch
|
||
{
|
||
throw;
|
||
}
|
||
finally
|
||
{
|
||
sw.Close();
|
||
}
|
||
}
|
||
|
||
}
|
||
}
|
||
|
||
private void button25_Click(object sender, EventArgs e)
|
||
{
|
||
new ResTool.TS.TSSendRes().StartPush();
|
||
}
|
||
|
||
private void button26_Click(object sender, EventArgs e)
|
||
{
|
||
OpenFileDialog fileDialog = new OpenFileDialog();
|
||
|
||
//判断用户是否正确的选择了文件
|
||
if (fileDialog.ShowDialog() == DialogResult.OK)
|
||
{
|
||
//获取用户选择文件的后缀名
|
||
string extension = Path.GetExtension(fileDialog.FileName);
|
||
//声明允许的后缀名
|
||
StreamReader sr = new StreamReader(fileDialog.FileName, Encoding.Default);
|
||
String line;
|
||
List<string> mobileList = new List<string>();
|
||
while ((line = sr.ReadLine()) != null)
|
||
{
|
||
string phone = line.ToString();
|
||
|
||
if (string.IsNullOrWhiteSpace(phone))
|
||
{
|
||
continue;
|
||
}
|
||
//mobileList.Add(phone + "," + ResUtil.CreateResId(phone));
|
||
|
||
mobileList.Add(UserMd5(phone));
|
||
}
|
||
|
||
SaveFileDialog saveFile1 = new SaveFileDialog();
|
||
saveFile1.Filter = "文本文件(.txt)|*.txt";
|
||
saveFile1.FilterIndex = 1;
|
||
if (saveFile1.ShowDialog() == System.Windows.Forms.DialogResult.OK && saveFile1.FileName.Length > 0)
|
||
{
|
||
System.IO.StreamWriter sw = new System.IO.StreamWriter(saveFile1.FileName, false);
|
||
try
|
||
{
|
||
foreach (var item in mobileList)
|
||
{
|
||
sw.WriteLine(item); //只要这里改一下要输出的内容就可以了
|
||
}
|
||
}
|
||
catch
|
||
{
|
||
throw;
|
||
}
|
||
finally
|
||
{
|
||
sw.Close();
|
||
}
|
||
}
|
||
|
||
}
|
||
}
|
||
|
||
private string UserMd5(string str)
|
||
{
|
||
string cl = str;
|
||
string pwd = "";
|
||
MD5 md5 = MD5.Create();//实例化一个md5对像
|
||
// 加密后是一个字节类型的数组，这里要注意编码UTF8/Unicode等的选择
|
||
byte[] s = md5.ComputeHash(Encoding.UTF8.GetBytes(cl));
|
||
// 通过使用循环，将字节类型的数组转换为字符串，此字符串是常规字符格式化所得
|
||
for (int i = 0; i < s.Length; i++)
|
||
{
|
||
// 将得到的字符串使用十六进制类型格式。格式后的字符是小写的字母，如果使用大写（X）则格式后的字符是大写字符
|
||
pwd = pwd + s[i].ToString("x2");
|
||
}
|
||
return pwd;
|
||
}
|
||
|
||
|
||
private void button27_Click(object sender, EventArgs e)
|
||
{
|
||
string xxx = textBox1.Text;
|
||
if (IsNumber(xxx))
|
||
{
|
||
MessageBox.Show("数字!");
|
||
}
|
||
else
|
||
{
|
||
MessageBox.Show("非数字!");
|
||
}
|
||
}
|
||
|
||
/// <summary>
|
||
/// 判断字符串是否是数字
|
||
/// </summary>
|
||
public static bool IsNumber(string s)
|
||
{
|
||
if (string.IsNullOrWhiteSpace(s))
|
||
return false;
|
||
const string pattern = "^[0-9]*$";
|
||
Regex rx = new Regex(pattern);
|
||
return rx.IsMatch(s);
|
||
}
|
||
|
||
private void button28_Click(object sender, EventArgs e)
|
||
{
|
||
//初始化一个OpenFileDialog类
|
||
OpenFileDialog fileDialog = new OpenFileDialog();
|
||
|
||
//判断用户是否正确的选择了文件
|
||
if (fileDialog.ShowDialog() == DialogResult.OK)
|
||
{
|
||
//获取用户选择文件的后缀名
|
||
string extension = Path.GetExtension(fileDialog.FileName);
|
||
//声明允许的后缀名
|
||
string clientid = Utility.GetSettingByKey("CRMClientKey");
|
||
ISecurityHelper sHelper = new SecurityHelper();
|
||
StreamReader sr = new StreamReader(fileDialog.FileName, Encoding.Default);
|
||
List<ResInitInfo> list = new List<ResInitInfo>();
|
||
String line;
|
||
string mobile = string.Empty;
|
||
while ((line = sr.ReadLine()) != null)
|
||
{
|
||
mobile = line.Trim();
|
||
//if (string.IsNullOrWhiteSpace(mobile))
|
||
//{
|
||
// continue;
|
||
//}
|
||
|
||
var resInfo = new ResInitInfo
|
||
{
|
||
CNumber = sHelper.encyptData(clientid, mobile),
|
||
//CNumber = string.Empty,
|
||
ResId = ResUtil.CreateResId(mobile),
|
||
//ResId = string.Empty,
|
||
CustomerFrom = "Z0001001",
|
||
ECNumber = Utility.NumberFormat(mobile)
|
||
};
|
||
|
||
list.Add(resInfo);
|
||
|
||
}
|
||
|
||
//new OracleBulk_DAL().OracleBulkInsert("A_RES_INIT", Utility.ToOracleDataTable(list));
|
||
OracleHelper.OracleBulkInsert("A_RES_INIT", Utility.ToOracleDataTable(list));
|
||
MessageBox.Show("执行完成");
|
||
|
||
}
|
||
}
|
||
|
||
private void button29_Click(object sender, EventArgs e)
|
||
{
|
||
//初始化一个OpenFileDialog类
|
||
OpenFileDialog fileDialog = new OpenFileDialog();
|
||
|
||
//判断用户是否正确的选择了文件
|
||
if (fileDialog.ShowDialog() == DialogResult.OK)
|
||
{
|
||
StreamReader sr = new StreamReader(fileDialog.FileName, Encoding.Default);
|
||
String line;
|
||
string mobile = string.Empty;
|
||
while ((line = sr.ReadLine()) != null)
|
||
{
|
||
mobile = line.Trim();
|
||
//if (string.IsNullOrWhiteSpace(mobile))
|
||
//{
|
||
// continue;
|
||
//}
|
||
if (!Utility.ChekMobile(mobile))
|
||
{
|
||
MessageBox.Show(mobile);
|
||
}
|
||
|
||
}
|
||
|
||
}
|
||
}
|
||
|
||
private void button30_Click(object sender, EventArgs e)
|
||
{
|
||
var path = @"C:\Users\Administrator\Desktop\22.jpg";
|
||
WebClient wc = new WebClient();
|
||
wc.Credentials = CredentialCache.DefaultCredentials;
|
||
wc.Headers.Add("Content-Type", "application/x-www-form-urlencoded");
|
||
wc.QueryString["fileName"] = "22.jpg";
|
||
byte[] buffer = wc.UploadFile(new Uri(@"http://192.168.1.132:8099/WxFileUpload2.ashx"), "POST", path);
|
||
|
||
var msg = Encoding.UTF8.GetString(buffer);
|
||
MessageBox.Show(msg);
|
||
}
|
||
|
||
private void button31_Click(object sender, EventArgs e)
|
||
{
|
||
var url = "/audio/439a71df5d8d41cf2fb84bdee1acb6b9.amr";
|
||
//var url = "/audio/439a71df5d8d41cf2fb84bdee1acb6b9.amr";
|
||
var webPath = Path.Combine(FileUnit.GetBaseDirectory(), "audio");
|
||
var exePath = Path.Combine(FileUnit.GetBaseDirectory(), "silk2mp3");
|
||
var fileNameWithoutExt = Path.GetFileNameWithoutExtension(url);
|
||
var armPath = Path.Combine(webPath, "439a71df5d8d41cf2fb84bdee1acb6b9.amr");
|
||
var targetFileNamePcm = Path.Combine(webPath, fileNameWithoutExt + ".pcm");
|
||
var targetFileNameMp3 = Path.Combine(webPath, fileNameWithoutExt + ".mp3");
|
||
if (!System.IO.File.Exists(targetFileNameMp3))
|
||
{
|
||
SilkConvertToMp3 amr = new SilkConvertToMp3();
|
||
amr.ConvertToPcm(exePath, armPath, targetFileNamePcm);
|
||
//amr.ConvertToMp3(exePath, targetFileNamePcm, targetFileNameMp3);
|
||
if (System.IO.File.Exists(targetFileNamePcm))
|
||
{
|
||
amr.ConvertToMp3(exePath, targetFileNamePcm, targetFileNameMp3);
|
||
}
|
||
else
|
||
{
|
||
amr.ConvertAmrToMp3(exePath, armPath, targetFileNameMp3);
|
||
}
|
||
}
|
||
MessageBox.Show("ok");
|
||
}
|
||
|
||
private void button32_Click(object sender, EventArgs e)
|
||
{
|
||
//string enkey = WX.CRM.Common.Utility.GetSettingByKey("CRMClientKey");
|
||
var enkey = "UPWEBSITE";
|
||
var clientid = WX.Interface.Security.ClientKey.GetClientKey(enkey);
|
||
var sHelper = new WX.Interface.Security.EncDecUtil();
|
||
var result = sHelper.encyptData(textBox8.Text, clientid.AccessKey);
|
||
textBox9.Text = result;
|
||
}
|
||
|
||
private void button33_Click(object sender, EventArgs e)
|
||
{
|
||
//string enkey = WX.CRM.Common.Utility.GetSettingByKey("CRMClientKey");
|
||
var enkey = "UPWEBSITE";
|
||
//var enkey = "TDORDERSITE";
|
||
var clientid = WX.Interface.Security.ClientKey.GetClientKey(enkey);
|
||
var sHelper = new WX.Interface.Security.EncDecUtil();
|
||
var result = sHelper.decyptData(textBox8.Text, clientid.AccessKey);
|
||
textBox9.Text = result;
|
||
}
|
||
|
||
private void button34_Click(object sender, EventArgs e)
|
||
{
|
||
var d1 = dateTimePicker1.Value.ToShortDateString();
|
||
var d2 = dateTimePicker2.Value.ToShortDateString();
|
||
var sql = "select distinct FileName,FileUrl from wx_filepath where CTime >= '" + d1 + "' and CTime < '" + d2 + "' and FileName not like 'wx:-%'";
|
||
var ds = SqlHelper.Query(SqlHelper.DatabaseType.AYCRM, sql);
|
||
var dt = ds.Tables[0];
|
||
|
||
var dic = new Dictionary<string, string>();
|
||
foreach (DataRow item in dt.Rows)
|
||
{
|
||
//RedisString<string> redis = new RedisString<string>("wx:" + item[0].ToString());
|
||
//redis.Set(item[1].ToString());
|
||
if (!dic.ContainsKey(item[0].ToString()))
|
||
{
|
||
dic.Add(item[0].ToString(), item[1].ToString());
|
||
}
|
||
}
|
||
var db = new RedisString<string>();
|
||
var result = db.StringBatch(dic);
|
||
MessageBox.Show(result ? "执行成功" : "执行失败");
|
||
|
||
}
|
||
|
||
private void button35_Click(object sender, EventArgs e)
|
||
{
|
||
//var d1 = dateTimePicker1.Value.ToShortDateString();
|
||
//var d2 = dateTimePicker2.Value.ToShortDateString();
|
||
|
||
try
|
||
{
|
||
var dd = dateTimePicker1.Value;
|
||
var dd2 = dateTimePicker2.Value;
|
||
|
||
while (true)
|
||
{
|
||
if (dd2.Year < dd.Year)
|
||
{
|
||
MessageBox.Show("时间选择错误！");
|
||
break;
|
||
}
|
||
|
||
var yearMonth = dd.ToString("yyyyMM");
|
||
var sql = "select m.msgSvrId,m.username from wx_message" + yearMonth + " m where exists(select 1 from a_username3 a where a.username = m.username)";
|
||
MessageBox.Show(sql);
|
||
var ds = SqlHelper.Query(SqlHelper.DatabaseType.AYCRM, sql);
|
||
var dt = ds.Tables[0];
|
||
var fix = "wxmsgid:";
|
||
var dic = new Dictionary<string, string>();
|
||
foreach (DataRow item in dt.Rows)
|
||
{
|
||
var key = fix + item[0].ToString() + "|" + item[1].ToString();
|
||
if (!dic.ContainsKey(key))
|
||
{
|
||
dic.Add(key, string.Empty);
|
||
}
|
||
}
|
||
var db = new RedisString<string>();
|
||
var result = db.StringBatch(dic);
|
||
MessageBox.Show(result ? "执行成功" : "执行失败");
|
||
if (dd2.Year > dd.Year)
|
||
{
|
||
dd = dd.AddMonths(1);
|
||
}
|
||
else if (dd2.Year == dd.Year)
|
||
{
|
||
if (dd2.Month > dd.Month)
|
||
{
|
||
dd = dd.AddMonths(1);
|
||
}
|
||
else
|
||
{
|
||
break;
|
||
}
|
||
}
|
||
else
|
||
{
|
||
MessageBox.Show("时间选择错误！");
|
||
}
|
||
}
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
LogHelper.Error(ex.ToString());
|
||
}
|
||
|
||
|
||
//var sql = "select msgSvrId,username from wx_gen_message where cTime >= '" + d1 + "' and cTime < '" + d2 + "'";
|
||
//var ds = SqlHelper.Query(SqlHelper.DatabaseType.AYCRM, sql);
|
||
//var dt = ds.Tables[0];
|
||
//var fix = "wxmsgid:";
|
||
//var dic = new Dictionary<string, string>();
|
||
//foreach (DataRow item in dt.Rows)
|
||
//{
|
||
// var key = fix + item[0].ToString() + "|" + item[1].ToString();
|
||
// if (!dic.ContainsKey(key))
|
||
// {
|
||
// dic.Add(key, string.Empty);
|
||
// }
|
||
//}
|
||
//var db = new RedisString<string>();
|
||
//var result = db.StringBatch(dic);
|
||
//MessageBox.Show(result ? "执行成功" : "执行失败");
|
||
|
||
|
||
}
|
||
|
||
private void button36_Click(object sender, EventArgs e)
|
||
{
|
||
//var _url = "http://192.168.1.68/goip_post_sms.html?username=root&password=root";
|
||
//var _url = "http://localhost:10229/WebTest";
|
||
var _url = "http://localhost:10229/WebTest";
|
||
|
||
var para = "{\"type\":\"send-sms\",\"task_num\":1,\"tasks\":[{\"tid\":1,\"from\":\"1\",\"to\":\"13416115228\",\"sms\":\"测试短信\"}]}";
|
||
|
||
HttpWebRequest request = null;
|
||
request = WebRequest.Create(_url) as HttpWebRequest;
|
||
request.Method = "POST";
|
||
request.ContentType = "application/json;charset=utf-8";
|
||
// request.ContentType = "application/json";
|
||
//如果需要POST数据
|
||
if (!string.IsNullOrEmpty(para))
|
||
{
|
||
byte[] data = Encoding.UTF8.GetBytes(para.ToString());
|
||
request.ContentLength = data.Length;
|
||
using (Stream stream = request.GetRequestStream())
|
||
{
|
||
stream.Write(data, 0, data.Length);
|
||
}
|
||
}
|
||
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
|
||
{
|
||
StreamReader reader = new StreamReader(response.GetResponseStream(), Encoding.UTF8);
|
||
string result = reader.ReadToEnd();
|
||
MessageBox.Show(result);
|
||
}
|
||
}
|
||
|
||
private void button37_Click(object sender, EventArgs e)
|
||
{
|
||
SecurityHelper sHelper = new SecurityHelper();
|
||
//string clientid = "TDORDERSITE";
|
||
//string content = "WSMG984VTfIWoRsi/ip/7AVY8/oVwxnwhqM/kUdhN14wDPsOJMK9JRagEp95wJVWSuKiy0UWosnvxKhKBuo6+rMUTQ1IN2GaP1IdMC2aBT/1y7uXZc4SDFm+uWiudBG/TNYbl0muM7i3QhxAFZJMjWljlvMZ8JP1opU1U5j0jOIBqypxyGVhX+ix89ZRnXlNb7sLccOg3DU=";
|
||
var clientid = "UPWEBSITE";
|
||
var content = "delvAlmupXkNIYzx75OcSzeE8\\/t07dG3IqLY0reM\\/plP1nV37r4r2A==";
|
||
//content = HttpUtility.UrlDecode(content);
|
||
content = sHelper.decyptData(clientid, content); //解密操作
|
||
MessageBox.Show(content);
|
||
}
|
||
|
||
private void button38_Click(object sender, EventArgs e)
|
||
{
|
||
string regmobile = "008613709440178";
|
||
regmobile = regmobile.Substring(4);
|
||
return;
|
||
|
||
try
|
||
{
|
||
//string url = "https://r2.soft.tcfortune.com/order/scgi/create_order";
|
||
////string json = "{\"sProductId\=\"UPCFJC_20181101170549\",\"sUserName\=\"qbj\",\"iCount\=1,\"iBusType\=1,\"iCH\=21001,\"iPlat\=0,\"iSource\=1,\"iProductType\=1,\"sCouponCode\=null,\"sMobile\=\"15112168561\",\"sIP\=null,\"iTotalprice\=5600000,\"iTotaldays\=365,\"sExt1\=null,\"flag\=null,\"sCssId\=\"600000207\",\"iOriginalCH\=0,\"iCurrentCH\=21001,\"iAppversion\=null,\"sSignId\=null,\"iComplianceFlag\=0,\"sProtocolType\=null,\"sXua\=null,\"sGuid\=null}";
|
||
//string xx = "sProductId=UPCFJC_20181101170549&sUserName=qbj&iCount=1&iBusType=1&iCH=21001&iPlat=0&iSource=1&iProductType=1&sCouponCode=&sMobile=15112168561&sIP=null&iTotalprice=5600000&iTotaldays=365&sExt1=&flag=null&sCssId=600000207&iOriginalCH=0&iCurrentCH=21001&iAppversion=&sSignId=&iComplianceFlag=0&sProtocolType=&sXua=&sGuid=";
|
||
//string xx2 = "sProductId=UPCFJC_20181101170549&sUserName=qbj&iCount=1&iBusType=1&iCH=21001&iPlat=0&sMobile=15112168561";
|
||
//string xx3 = "productId=UPCFJC_20181101170549&userName=qbj&count=1&busType=1&ch=21001&plat=0&source=1&productType=1&couponCode=&mobile=15112168561&ip=&totalPrice=5600000&totalDays=365&ext1=&flag=&cssId=600000207&originalCH=0¤tCH=21001&appversion=&signId=&complianceFlag=0&protocolType=&xua=&guid=";
|
||
//string retmsg = Utility.GetData(url, xx3, Encoding.UTF8);//返回信息
|
||
|
||
|
||
|
||
//string url = "https://r2.soft.tcfortune.com/order/cgi/open_order";
|
||
//string json = "{\"sProductId\=\"UPCFJC_20181101170549\",\"sUserName\=\"qbj\",\"iCount\=1,\"iBusType\=1,\"iCH\=21001,\"iPlat\=0,\"iSource\=1,\"iProductType\=1,\"sCouponCode\=null,\"sMobile\=\"15112168561\",\"sIP\=null,\"iTotalprice\=5600000,\"iTotaldays\=365,\"sExt1\=null,\"flag\=null,\"sCssId\=\"600000207\",\"iOriginalCH\=0,\"iCurrentCH\=21001,\"iAppversion\=null,\"sSignId\=null,\"iComplianceFlag\=0,\"sProtocolType\=null,\"sXua\=null,\"sGuid\=null}";
|
||
//string xx4 = "orderId=1837211062110711&payId=1&=payType=1&payPrice=5600000&userName=qbj&couponCode=&isFree=0&payRemark=";
|
||
|
||
//string retmsg = Utility.GetData(url, xx4, Encoding.UTF8);//返回信息
|
||
SecurityHelper sHelper = new SecurityHelper();
|
||
//string url = "https://r2.soft.tcfortune.com/order/scgi/refund_order";
|
||
//string json = "{\"orderId\":\"xxdsdf码数的法定\"}";
|
||
//string clientid = "UPWEBSITE";
|
||
//string njson= sHelper.encyptData(clientid,json);
|
||
|
||
|
||
//json = sHelper.createSignEncodingStr(json, SecurityHelper.OrderClientIdKey);//数据参数加密
|
||
//string retmsg = Utility.PostData(url + "?" + json, Encoding.UTF8);//实现中心点先入库
|
||
|
||
|
||
//string contentUrlEncode = HttpUtility.UrlEncode(content, Encoding.UTF8);
|
||
|
||
//string signUrlEncode = HttpUtility.UrlEncode(sign, Encoding.UTF8);
|
||
|
||
//重置密码
|
||
//string url = "https://r2.soft.tcfortune.com/order/scgi/reset_pwd";
|
||
//string clientid = "UPWEBSITE";
|
||
//string json = "{\"userName\":\"qbj86ddd\"}";
|
||
//string content = sHelper.encyptData(clientid, json);
|
||
//string sign = sHelper.signData(clientid, content);
|
||
////bool sss=sHelper.CheckClientValid("UPWEBSITE", "8fYIIKMSFVyhEi1vhWbLOis3Et9DdiYcE/AO/k9FWIY/69V3t4xIkI15n7EGgQSKvRt0EcVULoqnUU6fdODg6fP7tr42Tyr2yInFxJxGkGHNmhNxju+ZvttUEWffqislhlItcHSESCR3SaYST9lvyeDkZ8WRW+umF4QGiq1td5x0egulF4kc4Q==", "+4GPl6YoN30T4X1Bcbvoyg==");
|
||
//var maxjson = new
|
||
//{
|
||
// content = content,
|
||
// clientId = clientid,
|
||
// sign = sign
|
||
//};
|
||
//string retmss = Utility.PostAjaxData(url, ObjDivertToJson(maxjson), Encoding.UTF8);
|
||
|
||
|
||
|
||
//风控加密测试
|
||
//long longtime = DateTimeTool.ConvertDateTimeLong(DateTime.Now);
|
||
//string url = "https://r2.soft.tcfortune.com/riskevaluate/pc/newcenter/risk.html?hqr=";
|
||
//var json = new
|
||
//{
|
||
// uid = "qbj104",
|
||
// cid = "",
|
||
// t = longtime,
|
||
// hqrtime = longtime,
|
||
// rd = 8086,
|
||
// u = "0",
|
||
// r = "[]"
|
||
//};
|
||
//string varx = HttpUtility.UrlEncode(BlowFish.decode(ObjDivertToJson(json)));
|
||
//url = url + varx;
|
||
|
||
|
||
//===合同解密测试
|
||
|
||
//string content = HttpUtility.UrlDecode("Tze8bh50CYemAC577SJtzDFM%2Bztwn5KL");
|
||
//string xxxs = sHelper.decyptData("UPWEBSITE", content);
|
||
|
||
|
||
//合同生成URL测试
|
||
//string url = "https://r2.soft.tcfortune.com/contract_sign_crm/signcontract" +
|
||
// "";
|
||
//var json = new
|
||
//{
|
||
// productName = "趋势锦囊",
|
||
// period = "365天",
|
||
// price = "56000.00元",
|
||
// userId = "qbj104",
|
||
// productLevel = 1,
|
||
// productInvestTime = 1,
|
||
// productInvestType = 1,
|
||
// issupplement = 1,
|
||
// orderId = "1837211142111812",
|
||
// htid = "UP1837211142111812"
|
||
//};
|
||
|
||
//string clientid = "UPWEBSITE";
|
||
//string content = sHelper.encyptData(clientid, ObjDivertToJson(json));
|
||
//string sign = sHelper.signData(clientid, content);
|
||
//bool sss=sHelper.CheckClientValid("UPWEBSITE", "8fYIIKMSFVyhEi1vhWbLOis3Et9DdiYcE/AO/k9FWIY/69V3t4xIkI15n7EGgQSKvRt0EcVULoqnUU6fdODg6fP7tr42Tyr2yInFxJxGkGHNmhNxju+ZvttUEWffqislhlItcHSESCR3SaYST9lvyeDkZ8WRW+umF4QGiq1td5x0egulF4kc4Q==", "+4GPl6YoN30T4X1Bcbvoyg==");
|
||
//var maxjson = new
|
||
//{
|
||
// content = content,
|
||
// clientId = clientid,
|
||
// sign = sign,
|
||
// protocolType=""
|
||
//};
|
||
//url = url + string.Format("?content={0}&sign={1}&clientId={2}&protocolType=", HttpUtility.UrlEncode(content), HttpUtility.UrlEncode(sign), clientid);
|
||
|
||
|
||
|
||
|
||
//合同pdf测试
|
||
//string url = "https://r2.soft.tcfortune.com/contract/contractdetail/趋势锦囊-风险揭示书.pdf?content={0}&sign={1}&clientId=UPWEBSITE";
|
||
//string content = sHelper.encyptData(clientid, "R_UP1837211142111317");
|
||
//string sign = sHelper.signData(clientid, content);
|
||
//string xx = string.Format(url, HttpUtility.UrlEncode(content), HttpUtility.UrlEncode(sign));
|
||
//string a1= sHelper.decyptData(clientid, HttpUtility.UrlDecode("Tze8bh50CYemAC577SJtzDFM%2Bztwn5KL"));
|
||
// string a2 = sHelper.decyptData(clientid, HttpUtility.UrlDecode("nPB2qKomfqPECw4O096vKphrDoAwnfMq"));
|
||
// string a3 = sHelper.decyptData(clientid, HttpUtility.UrlDecode("8OlpqiyQiM7Hwrty97JEeC19%2Fq2BS8lW"));
|
||
|
||
|
||
//订单车查询接口测试
|
||
/*{ "retCode":10000,
|
||
"retMsg":"Success",
|
||
"stOrderInfo":{
|
||
"orderid":"1837211072111016",
|
||
"username":"qbj",
|
||
"productid":"UPCFJC_20181101170549",
|
||
"count":1,
|
||
"totaldays":365,
|
||
"totalprice":0,
|
||
"mobile":"",
|
||
"status":220,
|
||
"isrefund":0,
|
||
"bustype":1,
|
||
"source":2,
|
||
"plat":0,
|
||
"ch":21001,
|
||
"couponid":"",
|
||
"ip":"172.18.10.70",
|
||
"cancelinfo":{
|
||
"canceluser":"",
|
||
"canceltime":0,
|
||
"cancelAmount":0
|
||
},
|
||
"ctime":1541567634,
|
||
"ext1":"{\"isFree\":1,\"business_name\":\"趋势锦囊\",\"business_type\":0,\"tradetype\":1,\"payeename\":\"\",\"payerno\":\"20000001\"}","producttype":0,"flag":"","otime":1541567634,"productname":"趋势锦囊"
|
||
}
|
||
}*/
|
||
/*
|
||
{"retCode":10000,
|
||
"retMsg":"Success",
|
||
"stOrderInfo":{
|
||
"orderid":"1837211122111315",
|
||
"username":"qbj102",
|
||
"productid":"UPCFJC_20181101170549",
|
||
"count":1,
|
||
"totaldays":365,
|
||
"totalprice":5600000,
|
||
"mobile":"15112168564",
|
||
"status":220,
|
||
"isrefund":0,
|
||
"bustype":1,
|
||
"source":1,
|
||
"plat":0,
|
||
"ch":21011,
|
||
"couponid":"",
|
||
"ip":"120.197.36.210",
|
||
"cancelinfo":{
|
||
"canceluser":"",
|
||
"canceltime":0,
|
||
"cancelAmount":0
|
||
},"
|
||
ctime":1542012074,
|
||
"ext1":"{\"business_name\":\"趋势锦囊\",\"business_type\":0,\"tradetype\":1,\"payeename\":\"\",\"payerno\":\"20000022\"}","producttype":0,"flag":"","otime":1542021906,"productname":"趋势锦囊"
|
||
}
|
||
}
|
||
*/
|
||
|
||
|
||
|
||
|
||
#region 绑定，解绑手机
|
||
//var dto = new ResetMobileDto() { username = "up0000022", type = 1, oldmobile = "13416115229", newmobile = "" };//解绑
|
||
////var dto = new ResetMobileDto() { username = "up0000022", type = 0, oldmobile = "", newmobile = "13416115228" };//绑定
|
||
////var dto = new ResetMobileDto() { username = "up0000022", type = 2, oldmobile = "13416115228", newmobile = "13416115229" };//修改
|
||
|
||
//string url = "http://47.107.128.102:8096/ResourceService.svc/User/ResetMobile";
|
||
//string json = Utility.ObjectToJson(dto);
|
||
|
||
////string retmss = Utility.PostData(url, ObjDivertToJson(maxjson), Encoding.UTF8);
|
||
//var para = sHelper.createSignEncodingStr(json);
|
||
|
||
//var retmss = Utility.PostData(url + "?" + para, Encoding.UTF8);
|
||
|
||
//MessageBox.Show(retmss);
|
||
#endregion
|
||
//var dto = new { appid = "443", appuserid = "881", sceneid = "4", scenetype = 1, eventid = 8, eventmemo = "{\"title\":\"222\"}", ctime = "2020-01-01 12:09:11", ip = "192.168.1.9" };
|
||
//string url = "http://127.0.0.1:3001/actionlog/scgi/actionLogEnter";
|
||
//string json = Utility.ObjectToJson(dto);
|
||
//var para = sHelper.createSignEncodingStr(json);
|
||
//var retmss = Utility.PostData(url + "?" + para, Encoding.UTF8);
|
||
|
||
|
||
//var dto = { eid=60005","ch":"2001","campaignId":"17","mobile":"15112168410","username":"UPCFJC_20191220"};
|
||
string url = "http://zxd.txcfgl.net/ResourceService.svc/Join";
|
||
string json = "{\"eid\":\"60005\",\"ch\":\"2001\",\"campaignId\":\"17\",\"mobile\":\"15112168410\",\"username\":\"UPCFJC_20191220\"}";
|
||
var para = sHelper.createSignEncodingStr(json);
|
||
var retmss = Utility.PostData(url + "?" + para, Encoding.UTF8);
|
||
var retmsg = sHelper.decyptData(SecurityHelper.OrderClientIdKey, retmss);
|
||
MessageBox.Show(retmsg);
|
||
}
|
||
catch (Exception xx)
|
||
{
|
||
|
||
}
|
||
}
|
||
public string ObjDivertToJson(object obj)
|
||
{
|
||
ScriptingJsonSerializationSection section = ConfigurationManager.GetSection("system.web.extensions/scripting/webServices/jsonSerialization") as ScriptingJsonSerializationSection;
|
||
|
||
JavaScriptSerializer script = new JavaScriptSerializer();
|
||
script.MaxJsonLength = section != null ? section.MaxJsonLength : int.MaxValue;
|
||
string json = script.Serialize(obj);
|
||
return json;
|
||
}
|
||
|
||
private void BtnHt_Click(object sender, EventArgs e)
|
||
{
|
||
try
|
||
{
|
||
#region 删除合同，可以重签
|
||
if (string.IsNullOrWhiteSpace(TxtHt.Text))
|
||
{
|
||
MessageBox.Show("软件用户名不能为空！");
|
||
return;
|
||
}
|
||
var dto = new { uid = TxtHt.Text.Trim() };
|
||
|
||
var url = "https://r2.soft.tcfortune.com/riskevaluate/pc/newcenter/del_risk";
|
||
|
||
var json = Utility.ObjectToJson(dto);
|
||
|
||
var para = new SecurityHelper().createSignEncodingStr(json);
|
||
|
||
//MessageBox.Show(url + "?" + para);
|
||
|
||
var retmss = Utility.PostData(url, para, Encoding.UTF8);
|
||
|
||
MessageBox.Show(retmss);
|
||
#endregion
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
MessageBox.Show(ex.ToString());
|
||
}
|
||
}
|
||
|
||
private void BtnOrderCreate_Click(object sender, EventArgs e)
|
||
{
|
||
var upgradeOrderList = new List<OrderInfo>();
|
||
upgradeOrderList.Add(new OrderInfo() { orderid = "1840301162998518" });
|
||
upgradeOrderList.Add(new OrderInfo() { orderid = "1840301162998417" });
|
||
|
||
//需要修改productId，productType，totalPrice，totalDays，看情况ext1是否需要
|
||
CreateOrderReq suorder = new CreateOrderReq
|
||
{
|
||
productId = "UPCFZH_20190102160303",
|
||
//productId = "UPCFJC_20181119180241",
|
||
userName = "up0000022",//软件用户名
|
||
count = 1,//产品数量
|
||
busType = 1,//
|
||
ch = 5001,
|
||
source = 1,
|
||
productType = 1,//0-单一产品、1-组合产品
|
||
mobile = "13416115228",//手机号码
|
||
totalPrice = 5800 * 100,//价格用分作为结算
|
||
//totalPrice = 99 * 100,//价格用分作为结算
|
||
//complianceFlag = 1,//合规
|
||
//signId = "",
|
||
totalDays = 180,
|
||
cssId = "10000",
|
||
currentCH = 5001,
|
||
ip = "127.0.0.1"
|
||
//ext1 = "{\"upgradeOrderList\": " + upgradeOrderList.ToJson() + " }"
|
||
,
|
||
ext1 = (new { upgradeOrderList }).ToJson()
|
||
};
|
||
|
||
var url = "https://r2.soft.tcfortune.com/order/scgi/create_order";//付费订单接口
|
||
|
||
string json = JsonHelper.ObjDivertToJson(suorder);
|
||
LogHelper.Info("Node.JS接口参数json=>:" + json);
|
||
|
||
json = JsonHelper.ObjDivertToJson(new SecurityHelper().createAjaxSignEncodingStr(JsonHelper.ObjDivertToJson(suorder), "UPWEBSITE"));
|
||
string retmsg = Utility.PostAjaxData(url, json, Encoding.UTF8);//返回信息
|
||
|
||
LogHelper.Info("Node.JS接口返回数据json=>:" + retmsg);
|
||
//retmsg = sHelper.decyptData(SecurityHelper.OrderClientIdKey, retmsg);
|
||
|
||
CreateOrderRsp retmessage = JsonHelper.JsonDivertToObj<CreateOrderRsp>(retmsg);
|
||
|
||
LogHelper.Info("创建订单返回结果：" + retmessage.ToJson());
|
||
MessageBox.Show(retmessage.retCode.ToString());
|
||
|
||
if (retmessage.retCode == 10000)
|
||
{
|
||
//LogHelper.Info("====调用NodeJs创建订单===");
|
||
//CreateOrderReq suorder2 = new CreateOrderReq
|
||
//{
|
||
// productId = ordermodel.productcode,
|
||
// userName = "up0000022",
|
||
// count = 1,//产品数量
|
||
// busType = 1,//
|
||
// ch = 5001,
|
||
// source = 1,
|
||
// productType = 0,//0-单一产品、1-组合产品
|
||
// mobile = "13416115228",//手机号码
|
||
// totalPrice = Convert.ToInt32(ordermodel.needpay.Value * 100),//价格用分作为结算
|
||
// totalDays = ordermodel.opendays.HasValue ? Convert.ToInt32(ordermodel.opendays.Value) : 0,
|
||
// cssId = "10000",
|
||
// currentCH = 5001,
|
||
// ip = "127.0.0.1"//获取客户端IP
|
||
//};
|
||
|
||
//var url2 = "https://r2.soft.tcfortune.com/order/scgi/create_open_free";//封装出来的接口
|
||
|
||
|
||
//var json2 = JsonHelper.ObjDivertToJson(new SecurityHelper().createAjaxSignEncodingStr(JsonHelper.ObjDivertToJson(suorder2), SecurityHelper.OrderClientIdKey));
|
||
//var retmsg2 = Utility.PostAjaxData(url2, json2, Encoding.UTF8);//返回信息
|
||
|
||
//CreateOrderRsp retmessage2 = JsonHelper.JsonDivertToObj<CreateOrderRsp>(retmsg2);
|
||
|
||
//LogHelper.Info("免费订单返回结果：" + retmessage2.ToJson());
|
||
}
|
||
else
|
||
{
|
||
LogHelper.Error("retmessage:" + retmsg);//记录下单不成功
|
||
}
|
||
}
|
||
|
||
private void BtnReg_Click(object sender, EventArgs e)
|
||
{
|
||
#region 重新注册
|
||
//内容:{"username":"fc75678117","password":"3833933103","mobile":"13975678117","ch":2100,"plat":0,"ip":"222.246.85.200","clientip":"222.246.85.200","eid":"天60019","regDate":1545988981838}
|
||
//var user = new
|
||
//{
|
||
// username = "test004",
|
||
// password = "test004",
|
||
// mobile = "13800138004",
|
||
// ch = 1000,
|
||
// plat = 0,
|
||
// ip = "171.113.85.239",
|
||
// clientip = "171.113.85.239",
|
||
// eid = "8888",
|
||
// regDate = 1583762241181
|
||
//};
|
||
|
||
var user = new
|
||
{
|
||
username = "dndev161",
|
||
password = "123qwe123",
|
||
mobile = "15625009257",
|
||
channel = 1000,
|
||
curChannel = 1000,
|
||
plat = 0,
|
||
ip = "192.168.91.238",
|
||
clientip = "192.168.91.238",
|
||
regDate = 1624430678384,
|
||
eid = "",
|
||
unionId = "",
|
||
refeid = "123456",
|
||
liveCode = "",
|
||
regSource = "soft_reg"
|
||
};
|
||
|
||
string url = "http://192.168.11.46:8096/ResourceService.svc/User/SyncReg";
|
||
|
||
var para = new SecurityHelper().createSignEncodingStr(user.ToJson());
|
||
|
||
//string retmss = Utility.PostData(url + "?" + para, Encoding.UTF8);
|
||
|
||
MessageBox.Show(para);
|
||
|
||
#endregion
|
||
}
|
||
|
||
private void GetOrderInfo_Click(object sender, EventArgs e)
|
||
{
|
||
SecurityHelper sHelper = new SecurityHelper();
|
||
string url = "https://r2.soft.tcfortune.com/order/scgi/get_order";
|
||
string clientid = "UPWEBSITE";
|
||
string json = "{\"orderId\":\"2282301163013114\"}";
|
||
string content = sHelper.encyptData(clientid, json);
|
||
string sign = sHelper.signData(clientid, content);
|
||
//bool sss = sHelper.CheckClientValid("UPWEBSITE", "8fYIIKMSFVyhEi1vhWbLOis3Et9DdiYcE/AO/k9FWIY/69V3t4xIkI15n7EGgQSKvRt0EcVULoqnUU6fdODg6fP7tr42Tyr2yInFxJxGkGHNmhNxju+ZvttUEWffqislhlItcHSESCR3SaYST9lvyeDkZ8WRW+umF4QGiq1td5x0egulF4kc4Q==", "+4GPl6YoN30T4X1Bcbvoyg==");
|
||
var maxjson = new
|
||
{
|
||
content = content,
|
||
clientId = clientid,
|
||
sign = sign
|
||
};
|
||
string retmss = Utility.PostAjaxData(url, ObjDivertToJson(maxjson), Encoding.UTF8);
|
||
|
||
MessageBox.Show(retmss);
|
||
|
||
LogHelper.Info(retmss);
|
||
|
||
}
|
||
|
||
private void OpenOrder_Click(object sender, EventArgs e)
|
||
{
|
||
try
|
||
{
|
||
SecurityHelper sHelper = new SecurityHelper();
|
||
|
||
OpenOrderReq suorder = new OpenOrderReq();
|
||
suorder.orderId = "1840301172999914";
|
||
|
||
|
||
Random rd = new Random();//用于生成随机数
|
||
string DateStr = DateTime.Now.ToString("yyyyMMddHHmmssfffffff");//日期
|
||
string str = DateStr + rd.Next(10000).ToString().PadLeft(4, '0');//带日期的随机数
|
||
|
||
suorder.payId = str;//先随机生成
|
||
suorder.payType = 1;
|
||
suorder.payPrice = 99 * 100;
|
||
suorder.userName = "up0000022";
|
||
suorder.isFree = 0;
|
||
suorder.payRemark = "";//支付备注
|
||
|
||
//string json = string.Format("content={0}&clientid={1}&sign={2}", content, clientid, sign);//信息转发
|
||
string url = "https://r2.soft.tcfortune.com/order/scgi/open_order";//封装出来的接口
|
||
|
||
|
||
string json = JsonHelper.ObjDivertToJson(suorder);
|
||
LogHelper.Info("Node.JS接口参数json=>:" + json);
|
||
json = JsonHelper.ObjDivertToJson(sHelper.createAjaxSignEncodingStr(json, "UPWEBSITE"));
|
||
string retmsg = Utility.PostAjaxData(url, json, Encoding.UTF8);//返回信息
|
||
|
||
|
||
LogHelper.Info("Node.JS接口返回数据json=>:" + retmsg);
|
||
|
||
OpenOrderRsp retmessage = JsonHelper.JsonDivertToObj<OpenOrderRsp>(retmsg);
|
||
|
||
if (retmessage.retCode == 10000)
|
||
{
|
||
MessageBox.Show(retmessage.ToJson());
|
||
}
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
MessageBox.Show(ex.ToString());
|
||
}
|
||
|
||
}
|
||
|
||
private void closeorder_Click(object sender, EventArgs e)
|
||
{
|
||
//关闭订单
|
||
SecurityHelper sHelper = new SecurityHelper();
|
||
|
||
string url = "https://r2.soft.tcfortune.com/order/scgi/close_order";
|
||
string clientid = "UPWEBSITE";
|
||
string json = "{\"userName\":\"up0000022\",\"orderId\":\"1840301162998417\",\"flag\":0}";
|
||
string content = sHelper.encyptData(clientid, json);
|
||
string sign = sHelper.signData(clientid, content);
|
||
//bool sss=sHelper.CheckClientValid("UPWEBSITE", "8fYIIKMSFVyhEi1vhWbLOis3Et9DdiYcE/AO/k9FWIY/69V3t4xIkI15n7EGgQSKvRt0EcVULoqnUU6fdODg6fP7tr42Tyr2yInFxJxGkGHNmhNxju+ZvttUEWffqislhlItcHSESCR3SaYST9lvyeDkZ8WRW+umF4QGiq1td5x0egulF4kc4Q==", "+4GPl6YoN30T4X1Bcbvoyg==");
|
||
var maxjson = new
|
||
{
|
||
content = content,
|
||
clientId = clientid,
|
||
sign = sign
|
||
};
|
||
string retmss = Utility.PostAjaxData(url, ObjDivertToJson(maxjson), Encoding.UTF8);
|
||
|
||
MessageBox.Show(retmss);
|
||
}
|
||
|
||
private void freeorder_Click(object sender, EventArgs e)
|
||
{
|
||
////需要修改productId，productType，totalPrice，totalDays
|
||
//CreateOrderReq suorder = new CreateOrderReq
|
||
//{
|
||
// //productId = "UPCFZH_20190102160303",
|
||
// productId = "UPCFJC_20201209093318_MFTY",
|
||
// userName = "dn0001411",//软件用户名
|
||
// count = 1,//产品数量
|
||
// busType = 1,//
|
||
// ch = 5001,
|
||
// source = 1,
|
||
// productType = 0,//0-单一产品、1-组合产品
|
||
// //mobile = "13416115228",//手机号码
|
||
// totalPrice =0,//价格用分作为结算
|
||
// //totalPrice = 99 * 100,//价格用分作为结算
|
||
// //complianceFlag = 1,//合规
|
||
// //signId = "",
|
||
// totalDays = 180,
|
||
// cssId = "10000",
|
||
// currentCH = 5001,
|
||
// ip = "127.0.0.1"
|
||
//};
|
||
|
||
//var url = "http://192.168.11.141:10034/order/scgi/create_open_free";//免费订单接口
|
||
|
||
//string json = JsonHelper.ObjDivertToJson(suorder);
|
||
//LogHelper.Info("Node.JS接口参数json=>:" + json);
|
||
|
||
//json = JsonHelper.ObjDivertToJson(new SecurityHelper().createAjaxSignEncodingStr(JsonHelper.ObjDivertToJson(suorder), "UPWEBSITE"));
|
||
//string retmsg = Utility.PostAjaxData(url, json, Encoding.UTF8);//返回信息
|
||
|
||
//LogHelper.Info("Node.JS接口返回数据json=>:" + retmsg);
|
||
////retmsg = sHelper.decyptData(SecurityHelper.OrderClientIdKey, retmsg);
|
||
|
||
//CreateOrderRsp retmessage = JsonHelper.JsonDivertToObj<CreateOrderRsp>(retmsg);
|
||
|
||
//LogHelper.Info("创建订单返回结果：" + retmessage.ToJson());
|
||
//MessageBox.Show(retmessage.retCode.ToString());
|
||
|
||
//if (retmessage.retCode == 10000)
|
||
//{
|
||
|
||
//}
|
||
//else
|
||
//{
|
||
// LogHelper.Error("retmessage:" + retmsg);//记录下单不成功
|
||
//}
|
||
SecurityHelper sHelper = new SecurityHelper();
|
||
|
||
var theModel = new freeordermodel
|
||
{
|
||
mobile = "",
|
||
//needpay = 0,
|
||
//opendays = 1,
|
||
//ordertype = 1,
|
||
//productId = 1094,
|
||
remark = "风险客户",
|
||
//source = "1",
|
||
softusername = "dn0001411",
|
||
productcode = "UPCFJC_20201209093318_MFTY",//小类代码
|
||
//teamserve = 1,
|
||
//userid = 600000207,
|
||
count = 365 * 3,//产品数 --免费产品始终一天，这里天数作为数量传递，达到天数效果
|
||
ctime = DateTimeTool.ConvertDateTimeInt(DateTime.Now).ToString(),
|
||
//theModel.companycode = companyCode;
|
||
//companycode = Utility.GetSettingOrNullByKey("DataClientCode"),
|
||
ch = 0,
|
||
days = 365 * 3
|
||
};
|
||
var url = "http://192.168.11.46:8096/OrderService.svc/FreeOrderByUserName/Open";//内部接口··开通免费订单接口
|
||
|
||
//var json = Utility.ConvertToJSON<freeordermodel>(theModel);
|
||
var json = "{\"productcode\":\"UPCFJC_20201209093318_MFTY\",\"mobile\":\"\",\"remark\":\"风险客户\",\"softusername\":\"dn0001411\",\"ctime\":\"1657188498\",\"count\":1096,\"ch\":0}";
|
||
json = sHelper.createSignEncodingStr(json, SecurityHelper.OrderClientIdKey);
|
||
//LogHelper.Info("投顾订单" + model.ORDERID + (string.IsNullOrEmpty(model.WEBORDERID) ? "" : string.Format("({0})", model.WEBORDERID)) + "审核:" + url + "?" + json);
|
||
string retmsg = Utility.PostData(url + "?" + json, Encoding.UTF8);
|
||
retmsg = sHelper.decyptData(SecurityHelper.OrderClientIdKey, retmsg);
|
||
|
||
CreateOrderRsp retmessage = JsonHelper.JsonDivertToObj<CreateOrderRsp>(retmsg);//返回信息
|
||
}
|
||
|
||
private void SupplyOrder_Click(object sender, EventArgs e)
|
||
{
|
||
var upgradeOrderList = new List<OrderInfo>();
|
||
upgradeOrderList.Add(new OrderInfo() { orderid = "1840301162998518" });
|
||
upgradeOrderList.Add(new OrderInfo() { orderid = "1840301162998417" });
|
||
|
||
//需要修改productId，productType，totalPrice，totalDays，看情况ext1是否需要
|
||
CreateOrderReq suorder = new CreateOrderReq
|
||
{
|
||
productId = "UPCFJC_20181119180241",
|
||
userName = "up0000022",//软件用户名
|
||
count = 1,//产品数量
|
||
busType = 1,//
|
||
ch = 5001,
|
||
source = 2,
|
||
productType = 1,//0-单一产品、1-组合产品
|
||
mobile = "13416115228",//手机号码
|
||
totalPrice = 99 * 100,//价格用分作为结算
|
||
//complianceFlag = 1,//合规
|
||
//signId = "",
|
||
totalDays = 365,
|
||
cssId = "10000",
|
||
currentCH = 5001,
|
||
ip = "127.0.0.1"
|
||
//ext1 = "{\"upgradeOrderList\": " + upgradeOrderList.ToJson() + " }"
|
||
//,
|
||
//ext1 = (new { upgradeOrderList }).ToJson()
|
||
};
|
||
|
||
var url = "https://r2.soft.tcfortune.com/order/scgi/create_order";//付费订单接口
|
||
|
||
string json = JsonHelper.ObjDivertToJson(suorder);
|
||
LogHelper.Info("Node.JS接口参数json=>:" + json);
|
||
|
||
json = JsonHelper.ObjDivertToJson(new SecurityHelper().createAjaxSignEncodingStr(JsonHelper.ObjDivertToJson(suorder), "UPWEBSITE"));
|
||
string retmsg = Utility.PostAjaxData(url, json, Encoding.UTF8);//返回信息
|
||
|
||
LogHelper.Info("Node.JS接口返回数据json=>:" + retmsg);
|
||
//retmsg = sHelper.decyptData(SecurityHelper.OrderClientIdKey, retmsg);
|
||
|
||
CreateOrderRsp retmessage = JsonHelper.JsonDivertToObj<CreateOrderRsp>(retmsg);
|
||
|
||
LogHelper.Info("创建订单返回结果：" + retmessage.ToJson());
|
||
MessageBox.Show(retmessage.retCode.ToString());
|
||
|
||
if (retmessage.retCode == 10000)
|
||
{
|
||
|
||
}
|
||
else
|
||
{
|
||
LogHelper.Error("retmessage:" + retmsg);//记录下单不成功
|
||
}
|
||
}
|
||
|
||
private void button39_Click(object sender, EventArgs e)
|
||
{
|
||
SecurityHelper sHelper = new SecurityHelper();
|
||
var url = "http://localhost:55047/ResourceService.svc/Join";
|
||
string clientid = "TDORDERSITE";
|
||
//string json = "{\"username\":\"13985834619\",\"mobile\":\"13985834222\",\"campaignId\":\"27102\",\"deptcode\":\"TDOEM\",\"datatype\":\"stock\"}";
|
||
string json = "{\"campaignId\":\"test\",\"deptcode\":\"QBJY\",\"accounttype\":0,\"account\":\"13416115228\"}";
|
||
string content = sHelper.encyptData(clientid, json);
|
||
string sign = sHelper.signData(clientid, content);
|
||
url += "?" + "content=" + HttpUtility.UrlEncode(content) + "&clientid=" + clientid + "&sign=" + HttpUtility.UrlEncode(sign);
|
||
string retmss = HttpUtility.UrlDecode(Utility.PostData(url, Encoding.UTF8).Replace("\"", ""));
|
||
//string retmss = HttpUtility.UrlDecode(Utility.PostData(url, Encoding.UTF8));
|
||
retmss = sHelper.decyptData(clientid, retmss);
|
||
MessageBox.Show(retmss);
|
||
}
|
||
|
||
private void button40_Click(object sender, EventArgs e)
|
||
{
|
||
new WX.CRM.CRMServices.Res.AutoDial().start();
|
||
}
|
||
|
||
private void button41_Click(object sender, EventArgs e)
|
||
{
|
||
try
|
||
{
|
||
|
||
int[] wocha = { 49, 55, 55, 53, 55, 54, 56, 54, 50, 57, 53 };
|
||
byte[] data = new byte[wocha.Length];
|
||
|
||
for (int i = 0; i < wocha.Length; i++)
|
||
{
|
||
data[i] = (byte)(wocha[i] & 0xff);
|
||
}
|
||
string wochaa = System.Text.Encoding.UTF8.GetString(data);
|
||
}
|
||
catch (Exception ae) { };
|
||
}
|
||
|
||
private void button42_Click(object sender, EventArgs e)
|
||
{
|
||
//string FileUrl = "/uploadfile/201912/4f0af3166924e9cefddd666883e58b4f";
|
||
//string md5 = string.Empty;
|
||
//int ganindex = FileUrl.LastIndexOf("/");
|
||
//if (FileUrl.IndexOf(".") == -1)
|
||
//{
|
||
// md5 = FileUrl.Substring(ganindex+1, FileUrl.Length- ganindex-1);
|
||
//}
|
||
//else
|
||
//{
|
||
// md5 = FileUrl.Substring(ganindex + 1, FileUrl.LastIndexOf(".")- ganindex - 1);
|
||
//}
|
||
|
||
string md5 = string.Empty;
|
||
string fileName = "4f0af3166924e9cefddd666883e58b4f";
|
||
if (fileName.IndexOf(".") == -1)
|
||
{
|
||
md5 = fileName;
|
||
}
|
||
else
|
||
{
|
||
md5 = fileName.Substring(0, fileName.LastIndexOf("."));
|
||
}
|
||
|
||
}
|
||
|
||
private void button43_Click(object sender, EventArgs e)
|
||
{
|
||
//初始化一个OpenFileDialog类
|
||
OpenFileDialog fileDialog = new OpenFileDialog();
|
||
|
||
//判断用户是否正确的选择了文件
|
||
if (fileDialog.ShowDialog() == DialogResult.OK)
|
||
{
|
||
//获取用户选择文件的后缀名
|
||
string extension = Path.GetExtension(fileDialog.FileName);
|
||
//声明允许的后缀名
|
||
string clientid = Utility.GetSettingByKey("CRMClientKey");
|
||
WX.CRM.IBLL.Util.ISecurityHelper sHelper = new SecurityHelper();
|
||
StreamReader sr = new StreamReader(fileDialog.FileName, Encoding.Default);
|
||
String line;
|
||
List<string> mobileList = new List<string>();
|
||
Dictionary<string, string> dic = new Dictionary<string, string>();
|
||
RES_RESOURCEMOBILE_BL mobilebl = new RES_RESOURCEMOBILE_BL();
|
||
while ((line = sr.ReadLine()) != null)
|
||
{
|
||
string mobile = line.ToString();
|
||
|
||
//string phone = Utility.GetMobile(line.ToString());
|
||
//if (string.IsNullOrWhiteSpace(mobile))
|
||
//{
|
||
// continue;
|
||
//}
|
||
|
||
mobileList.Add(mobile.Trim());
|
||
}
|
||
|
||
|
||
using (ExcelPackage package = new ExcelPackage())
|
||
{
|
||
|
||
ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("test");
|
||
|
||
worksheet.Cells[1, 1].Value = "手机号";
|
||
worksheet.Cells[1, 2].Value = "resid";
|
||
|
||
var i = 2;
|
||
foreach (var item in mobileList)
|
||
{
|
||
if (string.IsNullOrEmpty(item))
|
||
{
|
||
worksheet.Cells[i, 1].Value = "";
|
||
worksheet.Cells[i, 2].Value = "";
|
||
}
|
||
else
|
||
{
|
||
worksheet.Cells[i, 1].Value = item;
|
||
worksheet.Cells[i, 2].Value = ResUtil.CreateResId(item);
|
||
}
|
||
i++;
|
||
}
|
||
|
||
using (SaveFileDialog saveFileDialog1 = new SaveFileDialog())
|
||
{
|
||
saveFileDialog1.Title = "另存为";
|
||
saveFileDialog1.FileName = "nixa.xlsx"; //设置默认另存为的名字，可选
|
||
saveFileDialog1.Filter = "Excel 文件(*.xls)|*.xls|Excel 文件(*.xlsx)|*.xlsx|所有文件(*.*)|*.*";
|
||
saveFileDialog1.AddExtension = true;
|
||
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
|
||
{
|
||
package.SaveAs(new FileInfo(saveFileDialog1.FileName));
|
||
}
|
||
}
|
||
}
|
||
|
||
}
|
||
}
|
||
|
||
private void button44_Click(object sender, EventArgs e)
|
||
{
|
||
OpenFileDialog fileDialog = new OpenFileDialog();
|
||
|
||
//判断用户是否正确的选择了文件
|
||
if (fileDialog.ShowDialog() == DialogResult.OK)
|
||
{
|
||
//获取用户选择文件的后缀名
|
||
string extension = Path.GetExtension(fileDialog.FileName);
|
||
//声明允许的后缀名
|
||
string clientid = Utility.GetSettingByKey("CRMClientKey");
|
||
WX.CRM.IBLL.Util.ISecurityHelper sHelper = new SecurityHelper();
|
||
StreamReader sr = new StreamReader(fileDialog.FileName, Encoding.Default);
|
||
String line;
|
||
List<string> mobileList = new List<string>();
|
||
Dictionary<string, string> dic = new Dictionary<string, string>();
|
||
RES_RESOURCEMOBILE_BL mobilebl = new RES_RESOURCEMOBILE_BL();
|
||
while ((line = sr.ReadLine()) != null)
|
||
{
|
||
string resid = line.ToString();
|
||
resid = resid.Trim('"');
|
||
|
||
//if (resid.Length == 24)
|
||
mobileList.Add(resid);
|
||
}
|
||
|
||
mobileList = mobilebl.GetNumberByResIdListNoSql(mobileList).ToList();
|
||
|
||
|
||
SaveFileDialog saveFile1 = new SaveFileDialog();
|
||
saveFile1.Filter = "文本文件(.txt)|*.txt";
|
||
saveFile1.FilterIndex = 1;
|
||
if (saveFile1.ShowDialog() == System.Windows.Forms.DialogResult.OK && saveFile1.FileName.Length > 0)
|
||
{
|
||
System.IO.StreamWriter sw = new System.IO.StreamWriter(saveFile1.FileName, false);
|
||
try
|
||
{
|
||
foreach (var item in mobileList)
|
||
{
|
||
sw.WriteLine(item); //只要这里改一下要输出的内容就可以了
|
||
}
|
||
}
|
||
catch
|
||
{
|
||
throw;
|
||
}
|
||
finally
|
||
{
|
||
sw.Close();
|
||
}
|
||
}
|
||
|
||
}
|
||
}
|
||
|
||
private void button45_Click(object sender, EventArgs e)
|
||
{
|
||
var Username = "donggao";
|
||
var Password = "clyuQwhLcUgQfV1r";
|
||
var Authorization = "Basic " + Utility.StrToBase64(Username + ":" + Password);
|
||
|
||
//var start_time = DateTime.Parse("2020-05-01 00:00:00");
|
||
//var end_time = DateTime.Parse("2020-05-05 00:00:00");
|
||
|
||
//var dics = new Dictionary<string, string>
|
||
//{
|
||
// { "start_time", start_time.ToString("yyyy-MM-dd HH:mm:ss") },
|
||
// { "end_time", end_time.ToString("yyyy-MM-dd HH:mm:ss") }
|
||
//};
|
||
|
||
//var param = Utility.GetParamSrc(dics);
|
||
////MessageBox.Show(param);
|
||
|
||
//var res = Utility.PostAjaxData("http://agent.demo.taoniubang.com/orders/gift/queryOrderDG?" + param, string.Empty, Authorization, false);
|
||
|
||
//MessageBox.Show(res);
|
||
|
||
var rejectStr = "1";
|
||
|
||
//var orderNo = "TNBDG20051117273447342381";
|
||
//var thirdOrderNo = 1996405114075619;
|
||
var orderNo = "TNBDG20051117284444501246";
|
||
var thirdOrderNo = 1996405114075518;
|
||
var reasonIdList = new List<string>(rejectStr.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries)).Select<string, int>(x => Convert.ToInt32(x));
|
||
|
||
var dics = new Dictionary<string, string>
|
||
{
|
||
{ "orderNo", orderNo },
|
||
{ "thirdOrderNo", thirdOrderNo.ToString() },
|
||
{ "reasonIdList", reasonIdList.ToJson() }
|
||
};
|
||
|
||
var param = Utility.GetParamSrc(dics);
|
||
MessageBox.Show(param);
|
||
|
||
var sign = Utility.EncryptMD5(param).ToUpper();
|
||
MessageBox.Show(sign);
|
||
|
||
var tnbPara = new { orderNo, thirdOrderNo, reasonIdList, sign };
|
||
|
||
//MessageBox.Show(tnbPara.ToJson());
|
||
|
||
//var res = Utility.PostAjaxData("http://api.taoniubang.com/orders/ruleAudit", tnbPara.ToJson(), Authorization, true);
|
||
var res = Utility.PostAjaxData("http://agent.demo.taoniubang.com/orders/ruleAudit", tnbPara.ToJson(), Authorization, true);
|
||
|
||
MessageBox.Show(res);
|
||
}
|
||
|
||
private void button46_Click(object sender, EventArgs e)
|
||
{
|
||
string mobile = "16619708806";
|
||
string mobile2 = "016619708806";
|
||
string mobile3 = "16619708806 ";
|
||
string mobile4 = " 16619708806 ";
|
||
string mobile5 = " 16619708806";
|
||
string mobile6 = "8616619708806";
|
||
string mobile7 = "+8618848414824";
|
||
string m = ResUtil.CreateResId(mobile);
|
||
string m2 = ResUtil.CreateResId(mobile2);
|
||
string mobile32 = ResUtil.CreateResId(mobile3);
|
||
string mobile42 = ResUtil.CreateResId(mobile4);
|
||
string mobile53 = ResUtil.CreateResId(mobile5);
|
||
string mobile63 = ResUtil.CreateResId(mobile6);
|
||
string mobile72 = ResUtil.CreateResId(mobile7);
|
||
}
|
||
|
||
private void button47_Click(object sender, EventArgs e)
|
||
{
|
||
|
||
|
||
|
||
WX.CRM.IBLL.Util.ISecurityHelper sHelper = new SecurityHelper();
|
||
string ss = sHelper.decyptData("UPWEBSITE", "delvAlmupXkNIYzx75OcSzeE8/t07dG3VB963BNblKkf+Eq6ua3y/w==");
|
||
}
|
||
|
||
private void button48_Click(object sender, EventArgs e)
|
||
{
|
||
RfmDto model = new RfmDto()
|
||
{
|
||
ch = 2121,
|
||
labelname = "消退",
|
||
mobile = "13327995299",
|
||
weight = 40,
|
||
username = "zj922920",
|
||
appid = "com.dongniu"
|
||
};
|
||
|
||
var json = JsonConvert.SerializeObject(model);
|
||
var para = new SecurityHelper().createSignEncodingStr(json);
|
||
//Console.WriteLine(para);
|
||
var url = "http://192.168.11.46:8096/ResourceService.svc/SynRfm";
|
||
var rep = Utility.PostData(url + "?" + para, Encoding.UTF8);
|
||
SecurityHelper sHelper = new SecurityHelper();
|
||
string sa = sHelper.decyptData("UPWEBSITE", HttpUtility.UrlDecode(rep).Replace("\"", ""));
|
||
string aax = "";
|
||
aax += "";
|
||
|
||
}
|
||
|
||
//private void button2_Click(object sender, EventArgs e)
|
||
//{
|
||
// SendGroupPercentToPromotion("");
|
||
// SendUserPercentToPromotion();
|
||
//}
|
||
|
||
///// <summary>
|
||
///// 同步到推广-组别比率
|
||
///// </summary>
|
||
//private void SendGroupPercentToPromotion(string gids)
|
||
//{
|
||
// try
|
||
// {
|
||
// List<WX_GROUPPERCENT_Extend> list = wx_GroupPercent_BL.GetGroupPercentListJoinGroup(gids);
|
||
// foreach (WX_GROUPPERCENT_Extend item in list)
|
||
// {
|
||
// web_push_updateGroup user = new web_push_updateGroup()
|
||
// {
|
||
// GroupId = item.GID.ToString(),
|
||
// Isopen = 1,
|
||
// Name = item.GNAME,
|
||
// Proportion = item.DIV_PERCENT.Value
|
||
// };
|
||
// new PushDataServices().SendData<web_push_updateGroup>(user, "ZQZX", "web_push_updateGroup");
|
||
// }
|
||
|
||
// }
|
||
// catch (Exception e) { LogHelper.Error("组别比率新增推送数据出错：" + e.ToString()); }
|
||
//}
|
||
///// <summary>
|
||
///// 同步到推广-员工比率
|
||
///// </summary>
|
||
///// <param name="gids"></param>
|
||
//private void SendUserPercentToPromotion(decimal[] groupIds)
|
||
//{
|
||
// try
|
||
// {
|
||
// List<WX_USERPERCENT_Extend2> list = wx_UserPercent_BL.GetUserPercentToPush(groupIds);
|
||
// foreach (WX_USERPERCENT_Extend2 item in list)
|
||
// {
|
||
// web_push_updateEmployee user = new web_push_updateEmployee()
|
||
// {
|
||
// Isopn = 1,
|
||
// EID = item.EID.ToString(),
|
||
// GroupID = item.GID.ToString(),
|
||
// Name = item.UNAME,
|
||
// Proportion = item.DIV_PERCENT,
|
||
// userid = item.UserId.ToString()
|
||
// };
|
||
// new PushDataServices().SendData<web_push_updateEmployee>(user, "ZQZX", "web_push_updateEmployee");
|
||
// }
|
||
// }
|
||
// catch (Exception e) { LogHelper.Error("员工比率新增推送数据出错：" + e.ToString()); }
|
||
//}
|
||
|
||
|
||
|
||
/// <summary>
|
||
/// 图片添加文字，文字大小自适应
|
||
/// </summary>
|
||
/// <param name="imgPath">图片路径</param>
|
||
/// <param name="locationLeftTop">左上角定位(x1,y1)</param>
|
||
/// <param name="locationRightBottom">右下角定位(x2,y2)</param>
|
||
/// <param name="text">文字内容</param>
|
||
/// <param name="fontName">字体名称</param>
|
||
/// <returns>添加文字后的Bitmap对象</returns>
|
||
public static Bitmap AddText(string imgPath, string locationLeftTop, string locationRightBottom, string text, string fontName = "华文行楷")
|
||
{
|
||
Image img = Image.FromFile(imgPath);
|
||
int width = img.Width;
|
||
int height = img.Height;
|
||
Bitmap bmp = new Bitmap(width, height);
|
||
Graphics graph = Graphics.FromImage(bmp);
|
||
|
||
// 计算文字区域
|
||
// 左上角
|
||
string[] location = locationLeftTop.Split(',');
|
||
float x1 = float.Parse(location[0]);
|
||
float y1 = float.Parse(location[1]);
|
||
// 右下角
|
||
location = locationRightBottom.Split(',');
|
||
float x2 = float.Parse(location[0]);
|
||
float y2 = float.Parse(location[1]);
|
||
// 区域宽高
|
||
float fontWidth = x2 - x1;
|
||
float fontHeight = y2 - y1;
|
||
float fontSize = fontHeight; // 初次估计先用文字区域高度作为文字字体大小，后面再做调整，单位为px
|
||
|
||
Font font = new Font(fontName, fontSize, GraphicsUnit.Pixel);
|
||
SizeF sf = graph.MeasureString(text, font);
|
||
int times = 0;
|
||
|
||
// 调整字体大小以适应文字区域
|
||
if (sf.Width > fontWidth)
|
||
{
|
||
while (sf.Width > fontWidth)
|
||
{
|
||
fontSize -= 0.1f;
|
||
font = new Font(fontName, fontSize, GraphicsUnit.Pixel);
|
||
sf = graph.MeasureString(text, font);
|
||
times++;
|
||
}
|
||
|
||
Console.WriteLine("一开始估计大了，最终字体大小为{0}，循环了{1}次", font.ToString(), times);
|
||
}
|
||
else if (sf.Width < fontWidth)
|
||
{
|
||
while (sf.Width < fontWidth)
|
||
{
|
||
fontSize += 0.1f;
|
||
font = new Font(fontName, fontSize, GraphicsUnit.Pixel);
|
||
sf = graph.MeasureString(text, font);
|
||
times++;
|
||
}
|
||
|
||
Console.WriteLine("一开始估计小了，最终字体大小为{0}，循环了{1}次", font.ToString(), times);
|
||
}
|
||
// 最终的得出的字体所占区域一般不会刚好等于实际区域
|
||
// 所以根据两个区域的相差之处再把文字开始位置(左上角定位)稍微调整一下
|
||
x1 += (fontWidth - sf.Width) / 2;
|
||
y1 += (fontHeight - sf.Height) / 2;
|
||
graph.DrawImage(img, 0, 0, width, height);
|
||
graph.DrawString(text, font, new SolidBrush(Color.Black), x1, y1);
|
||
graph.Dispose();
|
||
img.Dispose();
|
||
return bmp;
|
||
}
|
||
|
||
private void button49_Click(object sender, EventArgs e)
|
||
{
|
||
AutoBound.Bound();
|
||
}
|
||
|
||
private void button50_Click(object sender, EventArgs e)
|
||
{
|
||
//SummaryMessage.Summary();
|
||
//SummaryMessage.Push();
|
||
}
|
||
|
||
private void button51_Click(object sender, EventArgs e)
|
||
{
|
||
//SummaryMessagePush.Push();
|
||
}
|
||
|
||
private void button52_Click(object sender, EventArgs e)
|
||
{
|
||
WWHHuserMonitor.Monitor();
|
||
}
|
||
|
||
private void button53_Click(object sender, EventArgs e)
|
||
{
|
||
new WX_SZZYORDERDEPOSIT_BL().Delete(20000294);
|
||
}
|
||
|
||
private void button54_Click(object sender, EventArgs e)
|
||
{
|
||
/* OracleHelper.ExecuteOracleTransaction();
|
||
return;*/
|
||
SYNC_PUSH_SUCC info = new SYNC_PUSH_SUCC()
|
||
{
|
||
PKID = 59125259,
|
||
PICI = 0,
|
||
JSONTEXT = "{\"resid\":\"047012725787469725\",\"userid\":\"wm9jNKCAAAN64mDModNfWKOac_xjX5pg\",\"deptcode\":\"DNG8\"}",
|
||
FILENAME = "23",
|
||
ISBATCH = 1,
|
||
CTIME = DateTime.Parse("2022-07-06 15:19:44"),
|
||
SENDTIME = DateTime.Parse("2022-07-06 16:13:03"),
|
||
BIDATATYPE = "Client_CloseOrder",
|
||
DEPTCODE = "DNG8",
|
||
CANREPEATNUM = 0
|
||
};
|
||
OracleParameter[] cmdParms =
|
||
{
|
||
new OracleParameter(){ ParameterName = ":PKID", OracleDbType = OracleDbType.Decimal, Value = info.PKID},
|
||
|
||
new OracleParameter(){ ParameterName = ":JSONTEXT", OracleDbType = OracleDbType.Clob, Value = info.JSONTEXT },
|
||
new OracleParameter(){ ParameterName = ":FILENAME", OracleDbType = OracleDbType.Varchar2, Value = info.FILENAME},
|
||
new OracleParameter(){ ParameterName = ":ISBATCH", OracleDbType = OracleDbType.Decimal, Value = info.ISBATCH},
|
||
new OracleParameter(){ ParameterName = ":CTIME", OracleDbType = OracleDbType.Date, Value = info.CTIME},
|
||
new OracleParameter(){ ParameterName = ":SENDTIME", OracleDbType = OracleDbType.Date, Value = info.SENDTIME},
|
||
new OracleParameter(){ ParameterName = ":BIDATATYPE", OracleDbType = OracleDbType.Varchar2, Value = info.BIDATATYPE},
|
||
new OracleParameter(){ ParameterName = ":DEPTCODE", OracleDbType = OracleDbType.Varchar2, Value = info.DEPTCODE },
|
||
new OracleParameter(){ ParameterName = ":CANREPEATNUM", OracleDbType = OracleDbType.Decimal, Value = info.CANREPEATNUM},
|
||
};
|
||
ExecuteOracleTransaction(cmdParms);
|
||
}
|
||
|
||
public static void ExecuteOracleTransaction(OracleParameter[] cmdParms)
|
||
{
|
||
OracleConnection conn = new OracleConnection(OracleHelper.AYCRMConn);
|
||
if (conn.State == ConnectionState.Closed)
|
||
conn.Open();
|
||
try
|
||
{
|
||
using (OracleTransaction trans = conn.BeginTransaction())
|
||
{
|
||
|
||
String cmdText = @"
|
||
INSERT INTO WSKUSER.SYNC_RECEIVE_SUCC A
|
||
(A.PKID,
|
||
A.PICI,
|
||
A.JSONTEXT,
|
||
A.FILENAME,
|
||
A.ISBATCH,
|
||
A.CTIME,
|
||
A.SENDTIME,
|
||
A.BIDATATYPE,
|
||
A.DEPTCODE,
|
||
A.CANREPEATNUM)
|
||
VALUES
|
||
(:PKID,
|
||
:PICI,
|
||
:JSONTEXT,
|
||
:FILENAME,
|
||
:ISBATCH,
|
||
:CTIME,
|
||
:SENDTIME,
|
||
:BIDATATYPE,
|
||
:DEPTCODE,
|
||
:CANREPEATNUM)";
|
||
/* OracleParameter[] cmdParms =
|
||
{
|
||
new OracleParameter(){ ParameterName = ":PKID", OracleType = OracleType.Number, Value = info.PKID},
|
||
new OracleParameter(){ ParameterName = ":PICI", OracleType = OracleType.Number, Value = info.PICI},
|
||
new OracleParameter(){ ParameterName = ":JSONTEXT", OracleType = OracleType.Clob, Value = info.JSONTEXT },
|
||
new OracleParameter(){ ParameterName = ":FILENAME", OracleType = OracleType.VarChar, Value = info.FILENAME},
|
||
new OracleParameter(){ ParameterName = ":ISBATCH", OracleType = OracleType.Number, Value = info.ISBATCH},
|
||
new OracleParameter(){ ParameterName = ":CTIME", OracleType = OracleType.DateTime, Value = info.CTIME },
|
||
new OracleParameter(){ ParameterName = ":SENDTIME", OracleType = OracleType.DateTime, Value = info.SENDTIME},
|
||
new OracleParameter(){ ParameterName = ":BIDATATYPE", OracleType = OracleType.VarChar, Value = info.BIDATATYPE},
|
||
new OracleParameter(){ ParameterName = ":DEPTCODE", OracleType = OracleType.VarChar, Value = info.DEPTCODE },
|
||
new OracleParameter(){ ParameterName = ":CANREPEATNUM", OracleType = OracleType.Int32, Value = info.CANREPEATNUM},
|
||
|
||
};*/
|
||
string sql = "select count(*) ncount from wskuser.sync_receive_succ a where a.pkid=:pkid";
|
||
List<OracleParameter> param = new List<OracleParameter>() { new OracleParameter() { ParameterName = ":pkid", OracleDbType = OracleDbType.Decimal, Value = "59125256" } };
|
||
//bool isHasPkid = IsHasPkid(sql, param);
|
||
//if (!isHasPkid)
|
||
//{
|
||
ExecuteSqlCommand(conn, trans, cmdText, cmdParms);
|
||
string strDelete = " delete from wskuser.sync_receive a where a.pkid='59125239' ";
|
||
ExecuteSqlCommand(conn, trans, strDelete);
|
||
trans.Commit();
|
||
//}
|
||
}
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
}
|
||
finally { conn.Close(); }
|
||
}
|
||
|
||
/// <summary>
|
||
/// 判断是否存在Pkid
|
||
/// </summary>
|
||
/// <param name="sql"></param>
|
||
/// <param name="param"></param>
|
||
/// <returns></returns>
|
||
private static bool IsHasPkid(string sql, List<OracleParameter> param)
|
||
{
|
||
bool isHas = false;
|
||
try
|
||
{
|
||
DataTable tab = DataQueray(OracleHelper.AYCRMConn, CommandType.Text, sql, param.ToArray()).Tables[0];
|
||
int count = Convert.ToInt32(tab.Rows[0]["ncount"]);
|
||
if (count > 0)
|
||
isHas = true;
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
LogHelper.Error(ex.ToString());
|
||
}
|
||
return isHas;
|
||
}
|
||
|
||
public string HmacMD5(string source, string key)
|
||
{
|
||
HMACMD5 hmacmd = new HMACMD5(Encoding.UTF8.GetBytes(key));
|
||
byte[] inArray = hmacmd.ComputeHash(Encoding.UTF8.GetBytes(source));
|
||
StringBuilder sb = new StringBuilder();
|
||
|
||
for (int i = 0; i < inArray.Length; i++)
|
||
{
|
||
sb.Append(inArray[i].ToString("X2"));
|
||
}
|
||
|
||
hmacmd.Clear();
|
||
|
||
return sb.ToString();
|
||
}
|
||
|
||
/// <summary>
|
||
/// 返回一个dataset
|
||
/// </summary>
|
||
/// <param name="connectionstring"></param>
|
||
/// <param name="cmdType"></param>
|
||
/// <param name="cmdText"></param>
|
||
/// <param name="commandParameters"></param>
|
||
/// <returns></returns>
|
||
public static DataSet DataQueray(string connectionstring, CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)
|
||
{
|
||
OracleConnection con = new OracleConnection(connectionstring);
|
||
OracleCommand cmd = new OracleCommand(cmdText, con);
|
||
try
|
||
{
|
||
cmd.CommandType = cmdType;
|
||
cmd.Parameters.AddRange(commandParameters);
|
||
OracleDataAdapter da = new OracleDataAdapter(cmd);
|
||
DataSet ds = new DataSet();
|
||
da.Fill(ds);
|
||
cmd.Parameters.Clear();
|
||
return ds;
|
||
}
|
||
finally
|
||
{
|
||
if (con.State == ConnectionState.Open)
|
||
con.Close();
|
||
}
|
||
}
|
||
|
||
private static void ExecuteSqlCommand(OracleConnection conn, OracleTransaction trans, string cmdText, OracleParameter[] cmdParms = null)
|
||
{
|
||
try
|
||
{
|
||
OracleCommand mycmd = new OracleCommand(cmdText);
|
||
mycmd.Connection = conn;
|
||
if (trans != null)
|
||
mycmd.Transaction = trans;
|
||
mycmd.CommandType = CommandType.Text;
|
||
if (cmdParms != null)
|
||
{
|
||
foreach (OracleParameter parameter in cmdParms)
|
||
{
|
||
if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) &&
|
||
(parameter.Value == null))
|
||
{
|
||
parameter.Value = DBNull.Value;
|
||
}
|
||
mycmd.Parameters.Add(parameter);
|
||
}
|
||
}
|
||
mycmd.ExecuteNonQuery();
|
||
}
|
||
catch (Exception)
|
||
{
|
||
|
||
throw;
|
||
}
|
||
}
|
||
|
||
private void button55_Click(object sender, EventArgs e)
|
||
{
|
||
var sql = "select * from temp_extusers";
|
||
MySqlDbHelper db = new MySqlDbHelper("MysqlQWConn");
|
||
db.ExecuteDataTable(sql, null);
|
||
}
|
||
|
||
private void button56_Click(object sender, EventArgs e)
|
||
{
|
||
|
||
}
|
||
}
|
||
public class SyncRegUserModel
|
||
{
|
||
public string username { get; set; }
|
||
public string activeMobile { get; set; }
|
||
public string mobile { get; set; }
|
||
public string campaignId { get; set; }
|
||
public string platform { get; set; }
|
||
public string userCardNo { get; set; }
|
||
public DateTime? regDate { get; set; }
|
||
|
||
public int companyId { get; set; }
|
||
}
|
||
public class SuCai
|
||
{
|
||
public string type { get; set; }
|
||
public int offset { get; set; }
|
||
public int count { get; set; }
|
||
}
|
||
|
||
public class ResInitInfo
|
||
{
|
||
public string CNumber { get; set; }
|
||
public string ResId { get; set; }
|
||
public string CustomerFrom { get; set; }
|
||
public string ECNumber { get; set; }
|
||
}
|
||
|
||
public class SilkConvertToMp3
|
||
{
|
||
public void ConvertToPcm(string applicationPath, string fileName, string targetFileName)
|
||
{
|
||
string para = applicationPath + @"\silk_v3_decoder.exe " + fileName + " " + targetFileName + "&exit";
|
||
Cmd(para);
|
||
}
|
||
public void ConvertToMp3(string applicationPath, string fileName, string targetFilName)
|
||
{
|
||
string c = applicationPath + @"\ffmpeg.exe -y -f s16le -ar 24000 -ac 1 -i " + fileName + " " + targetFilName + "&exit"; ;
|
||
Cmd(c);
|
||
}
|
||
public void ConvertAmrToMp3(string applicationPath, string fileName, string targetFilName)
|
||
{
|
||
string c = applicationPath + @"\ffmpeg.exe -i " + fileName + " " + targetFilName + "&exit"; ;
|
||
Cmd(c);
|
||
}
|
||
private void Cmd(string c)
|
||
{
|
||
try
|
||
{
|
||
System.Diagnostics.Process process = new System.Diagnostics.Process();
|
||
process.StartInfo.FileName = "cmd.exe";
|
||
process.StartInfo.UseShellExecute = false;
|
||
process.StartInfo.CreateNoWindow = true;
|
||
process.StartInfo.RedirectStandardOutput = true;
|
||
process.StartInfo.RedirectStandardInput = true;
|
||
process.Start();
|
||
|
||
process.StandardInput.WriteLine(c);
|
||
process.StandardInput.AutoFlush = true;
|
||
//process.StandardInput.WriteLine("exit");
|
||
|
||
var reader = process.StandardOutput.ReadToEnd(); //截取输出流
|
||
|
||
process.WaitForExit();
|
||
process.Close();
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
LogHelper.Error("转换录音文件失败：" + ex.ToString());
|
||
}
|
||
}
|
||
}
|
||
|
||
public class OrderInfo
|
||
{
|
||
public string orderid { get; set; }
|
||
}
|
||
|
||
public class CeShi
|
||
{
|
||
public int? eid { get; set; }
|
||
//public string callback { get; set; }
|
||
//public bool isweb { get; set; }
|
||
//public string business_name { get; set; }
|
||
//public int business_type { get; set; }
|
||
//public int tradetype { get; set; }
|
||
//public string payeename { get; set; }
|
||
//public string payerno { get; set; }
|
||
}
|
||
|
||
public class exambank
|
||
{
|
||
public string cchaptername { get; set; }
|
||
public int ichapterid { get; set; }
|
||
public int itype { get; set; }
|
||
public int igrade { get; set; }
|
||
}
|
||
|
||
public class subject
|
||
{
|
||
public int isubjectid { get; set; }
|
||
public string csubjecttype { get; set; }
|
||
public string ctitle { get; set; }
|
||
public string cquestion { get; set; }
|
||
public string cdescription { get; set; }
|
||
public string canswer { get; set; }
|
||
}
|
||
|
||
public class AccountInfo
|
||
{
|
||
public string appid { get; set; }
|
||
public string appuserid { get; set; }
|
||
public int uid { get; set; }
|
||
public string mobile { get; set; }
|
||
public string unionid { get; set; }
|
||
public string ctime { get; set; }
|
||
}
|
||
|
||
public class AssignQuery
|
||
{
|
||
public AssignQuery(string appuserid, int channel, int curchannel, string remark) : this("com.dongniu", appuserid, string.Empty, channel, curchannel, 0, string.Empty, remark, string.Empty, string.Empty, string.Empty)
|
||
{
|
||
this.appuserid = appuserid;
|
||
}
|
||
|
||
public AssignQuery(string appid, string appuserid, string unionid, int channel, int curchannel, int type, string livecode, string remark, string remarkext, string memo, string eid)
|
||
{
|
||
this.appid = appid;
|
||
this.appuserid = appuserid;
|
||
this.unionid = unionid;
|
||
this.channel = channel;
|
||
this.curchannel = curchannel;
|
||
this.type = type;
|
||
this.livecode = livecode;
|
||
this.remark = remark;
|
||
this.remarkext = remarkext;
|
||
this.memo = memo;
|
||
this.eid = eid;
|
||
}
|
||
|
||
public string appid { get; set; }
|
||
public string appuserid { get; set; }
|
||
public string unionid { get; set; }
|
||
public int channel { get; set; }
|
||
public int curchannel { get; set; }
|
||
public int type { get; set; }//1、返回二维码链接、0、不需要返回二码码链接
|
||
public string livecode { get; set; } //活码标识，30字符以内
|
||
public string remark { get; set; }//标记，30字符以内
|
||
public string remarkext { get; set; }//标记补充，30字符以内
|
||
public string memo { get; set; }
|
||
public string eid { get; set; }//工号
|
||
}
|
||
|
||
public class WeworkUserAssignMessage
|
||
{
|
||
public int errcode { get; set; }
|
||
public string errmsg { get; set; }
|
||
public WeworkUserAssignResult data { get; set; }
|
||
}
|
||
|
||
public class WeworkUserAssignResult
|
||
{
|
||
public int eid { get; set; }
|
||
public int? groupid { get; set; }
|
||
public string qr { get; set; }
|
||
}
|
||
} |