public void GetProductsWithNRecentReviews()
{
List <Product> list = ToolClass.GetProductsWithNRecentReviews(2);
Assert.AreEqual(1, list.Count);
Assert.AreEqual("HL Mountain Pedal", list[0].Name);
}
public void DownLoadImageTest()
{
string url = "http://wx4.sinaimg.cn/large/68ffaf79gy1fyjxy28gfoj20j60vd4dg.jpg";
string filename = "test" + url.Substring(url.LastIndexOf("."));
ToolClass.DownLoadImage(url, Path.Combine(Environment.CurrentDirectory, "dayImg", filename));
}
private void CreateNewSolution()
{
//Workspace
m_WorkspaceDoc = new WorkSpaceClass();
MAINTREE_UI.ItemsSource = m_WorkspaceDoc.p_Solutions;
ProjectClass prj = new ProjectClass
{
p_Name = "Project1",
p_Pareants = m_WorkspaceDoc.p_Solutions[0]
};
TaskClass tsk = new TaskClass
{
p_Name = "Task1",
p_Pareants = prj
};
ToolClass tl = new ToolClass
{
p_Name = "Tool1",
p_Pareants = tsk
};
m_WorkspaceDoc.p_Solutions[0].p_Projects.Add(prj);
prj.p_Tasks.Add(tsk);
tsk.p_Tools.Add(tl);
m_convTreeviewItem = new ConvTreeViewItem();
}
//最新读取分类方法(采用缓存机制)
public List <parminfo> GetClassNew(string parentid, string middlename, string type)
{
string tempname = string.Empty;
//如果是读取二级分类则传一级分类的id作为缓存值标识
if (type == "1")
{
tempname = parentid;
}
//如果是读取三级级分类则传二级分类的名称作为缓存值标识
else if (type == "2")
{
tempname = middlename;
}
//直接读取一级分类
else
{
tempname = "onelevel";
}
var cache = CacheHelper.GetCache(tempname); //先读取
if (cache == null) //如果没有该缓存
{
var dt = dal.GetClass(parentid, middlename, type);
var enumerable = ToolClass <parminfo> .ConvertDataTableToModel(dt);
CacheHelper.SetCache(tempname, enumerable);//添加缓存
return(enumerable);
}
else
{
var result = (List <parminfo>)cache;//有就直接返回该缓存
return(result);
}
}
private static void AdminCommandHandler()
{
ToolClass.Print("Server is open for requests", ConsoleColor.Green);
while (!finished)
{
string internalCommand = Console.ReadLine();
switch (internalCommand)
{
case "stop":
finished = true;
server.StopServer();
break;
case "cpu":
ToolClass.Print($"Current CPU usage is {Hardware.CPUUsage()}%\nCount of server threads is {Hardware.ThreadCount()}", ConsoleColor.Yellow);
break;
case "req":
ToolClass.Print($"{server.SessionRequestCount} requests are handled in the session", ConsoleColor.Yellow);
break;
default:
break;
}
}
ToolClass.Print("Server closed for HTTP requests", ConsoleColor.Red);
Console.ReadKey();
}
public Jx3ToolClass()
{
serbiglist.Clear();
aslist.Clear();
string[] temp = Jx3OpenTell.GetSerIni();
foreach (var item in temp)
{
string[] additem = item.Split('\t');
if (additem.Length > 9)
{
try
{
serbiglist.Add(additem[1], additem[10].Replace("双线", ""));
aslist.Add(additem[1], additem[0]);
}
catch
{
continue;
}
}
}
var petDic = ToolClass.fileToString("petfu.txt");
var petDicstr = petDic.GetMidStrings(@"'", @"'")[0];
PetServerList = Newtonsoft.Json.JsonConvert.DeserializeObject <Dictionary <string, int> >(petDicstr);
}
public FileResult GetValidateCode()
{
string code = ToolClass.CreateRandomCode(4);
TempData["SecurityCode"] = code;
return(File(ToolClass.CreateValidateGraphic(code), "image/jpeg"));
}
public void GetTotalStandardCostByCategory()
{
double totalCost = ToolClass.GetTotalStandardCostByCategory(new ProductCategory {
Name = "Clothing"
});
Assert.AreEqual(868, totalCost);
}
public void GetProductNamesByVendorName()
{
List <string> list = ToolClass.GetProductNamesByVendorName("Trikes, Inc.");
Assert.AreEqual("Mountain Tire Tube", list[0]);
Assert.AreEqual("HL Mountain Tire", list[1]);
Assert.AreEqual(2, list.Count);
}
public void GetNRecentlyReviewedProducts()
{
List <Product> list = ToolClass.GetNRecentlyReviewedProducts(3);
Assert.AreEqual(3, list.Count);
Assert.AreEqual("HL Mountain Pedal", list[0].Name);
Assert.AreEqual("Road-550-W Yellow, 40", list[1].Name);
Assert.AreEqual("Mountain Bike Socks, M", list[2].Name);
}
public void NProductsFromCategory()
{
List <Product> list = ToolClass.GetNProductsFromCategory("Bikes", 3);
Assert.AreEqual(3, list.Count);
Assert.AreEqual("Mountain-100 Silver, 38", list[0].Name);
Assert.AreEqual("Mountain-100 Silver, 42", list[1].Name);
Assert.AreEqual("Mountain-100 Silver, 44", list[2].Name);
}
public void GetProductsByName()
{
List <Product> list = ToolClass.GetProductsByName("Hex Nut");
Assert.AreEqual(39, list.Count);
foreach (Product product in list)
{
Assert.IsTrue(product.Name.Contains("Hex Nut"));
}
}
public static IEnumerable <wordModel> FindSearchsWord()
{
var cache = CacheHelper.GetCache("commonData_Search"); //先读取
if (cache == null) //如果没有该缓存
{
var dt = new PlasCommon.Common().Getsys_Autokey();
var enumerable = ToolClass <wordModel> .ConvertDataTableToModel(dt);
CacheHelper.SetCache("commonData_Search", enumerable);//添加缓存
return(enumerable);
}
var result = (List <wordModel>)cache;//有就直接返回该缓存
return(result);
}
public async Task <IActionResult> ApplyRules(List <AppRule> appRules, bool applyAll = false)
{
AppConfig appConfig = new AppConfig()
{
Rules = new List <AppRule>()
};
if (applyAll)
{
var appRulesInDb = await db.AppRules.AsNoTracking().Include(s => s.Actions).Include(s => s.Operations)
.Where(s => s.IsDeleted == false).ToListAsync();
appRulesInDb.ForEach(appRuleInDb =>
{
appRuleInDb.Operations = appRuleInDb.Operations.Where(s => s.IsDeleted == false).OrderBy(s => FieldInfo.AllFieldInfos[s.Field].Level)
.ToList();
appRuleInDb.Actions = appRuleInDb.Drop
? new List <AppAction>()
: appRuleInDb.Actions.Where(s => s.IsDeleted == false).OrderBy(s => FieldInfo.AllFieldInfos[s.Field].Level).ToList();
});
appConfig.Rules.AddRange(appRulesInDb);
}
else
{
foreach (AppRule appRule in appRules)
{
var appRuleInDb = await db.AppRules.AsNoTracking().Include(s => s.Actions).Include(s => s.Operations)
.FirstOrDefaultAsync(s => s.Id == appRule.Id && s.IsDeleted == false);
if (appRuleInDb == null)
{
continue;
}
appRuleInDb.Operations = appRuleInDb.Operations.Where(s => s.IsDeleted == false).OrderBy(s => FieldInfo.AllFieldInfos[s.Field].Level).ToList();
appRuleInDb.Actions = appRuleInDb.Drop
? new List <AppAction>()
: appRuleInDb.Actions.Where(s => s.IsDeleted == false).OrderBy(s => FieldInfo.AllFieldInfos[s.Field].Level).ToList();
appConfig.Rules.Add(appRuleInDb);
}
}
string applyStr = ToolClass.XmlSerialize(appConfig);
_redisManager.Instance.GetDatabase().StringSet("CONFIG", applyStr);
_redisManager.Instance.GetDatabase().StringSet("CMD", (int)BackendCommand.Updating);
return(Ok());
}
public JsonResult ContrastSearch()
{
var dt = new DataTable();
string contsval = string.Empty;
if (!string.IsNullOrEmpty(Request["contsval"]))
{
contsval = Request["contsval"].ToString();
dt = bll.GetContrastList(contsval);
var jsonlist = ToolClass <PlasModel.ContrastModel> .ConvertDataTableToModel(dt);//ToolHelper.DataTableToJson(dt);
return(Json(new { data = jsonlist }, JsonRequestBehavior.AllowGet));
}
else
{
return(null);
}
}
/// <summary>
/// 登录
/// </summary>
/// <param name="account"></param>
/// <param name="password"></param>
/// <param name="msg"></param>
/// <param name="flag"></param>
/// <returns></returns>
public DataTable Login(string account, string password, out string msg, out bool flag)
{
DataTable dt = new DataTable();
flag = false;
msg = "登录失败！";
string selectsqlstr = string.Empty;
selectsqlstr = ConfigClass.DicConfig["10000"].ToString();
selectsqlstr += " AND account = @account AND password = @password";
password = ToolClass.Md5Encrypt(password);
List <SqlParameter> paramslist = new List <SqlParameter>()
{
new SqlParameter("account", account),
new SqlParameter("password", password)
};
try
{
DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, selectsqlstr, paramslist.ToArray());
if (ds.Tables.Count > 0)
{
dt = ds.Tables[0];
flag = true;
if (dt.Rows.Count == 0)
{
msg = "无数据";
}
else
{
msg = "登录成功！";
}
}
}
catch (Exception e)
{
flag = false;
msg += e.Message;
}
return(dt);
}
private ERR_RESULT inner_CreatePropertyParams(ToolClass tolObj, XElement tolNode)
{
ERR_RESULT result = new ERR_RESULT();
try
{
XElement paramNode = new XElement("PropertyParams");
//LDH9999 추후 상수값으로 지정되어있음
//LDH8282 xml 수정
XElement classNameNode = new XElement("className", "ID_1");
XElement epochNode = new XElement("epoch", 300);
XElement batch_sizeNode = new XElement("batch_size", 10);
XElement weight_decayNode = new XElement("weight_decay", 0.005);
XElement learning_rateNode = new XElement("learning_rate", "0.0002,0.0001,0.00001");
XElement global_stepNode = new XElement("global_step", "10000,20000");
XElement continue_trainingNode = new XElement("continue_training", 0);
paramNode.Add(classNameNode);
paramNode.Add(epochNode);
paramNode.Add(batch_sizeNode);
paramNode.Add(weight_decayNode);
paramNode.Add(learning_rateNode);
paramNode.Add(global_stepNode);
paramNode.Add(continue_trainingNode);
tolNode.Add(paramNode);
return(result);
}
catch (_XmlException err)
{
result = ErrProcess.SetErrResult(err);
return(result);
}
catch (Exception err)
{
result = ErrProcess.SetErrResult(err);
return(result);
}
}
private static async Task <List <object> > ExecuteAsync(string commandString)
{
List <object> rez = new List <object>();
try
{
NpgsqlCommand command = new NpgsqlCommand(commandString, connection);
NpgsqlDataReader dataReader = (NpgsqlDataReader)await command.ExecuteReaderAsync();
while (await dataReader.ReadAsync())
{
for (int i = 0; i < dataReader.VisibleFieldCount; i++)
{
rez.Add(dataReader.GetValue(i));
}
}
}
catch (Exception e)
{
ToolClass.Print(e.Message, ConsoleColor.Red);
}
return(rez);
}
public override void ProcessRequset(GroupMessageReceivedContext msg, AnalysisMsg nowModel)
{
if (Config.ConfigModel.IsFuncOpen("抽锦鲤"))
{
if (nowModel.What == "抽锦鲤")
{
try
{
var data = ToolClass.GetIni(Path.Combine(AppDomain.CurrentDomain.BaseDirectory,
$"{msg.FromGroup}.ini"));
if (data == null)
{
_mahuaApi.SendGroupMessage(msg.FromGroup).At(msg.FromQq)
.Text($"群成员未导入，请联系管理员").Done();
}
else
{
var allMember = data.ToList();
var str = nowModel.Who;
var orderid = Guid.NewGuid().ToString("N").Substring(0, 5);
_mahuaApi.SendGroupMessage(msg.FromGroup).At(msg.FromQq)
.Text($"5S后,开始从{allMember.Count()}人中抽取幸运锦鲤{str}!").Newline().Text($"锦鲤编号:{orderid}").Done();
System.Threading.Thread.Sleep(5000);
_mahuaApi.SendGroupMessage(msg.FromGroup).Text($"Boom!{orderid}号{str}的锦鲤为！").Newline()
.At(allMember[ToolClass.RandomGet(0, allMember.Count())]).Newline()
.Text("围殴他ヽ(●-`Д´-)ノ！").Done();
}
}
catch
{
successor.ProcessRequset(msg, nowModel);
}
}
}
successor.ProcessRequset(msg, nowModel);
}
public JsonResult MsgSearch(int pageindex, int pagesize, int searchtype)
{
//如果在没有登录的情况下提示用户登录
if (pageindex >= 3 && AccountData == null)
{
return(Json(new { state = "NedLogin", errmsg = "请先登录后在查看！" }, JsonRequestBehavior.AllowGet));
}
string key = string.Empty;
if (!string.IsNullOrWhiteSpace(Request["key"]))
{
key = Request["key"].ToString();
}
string strGuid = string.Empty; //前端传入的GUID
if (!string.IsNullOrWhiteSpace(Request["strGuid"]))
{
strGuid = Request["strGuid"].ToString();
}
var kindid = "";//分类id
if (!string.IsNullOrWhiteSpace(Request["kindid"]))
{
kindid = Request["kindid"].ToString();
}
//二次查询
var Characteristic = string.Empty; //特性
var Use = string.Empty; //用途
var Kind = string.Empty; //种类
var Method = string.Empty; //方法
var Factory = string.Empty; //厂家
var Additive = string.Empty; //添加剂
var AddingMaterial = string.Empty; //增料
var isTow = false;
if (!string.IsNullOrWhiteSpace(Request["Characteristic"]))
{
Characteristic = Request["Characteristic"].ToString();
isTow = true;
}
if (!string.IsNullOrWhiteSpace(Request["Use"]))
{
Use = Request["Use"].ToString();
isTow = true;
}
if (!string.IsNullOrWhiteSpace(Request["Kind"]))
{
Kind = Request["Kind"].ToString();
isTow = true;
}
if (!string.IsNullOrWhiteSpace(Request["Method"]))
{
Method = Request["Method"].ToString();
isTow = true;
}
if (!string.IsNullOrWhiteSpace(Request["Factory"]))
{
Factory = Request["Factory"].ToString();
isTow = true;
}
if (!string.IsNullOrWhiteSpace(Request["Additive"]))
{
Additive = Request["Additive"].ToString();
isTow = true;
}
if (!string.IsNullOrWhiteSpace(Request["AddingMaterial"]))
{
AddingMaterial = Request["AddingMaterial"].ToString();
isTow = true;
}
var jsonstr = new List <ProductSharet>();//产品结果集合
int count = 0;
//产品属性分为两个
var BigType = new List <ProductAttr>();
var SamllType = new List <ProductAttr>();
if (!string.IsNullOrWhiteSpace(key) || searchtype == 0)
{
DataSet ds = new DataSet();
if (isTow)//第二次分页，查询数据
{
ds = bll.GetTwoSearch(pageindex, pagesize, strGuid, Characteristic, Use, Kind, Method, Factory, Additive, AddingMaterial, "");
}
else
{
//根据分类id查询
if (searchtype == 0)
{
ds = bll.GetGeneralSearch(kindid, pageindex, pagesize, strGuid, 0, searchtype);
}
else
{
ds = bll.GetGeneralSearch(key, pageindex, pagesize, strGuid, 0, searchtype);
}
}
if (ds.Tables.Contains("ds") && ds.Tables[0] != null)
{
jsonstr = ToolClass <ProductSharet> .ConvertDataTableToModel(ds.Tables[0]); //ToolHelper.DataTableToJson(ds.Tables[0]);
}
if (ds.Tables.Contains("ds1") && ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
int.TryParse(ds.Tables[1].Rows[0]["totalcount"].ToString(), out count);
}
var dt = new DataTable();
if (ds.Tables.Contains("ds2") && ds.Tables[2] != null && ds.Tables[2].Rows.Count > 0)
{
DataView dv = ds.Tables[2].DefaultView;
dt = dv.ToTable(true, "attribute");
//返回list数据，可以解决特殊字符问题
BigType = ToolClass <ProductAttr> .ConvertDataTableToModel(dt); //ToolHelper.DataTableToJson(dt);
SamllType = ToolClass <ProductAttr> .ConvertDataTableToModel(ds.Tables[2]); // ToolHelper.DataTableToJson(ds.Tables[2]);
}
}
//查询会员登录后已经参与对比的数据
var list = new List <Physics_ContrastModel>();
if (AccountData != null && !string.IsNullOrWhiteSpace(AccountData.UserID))
{
string errMsg = string.Empty;
int counts = 0;
ProductBll bll = new ProductBll();
list = bll.getContrastList(AccountData.UserID, ref counts, ref errMsg);
}
return(Json(new { state = "Success", data = jsonstr, totalCount = count, BigType = BigType, SamllType = SamllType, list = list }, JsonRequestBehavior.AllowGet));
}
public void GetProductVendorByProductName()
{
string name = ToolClass.GetProductVendorByProductName("Bearing Ball");
Assert.AreEqual("Wood Fitness", name);
}
public override void ProcessRequset(GroupMessageReceivedContext msg, AnalysisMsg nowModel)
{
if (Config.ConfigModel.IsFuncOpen("Roll点"))
{
if (nowModel.What.ToLower() == "/roll")
{
_mahuaApi.SendGroupMessage(msg.FromGroup).At(msg.FromQq).Text($"Roll了 {ToolClass.RandomGet(0,100)} 点").Done();
return;
}
}
successor.ProcessRequset(msg, nowModel);
}
