private void button3_Click(object sender, EventArgs e) { string httpType = cbx_Type.SelectedItem.ToString(); if (httpType.ToLower() == "get") { string Url = textBox1.Text.ToString(); var result = FunHelper.HttpGet(Url); richTextBox1.AppendText(" Request " + Url); richTextBox1.AppendText("\n"); richTextBox1.AppendText("Response " + result); richTextBox1.AppendText("\n"); Rtb_Response.Text = result; } else { //post string Url = textBox1.Text.ToString(); string postdata = richPostData.Text; System.Net.ServicePointManager.DefaultConnectionLimit = 200; var result = FunHelper.GetPostString(Url, postdata); richTextBox1.AppendText(" Request " + postdata); richTextBox1.AppendText("\n"); richTextBox1.AppendText("Response " + result); richTextBox1.AppendText("\n"); Rtb_Response.Text = result; } }
/// <summary> /// 加载商品信息列表—全部 /// </summary> /// <returns>加载结果 True:成功 False:失败</returns> public bool LoadGoodsInfo_Total() { bool result = false; GoodsList_Total.Clear(); DbOper dbOper = new DbOper(); dbOper.DbFileName = _m_DbFileName; try { string strSql = string.Empty; strSql += @"select McdCode,McdName,McdContent,Price, PicName,McdType,IsFree,Manufacturer, GoodsSpec,DrugType,DetailInfo,Unit,McdSaleType from T_MCD_BASEINFO order by id desc"; DataSet dataSet = dbOper.dataSet(strSql); if (dataSet.Tables.Count > 0) { int recordCount = dataSet.Tables[0].Rows.Count; for (int i = 0; i < recordCount; i++) { GoodsList_Total.Add(new GoodsModel() { McdCode = dataSet.Tables[0].Rows[i]["McdCode"].ToString(), McdName = dataSet.Tables[0].Rows[i]["McdName"].ToString(), McdContent = dataSet.Tables[0].Rows[i]["McdContent"].ToString(), PicName = dataSet.Tables[0].Rows[i]["PicName"].ToString(), Price = Convert.ToInt32(dataSet.Tables[0].Rows[i]["Price"].ToString()), IsFree = dataSet.Tables[0].Rows[i]["IsFree"].ToString(), Manufacturer = dataSet.Tables[0].Rows[i]["Manufacturer"].ToString(), GoodsSpec = dataSet.Tables[0].Rows[i]["GoodsSpec"].ToString(), DrugType = dataSet.Tables[0].Rows[i]["DrugType"].ToString(), TypeCode = dataSet.Tables[0].Rows[i]["McdType"].ToString(), Unit = dataSet.Tables[0].Rows[i]["Unit"].ToString(), DetailInfo = dataSet.Tables[0].Rows[i]["DetailInfo"].ToString(), McdSaleType = FunHelper.ChangeMcdSaleType(dataSet.Tables[0].Rows[i]["McdSaleType"].ToString()), }); } } result = true; } catch { result = false; } finally { dbOper.closeConnection(); } return(result); }
private static void Client2_OnLogined(object sender, string msg) { var client2 = sender as MessageClient; client2.SubscribeAsync("all"); FunHelper.WhileAsync(() => { client2.SendPrivateMsg(uid1, "你好姗姗,我是思思"); }, 1000, true); }
private static void Main(string[] args) { var userInfo = new { Name = "Kt" }; if (userInfo == null) { throw new Exception("Object Is Null"); } PropertyInfo[] Properties = userInfo.GetType().GetProperties(); string xml = "<xml>"; foreach (PropertyInfo p in Properties) { string str = p.Name + " = " + p.GetValue(userInfo, null); } Console.ReadKey(); var sqlConn = @"Data Source=.;Initial Catalog=test;User Id=sa;Password=123456;"; var sqlCmd = "Select count(1) From [Test].[dbo].[UserInfo] Where [Id] >= @Id "; SqlParameter sp = new SqlParameter("@Id", SqlDbType.Int); sp.Value = 0; Object obj = SqlHelper.ExecuteScalar(sqlConn, CommandType.Text, sqlCmd, sp); var count = FunHelper.GetValue(obj, 0); sqlCmd = "Select * From [Test].[dbo].[UserInfo] Where [Id] >= @Id "; DataSet ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.Text, sqlCmd, sp); DataTable dt = (ds.Tables != null && ds.Tables.Count > 0) ? ds.Tables[0] : null; if (dt != null && dt.Rows.Count > 0) { var user = new { Name = (string)dt.Rows[0]["Name"] }; // DataTable To List } sqlCmd = " Update [Test].[dbo].[UserInfo] Set [Name]='Updated' Where [Id] = @Id "; var updated = SqlHelper.ExecuteNonQuery(sqlConn, CommandType.Text, sqlCmd, sp) >= 1; sqlCmd = "if exists( Select count(1) From [Test].[dbo].[UserInfo] Where [Id] >= @Id ) begin select '1' end ; else begin select '0' end ;"; var exists = FunHelper.GetValue(SqlHelper.ExecuteScalar(sqlConn, CommandType.Text, sqlCmd, sp), 0) >= 1; Console.ReadKey(); var html = HttpHelper.HttpGet("http://china.huanqiu.com/article/2016-01/8461794.html?from=bdwz", "utf-8", "text/html"); var res = StringHelper.RemoveHTML(html); var html1 = HttpHelper.HttpGet("http://www.caogen.com/blog/Infor_detail/77018.html", "GB2312", "text/html"); var res1 = StringHelper.RemoveHTML(html1); CodeTimerHelper.Time("性能测试", 1000, () => { StringHelper.RemoveHTML(html1); }); Console.ReadKey(); }
private static void Client3_OnLogined(object sender, string msg) { Task.Factory.StartNew(() => { var client3 = sender as MessageClient; client3.SubscribeAsync("all"); FunHelper.WhileAsync(() => { client3.PublishAsync("all", msg); }, 3000); }); }
public string DeviceCommands(int appId, string deviceId, string serviceId, string method, string paras, int expireTime = 1200, int maxRetransmit = 3) { var rst = new ReturnResult <DeviceCommandResp>(); var api = new CommandApi(); rst = api.DeviceCommands(new SendCommandRequest { deviceId = deviceId, command = new CommandDetail { serviceId = serviceId, method = method, paras = JsonHelper.Instance.Deserialize <object>(paras) }, callbackUrl = "http://120.76.164.210:9999/commandRsp", expireTime = expireTime, maxRetransmit = maxRetransmit }, appId); if (rst.Result) { var data = rst.Data; var bll = new CommandInfoBll(); var addRst = bll.Add(new CommandInfo() { CommandId = data.commandId, AppId = data.appId, DeviceId = data.deviceId, Command = JsonHelper.Instance.Serialize(data.command), CallbackUrl = data.callbackUrl, ExpireTime = data.expireTime, Status = data.status, Result = JsonHelper.Instance.Serialize(data.result), CreationTime = FunHelper.UTCToDateTime(data.creationTime), ExecuteTime = FunHelper.UTCToDateTime(data.executeTime), PlatformIssUedTime = FunHelper.UTCToDateTime(data.platformIssuedTime), DeliveredTime = FunHelper.UTCToDateTime(data.deliveredTime), IssuedTimes = data.issuedTimes, MaxRetransMit = data.maxRetransmit, }); if (!addRst.Result) { rst.Result = false; rst.Message = addRst.Message; } } return(JsonHelper.Instance.Serialize(rst)); }
private static void Client_OnConnected1(WSClient client) { ConsoleHelper.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + " 当前客户端已连上"); FunHelper.WhileAsync(() => { //client.SendAsync(longStr); client.SendAsync(new GFF.WS.Model.WSMessage() { ID = Guid.NewGuid().ToString("N"), Content = longStr, Sender = "CS", time = DateTime.Now.Ticks.ToString() }); }, 1000); }
private List <TableObj> DeserializeObject(DataTable dt) { var lst = new List <TableObj> { }; if (dt != null) { foreach (DataRow dr in dt.Rows) { lst.Add(new TableObj { AllowNull = dr["AllowNull"] + "" == "1", Description = FunHelper.GetValue(dr["Description"], ""), Length = FunHelper.GetValue(dr["Length"], 0), Name = FunHelper.GetValue(dr["Name"], ""), Type = FunHelper.GetValue(dr["Type"], "") }); } } return(lst); }
private static void Main_SqlHelper(string[] args) { var sqlConn = @"Data Source=.;Initial Catalog=test;User Id=sa;Password=123456;"; var sqlCmd = "Select count(1) From [Test].[dbo].[UserInfo] Where [Id] >= @Id "; SqlParameter sp = new SqlParameter("@Id", SqlDbType.Int); sp.Value = 0; Object obj = SqlHelper.ExecuteScalar(sqlConn, CommandType.Text, sqlCmd, sp); var count = FunHelper.GetValue(obj, 0); sqlCmd = "Select * From [Test].[dbo].[UserInfo] Where [Id] >= @Id "; DataSet ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.Text, sqlCmd, sp); DataTable dt = (ds.Tables != null && ds.Tables.Count > 0) ? ds.Tables[0] : null; if (dt != null && dt.Rows.Count > 0) { var user = new { Name = (string)dt.Rows[0]["Name"] }; // DataTable To List } sqlCmd = " Update [Test].[dbo].[UserInfo] Set [Name]='Updated' Where [Id] = @Id "; var updated = SqlHelper.ExecuteNonQuery(sqlConn, CommandType.Text, sqlCmd, sp) >= 1; sqlCmd = "if exists( Select count(1) From [Test].[dbo].[UserInfo] Where [Id] >= @Id ) begin select '1' end ; else begin select '0' end ;"; var exists = FunHelper.GetValue(SqlHelper.ExecuteScalar(sqlConn, CommandType.Text, sqlCmd, sp), 0) >= 1; }
public void GetCallingVersionTest() { Assert.IsNotNull(FunHelper.GetCallingVersion()); }
static void Main(string[] args) { var dt = FunHelper.UTCToDateTime("20180706T061635Z"); var data = "{\"姓名\":\"罗报道\",\"手机\":\"13266513170\",\"年龄\":\"18\",\"性别\":\"女\",\"学车类型\":\"C1\",\"手动挡\":\"是\"}"; Console.ReadKey(); //while (true) //{ // Console.WriteLine("请输入任意键发送:"); // Console.ReadKey(); // CommandApi api = new CommandApi(); // var cmd = new CommandDetail() // { // serviceId = "AutoAlarm", // method = "CancelAlarm", // paras = new // { // //SyncByte = 0x5A, // //BodyLen = 0x1B, // //CmdType = 0x01, // //Status = 0x04, // //Flags = 0x00, // //AppId = DataHelper.HexToInt32("0384"), // //OrderNo = 0x14, // //SDID1 = DataHelper.HexToInt32("A137"), // //SDID2 = DataHelper.HexToInt32("8101"), // //Pwd = DataHelper.HEXToASCII("313233343536000000000000"), // //DelayLockSeconds = DataHelper.HexToInt32("000000FF"), // //CheckSum = 0xD1 // FuncCode = 0x01, // EndFlag = 0x0D // } // }; // var rst = api.DeviceCommands(new SendCommandRequest() // { // deviceId = "73f8bb24-f29f-4d8b-a026-7b2f18270fdb", // "906d511e-9da1-4023-8297-4c1c6ecb78d2", // command = cmd, // callbackUrl = "http://120.76.164.210:9999/commandRsp", // expireTime = 60000 // }, 1); // var data = rst.Data; // var bll = new CommandInfoBll(); // var addRst = bll.Add(new CommandInfo() { // CommandId = data.commandId, // AppId = data.appId, // DeviceId = data.deviceId, // Command = JsonHelper.Instance.Serialize(data.command), // CallbackUrl = data.callbackUrl, // ExpireTime = data.expireTime, // Status = data.status, // Result = JsonHelper.Instance.Serialize(data.result), // CreationTime = FunHelper.UTCToDateTime(data.creationTime), // ExecuteTime = FunHelper.UTCToDateTime(data.executeTime), // PlatformIssUedTime = FunHelper.UTCToDateTime(data.platformIssuedTime), // DeliveredTime = FunHelper.UTCToDateTime(data.deliveredTime), // IssuedTimes = data.issuedTimes, // MaxRetransMit = data.maxRetransmit, // }); // Console.WriteLine(addRst.Message); //} }
private void button1_Click(object sender, EventArgs e) { //dic.Clear(); if (Dgv_Desc.Rows.Count > 0) { for (int i = 0; i < Dgv_Desc.Rows.Count; i++) { if (i == Dgv_Desc.Rows.Count - 1) { break; } var dr = Dgv_Desc.Rows[i]; if (dr.Cells.Count > 0) { if (dr.Cells[0].Value != null && dr.Cells[1].Value != null) { if (!dic.ContainsKey(dr.Cells[0].Value.ToString().Trim())) { dic.Add(dr.Cells[0].Value.ToString().Trim(), dr.Cells[1].Value.ToString().Trim()); } else { dic[dr.Cells[0].Value.ToString().Trim()] = dr.Cells[1].Value.ToString().Trim(); } } } } } else { //dic.Clear(); } List <string> htmlFormatList = new List <string>(); string Url = textBox1.Text;//$htmlformat[1] StringBuilder PostJsonDescHtmlSb = new StringBuilder(); string PostJson = ""; if (!string.IsNullOrEmpty(richPostData.Text.Trim())) { PostJson = richPostData.Text.Trim(); var obj = JsonConvert.DeserializeObject <JObject>(PostJson); PostJson = FunHelper.ConvertJsonString(PostJson); string html = ""; PostJsonDescHtmlSb.Append(GetJObjHtml(html, obj)); } //else //{ //} int QuestionIndex = textBox1.Text.IndexOf('?'); if (QuestionIndex > 0) { var ParamLss = GetUrlParam(Url); Url = textBox1.Text.Substring(0, QuestionIndex); PostJsonDescHtmlSb.Append(GetParamHtml(ParamLss)); } htmlFormatList.Add(Txt_Title.Text); //接口名称//$htmlformat[0] htmlFormatList.Add(Url); //$htmlformat[1] htmlFormatList.Add(cbx_Type.SelectedItem.ToString()); //$htmlformat[2] htmlFormatList.Add(rtb_Desc.Text.Trim()); //$htmlformat[3] htmlFormatList.Add(PostJson); //$htmlformat[4] htmlFormatList.Add(PostJsonDescHtmlSb.ToString()); //$htmlformat[5] htmlFormatList.Add(FunHelper.ConvertJsonString(Rtb_Response.Text.Trim())); //返回的JSON//$htmlformat[6] string TempHtml = Rtb_Response.Text.Trim(); var TempObj = JsonConvert.DeserializeObject <JObject>(TempHtml); if (TempObj == null) { htmlFormatList.Add(""); //返回的JSON描述$htmlformat[7] } else { TempHtml = ""; htmlFormatList.Add(GetJObjHtml(TempHtml, TempObj, true)); //返回的JSON描述$htmlformat[7] } WriteFile(htmlFormatList); }
/// <summary> /// 加载商品信息列表—上架 /// </summary> /// <param name="pageNum">每页显示的最大行数</param> /// <param name="rowNum">每行显示的最大列数</param> /// <returns></returns> public bool LoadGoodsInfo_Show(int eachPageMaxRowNum, int eachRowMaxNum) { bool result = false; GoodsList_Show.Clear(); GoodsShowPageCount = 0; CurrentPageNo = 1; DbOper dbOper = new DbOper(); dbOper.DbFileName = _m_DbFileName; try { string strSql = string.Empty; strSql += @"select distinct t1.mcdcode,t2.mcdname,t2.mcdcontent,t2.picname,t1.sellprice, t2.IsFree,t2.Manufacturer,t2.GoodsSpec, t2.DrugType,t2.McdType,t2.Unit,t2.DetailInfo,t2.McdSaleType from t_vm_painfo t1,t_mcd_baseinfo t2 where t1.mcdcode = t2.mcdcode and t1.pakind = '0' and t1.sellmodel = '0' order by t1.pacode_num"; DataSet dataSet = dbOper.dataSet(strSql); if (dataSet.Tables.Count > 0) { int recordCount = dataSet.Tables[0].Rows.Count; // 获取总页面 int intEachMaxNum = eachPageMaxRowNum * eachRowMaxNum;// 每页显示的最大商品数量 GoodsShowPageCount = ((recordCount / intEachMaxNum) + ((recordCount % intEachMaxNum) > 0 ? 1 : 0)); string strSql12 = string.Empty; string strMcdCode = string.Empty; int intSellPrice = 0; int intSurNum = 0; string strStockNum = string.Empty; DataSet dataSet_Sur = new DataSet(); for (int i = 0; i < recordCount; i++) { strMcdCode = dataSet.Tables[0].Rows[i]["McdCode"].ToString(); intSellPrice = Convert.ToInt32(dataSet.Tables[0].Rows[i]["sellprice"].ToString()); // 查询每个商品当前的库存 intSurNum = 0; strSql12 = @"select sum(surnum) as surnum from t_vm_painfo where pakind = '0' and mcdcode = '" + strMcdCode + "' and sellprice = " + intSellPrice; dataSet_Sur = dbOper.dataSet(strSql12); if (dataSet_Sur.Tables.Count > 0) { if (dataSet_Sur.Tables[0].Rows.Count > 0) { strStockNum = dataSet_Sur.Tables[0].Rows[0]["surnum"].ToString(); intSurNum = Convert.ToInt32(strStockNum); } } GoodsList_Show.Add(new GoodsModel() { McdCode = strMcdCode, McdName = dataSet.Tables[0].Rows[i]["McdName"].ToString(), McdContent = dataSet.Tables[0].Rows[i]["McdContent"].ToString(), PicName = dataSet.Tables[0].Rows[i]["PicName"].ToString(), Price = intSellPrice, Unit = dataSet.Tables[0].Rows[i]["Unit"].ToString(), SurNum = intSurNum, IsFree = dataSet.Tables[0].Rows[i]["IsFree"].ToString(), Manufacturer = dataSet.Tables[0].Rows[i]["Manufacturer"].ToString(), GoodsSpec = dataSet.Tables[0].Rows[i]["GoodsSpec"].ToString(), DrugType = dataSet.Tables[0].Rows[i]["DrugType"].ToString(), TypeCode = dataSet.Tables[0].Rows[i]["McdType"].ToString(), DetailInfo = dataSet.Tables[0].Rows[i]["DetailInfo"].ToString(), McdSaleType = FunHelper.ChangeMcdSaleType(dataSet.Tables[0].Rows[i]["McdSaleType"].ToString()), }); } } result = true; } catch { result = false; } finally { dbOper.closeConnection(); } return(result); }
static void Main(string[] args) { Console.WriteLine($"CallingVersion:{FunHelper.GetCallingVersion()}"); Console.WriteLine($"Version:{FunHelper.GetVersion()}"); Console.Read(); }