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();
}
