コード例 #1
0
        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;
            }
        }
コード例 #2
0
        /// <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);
        }
コード例 #3
0
ファイル: Program.cs プロジェクト: jsjxrj/GFF
        private static void Client2_OnLogined(object sender, string msg)
        {
            var client2 = sender as MessageClient;

            client2.SubscribeAsync("all");

            FunHelper.WhileAsync(() =>
            {
                client2.SendPrivateMsg(uid1, "你好姗姗,我是思思");
            }, 1000, true);
        }
コード例 #4
0
        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();
        }
コード例 #5
0
ファイル: Program.cs プロジェクト: jsjxrj/GFF
 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);
     });
 }
コード例 #6
0
ファイル: CommandInfoController.cs プロジェクト: luoBoB/mygit
        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));
        }
コード例 #7
0
        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);
        }
コード例 #8
0
ファイル: MainForm.cs プロジェクト: iZhongCheng/CodeGenerator
        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);
        }
コード例 #9
0
        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;
        }
コード例 #10
0
 public void GetCallingVersionTest()
 {
     Assert.IsNotNull(FunHelper.GetCallingVersion());
 }
コード例 #11
0
ファイル: Program.cs プロジェクト: luoBoB/mygit
        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);
            //}
        }
コード例 #12
0
        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);
        }
コード例 #13
0
        /// <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);
        }
コード例 #14
0
ファイル: Program.cs プロジェクト: DevStudy/GitStudy
 static void Main(string[] args)
 {
     Console.WriteLine($"CallingVersion:{FunHelper.GetCallingVersion()}");
     Console.WriteLine($"Version:{FunHelper.GetVersion()}");
     Console.Read();
 }