public List <string> GetResults(string Txt, string Xpath, T parm)
{
List <String> list = new List <string>();
HtmlAgilityPack.HtmlDocument doc = new HtmlDocument();
doc.LoadHtml(Txt);
var nodes = doc.DocumentNode.SelectNodes(Xpath);
XpathPam xpathparm = BaseParm.ConvertParm <XpathPam>(parm);
if (nodes?.Count > 0)
{
foreach (var node in nodes)
{
//null 校验是否存在
if (xpathparm.InnerHtml)
{
list.Add(node.InnerHtml);
}
//非null校验值
else if (!String.IsNullOrEmpty(xpathparm.Attr))
{
list.Add(node.Attributes[xpathparm.Attr]?.Value);
}
else
{
list.Add(node.InnerText);
}
}
}
return(list);
}
public bool Check(string Txt, string Xpath, T parm)
{
HtmlAgilityPack.HtmlDocument doc = new HtmlDocument();
doc.LoadHtml(Txt);
var node = doc.DocumentNode.SelectSingleNode(Xpath);
XpathPam xpathparm = BaseParm.ConvertParm <XpathPam>(parm);
if (node == null)
{
return(false);
}
//null 校验是否存在
if (String.IsNullOrEmpty(xpathparm.CheckStr))
{
return(true);
}
//非null校验值
else
{
String value = String.Empty;
//没有属性值直接取innertext
if (!String.IsNullOrEmpty(xpathparm.Attr))
{
value = node.InnerText;
}
else
{
value = node.Attributes[xpathparm.Attr]?.Value;
}
return(value.Equals(xpathparm.CheckStr, xpathparm.caseoption));
}
}
public string GetResult(string Txt, string Xpath, T parm)
{
HtmlAgilityPack.HtmlDocument doc = new HtmlDocument();
doc.LoadHtml(Txt);
var node = doc.DocumentNode.SelectSingleNode(Xpath);
XpathPam xpathparm = BaseParm.ConvertParm <XpathPam>(parm);
if (node == null)
{
return(String.Empty);
}
//null 校验是否存在
if (xpathparm.InnerHtml)
{
return(node.InnerHtml);
}
//非null校验值
else if (!String.IsNullOrEmpty(xpathparm.Attr))
{
return(node.Attributes[xpathparm.Attr]?.Value);
}
else
{
return(node.InnerText);
}
}
public Page <PriceEx> List(BaseParm parm)
{
var page = new Page <PriceEx>(parm);
var strSql = new StringBuilder();
strSql.Append(@"SELECT p.*,p1.ID ProductID ,p1.`Name` ,p1.TypeID,p1.TypeName ,s.Amount
FROM product p1
LEFT JOIN productprice p on p.ProductID =p1.ID
LEFT JOIN store s ON s.ProductID=p1.ID AND p.UnitID=s.UnitID ");
strSql.Append(" WHERE p1.IsActive=1");
if (!string.IsNullOrEmpty(parm.Id))
{
strSql.Append(" AND p1.ID = @Id");
}
if (!string.IsNullOrEmpty(parm.Name))
{
parm.Name = "%" + parm.Name + "%";
strSql.Append(" AND p1.Name like @Name");
}
if (!string.IsNullOrEmpty(parm.Type))
{
strSql.Append(" AND p1.TypeName like @Type");
}
var list = _db.Page <PriceEx>(parm.page, parm.rows, strSql.ToString(), parm);
page.rows = list.Items;
page.total = (int)list.TotalItems;
return(page);
}
/// <summary>
///
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public JsonResult GetType(BaseParm parm)
{
parm.Id = UserInfo.StationId;
var json = _typeBll.List(parm);
return(Json(json));
}
public Page<OrderData> List(BaseParm parm)
{
var page = new Page<OrderData>(parm);
var strSql = new StringBuilder();
strSql.Append("select ID,OrderNo,State,UserID,UserName,PMoney,Money,Amount,CreateDate,Remark,Address,SendTime,Phone,SendType,SendMoney from `order` where 1=1");
strSql.Append(" And UserID=@Id");
if (parm.Type != "全部")
{
strSql.Append(" AND State = @Type");
}
strSql.Append(" ORDER BY CreateDate DESC");
var list = _db.SkipTake<OrderData>(parm.page * parm.rows, parm.rows, strSql.ToString(), parm);
if (list.Any())
{
var details = _db.Query<OrderDetail>(@"select o.*,p1.Url from orderdetail o
LEFT JOIN product p ON p.ID=o.ProductID
LEFT JOIN (SELECT * FROM productimg n WHERE n.RowNO=0) p1 ON p1.ProductID=p.ID
where o.orderno in (@0)", list.Select(n => n.OrderNo)).ToList();
list.ForEach(n =>
{
n.Detail = details.Where(m => m.OrderNo == n.OrderNo).ToList();
});
}
page.rows = list;
return page;
}
public List <string> GetResults(string Txt, string Jpath, T parm)
{
Txt = Txt?.Trim();
List <String> list = new List <string>();
JToken token = default;
if (Txt.StartsWith("{") && Txt.EndsWith("}"))
{
token = JsonConvert.DeserializeObject(Txt) as JObject;
}
else if (Txt.StartsWith("[") && Txt.EndsWith("]"))
{
token = JsonConvert.DeserializeObject(Txt) as JArray;
}
if (token != null)
{
JsonParm jsonam = BaseParm.ConvertParm <JsonParm>(parm);
var tokens = token.SelectTokens(Jpath);
if (tokens?.Count() > 0)
{
list = (from a in tokens select Convert.ToString(a))?.ToList();
}
}
return(list);
}
public bool Check(string Txt, string Reg, T parm)
{
if (!String.IsNullOrEmpty(Txt))
{
RegexPam regexPam = BaseParm.ConvertParm <RegexPam>(parm);
Regex reg = new Regex(Reg, regexPam.Options);
return(reg.IsMatch(Txt));
}
return(false);
}
public Page <address> GetList(BaseParm parm)
{
var page = new Page <address>(parm);
var strSql = new StringBuilder();
strSql.Append("select * from address where userid=@Id");
var list = address.Page(parm.page, parm.rows, strSql.ToString(), parm);
page.rows = list.Items;
page.total = (int)list.TotalItems;
return(page);
}
public Page <FavoriteEx> List(BaseParm parm)
{
var page = new Page <FavoriteEx>(parm);
var strSql = new StringBuilder();
strSql.Append(@"SELECT f.*,p.Price,p.MemberPrice MPrice
FROM FAVORITE f
LEFT JOIN price p ON p.ProductID=f.ProductID AND p.UnitName=f.UserName");
strSql.Append(" Where f.UserID=@Id");
var list = _db.Page <FavoriteEx>(parm.page, parm.rows, strSql.ToString(), parm);
page.rows = list.Items;
page.total = (int)list.TotalItems;
return(page);
}
public String GetResult(string Txt, string Regstr, T parm)
{
String retStr = String.Empty;
if (!String.IsNullOrEmpty(Txt))
{
RegexPam regexPam = BaseParm.ConvertParm <RegexPam>(parm);
Regex reg = new Regex(Regstr, regexPam.Options);
var match = reg.Match(Txt);
if (match?.Groups?.Count >= regexPam.Group)
{
retStr = reg.Match(Txt).Groups[regexPam.Group].Value;
}
}
return(retStr);
}
public ApiMessage <List <StoreGood> > GetGoods(BaseParm parm)
{
var page = new ApiMessage <List <StoreGood> >();
var strSql = new StringBuilder();
strSql.Append(@"SELECT DISTINCT p.ID,p.Name,p.TypeID,p1.Url,p2.Price,p2.MemberPrice,p2.LimitNum,p2.UnitName,p2.UnitID,s.Amount ,s.OutAmount
FROM product p
LEFT JOIN(SELECT * FROM productimg n WHERE n.RowNO = 0) p1 ON p.ID = p1.ProductID
LEFT JOIN productprice p2 ON p.ID = p2.ProductID
INNER JOIN store s ON p.ID = s.ProductID AND p2.UnitID = s.UnitID
LEFT JOIN producttype p3 ON p.TypeID = p3.ID
WHERE p.IsActive = 1 AND s.Amount>0 ");
if (!string.IsNullOrEmpty(parm.Name))
{
strSql.Append(" And p.name like CONCAT('%',@name,'%')");
}
if (parm.Type == "2")
{
if (parm.Code == "1")
{
strSql.Append(" ORDER BY p2.Price Desc");
}
else
{
strSql.Append(" ORDER BY p2.Price ");
}
}
else if (parm.Type == "1")
{
strSql.Append(" ORDER BY s.OutAmount desc");
}
else
{
strSql.Append(" ORDER BY p3.OrderByNo, p3.CreateDate, p.OrderByNo ");
}
strSql.Append(" LIMIT @m,@n");
var list =
_db.Fetch <StoreGood>(strSql.ToString(), new
{
name = parm.Name,
m = (parm.page - 1) * parm.rows,
n = parm.rows
});
page.Data = list;
return(page);
}
public Page <store> List(BaseParm parm)
{
var page = new Page <store>(parm);
var strSql = new StringBuilder();
strSql.Append(" where 1=1");
if (!string.IsNullOrEmpty(parm.Name))
{
parm.Name = "%" + parm.Name + "%";
strSql.Append(" AND ProductName like @Name");
}
var list = store.Page(parm.page, parm.rows, strSql.ToString(), parm);
page.rows = list.Items;
page.total = (int)list.TotalItems;
return(page);
}
/// <summary>
/// 指定商铺下的所有商品
/// </summary>
/// <returns></returns>
public ApiMessage <List <StoreGood> > GetAllGood(BaseParm parm)
{
var api = new ApiMessage <List <StoreGood> >();
var strSql = new StringBuilder();
strSql.Append(@"SELECT p.ID,p.Name,p.TypeID,p1.Url,p2.Price,p2.MemberPrice,p2.LimitNum,p2.UnitName,p2.UnitID,s.Amount
FROM product p
LEFT JOIN(SELECT * FROM productimg n WHERE n.RowNO = 0) p1 ON p.ID = p1.ProductID
LEFT JOIN productprice p2 ON p.ID = p2.ProductID
INNER JOIN store s ON p.ID = s.ProductID AND p2.UnitID = s.UnitID
LEFT JOIN producttype p3 ON p.TypeID=p3.ID
WHERE p.IsActive = 1 ORDER BY p3.OrderByNo, p3.CreateDate, p.OrderByNo
");
api.Data = _db.Fetch <StoreGood>(strSql.ToString()).ToList();
return(api);
}
/// <summary>
/// 指定商铺下的所有商品
/// </summary>
/// <returns></returns>
public ApiMessage <List <StoreGood> > GetAllGood(string userId, BaseParm parm)
{
var res = _dal.GetAllGood(parm);
if (!string.IsNullOrEmpty(userId))
{
var cartList = new CartDAL().List(userId);
res.Data.ForEach(n =>
{
var node = cartList.Data.FirstOrDefault(m => n.ID == m.ProductID);
if (node != null)
{
n.SelectAmount = node.Amount;
}
});
}
return(res);
}
public Page <swiper> List(BaseParm parm)
{
var page = new Page <swiper>(parm);
var strSql = new StringBuilder();
strSql.Append(" where 1=1");
if (!string.IsNullOrEmpty(parm.Name))
{
parm.Name = "%" + parm.Name + "%";
strSql.Append(" AND ProductName like @Name");
}
strSql.Append(" order by CreateDate Desc");
page.rows = swiper.Fetch(strSql.ToString(), parm)
.Take(parm.rows)
.Skip((parm.page - 1) * parm.rows)
.ToList();
page.total =
_db.FirstOrDefault <int>("select count(1) from Swiper " + strSql, parm);
return(page);
}
public bool Check(string Txt, string Jpath, T parm = null)
{
Txt = Txt?.Trim();
JToken token = default;
if (Txt.StartsWith("{") && Txt.EndsWith("}"))
{
token = JsonConvert.DeserializeObject(Txt) as JObject;
}
else if (Txt.StartsWith("[") && Txt.EndsWith("]"))
{
token = JsonConvert.DeserializeObject(Txt) as JArray;
}
if (token != null)
{
JsonParm jsonam = BaseParm.ConvertParm <JsonParm>(parm);
String str = Convert.ToString(token.SelectToken(Jpath));
return(str.Equals(jsonam.CheckStr, jsonam.caseoption));
}
return(false);
}
public string GetResult(string Txt, string Jpath, T parm)
{
Txt = Txt?.Trim();
JToken token = default;
if (Txt.StartsWith("{") && Txt.EndsWith("}"))
{
token = JsonConvert.DeserializeObject(Txt) as JObject;
}
else if (Txt.StartsWith("[") && Txt.EndsWith("]"))
{
token = JsonConvert.DeserializeObject(Txt) as JArray;
}
if (token != null)
{
JsonParm jsonam = BaseParm.ConvertParm <JsonParm>(parm);
String str = Convert.ToString(token.SelectToken(Jpath));
return(str);
}
return(String.Empty);
}
public List <String> GetResults(string Txt, string Regstr, T parm)
{
List <String> list = new List <String>();
if (!String.IsNullOrEmpty(Txt))
{
RegexPam regexPam = BaseParm.ConvertParm <RegexPam>(parm);
if (!String.IsNullOrEmpty(Regstr))
{
Regex reg = new Regex(Regstr, regexPam.Options);
var matches = reg.Matches(Txt);
foreach (Match match in matches)
{
if (match?.Groups?.Count >= regexPam.Group)
{
list.Add(match.Groups[regexPam.Group].Value);
}
}
}
}
return(list);
}
public Page <userinfo> List(BaseParm parm)
{
var page = new Page <userinfo>(parm);
var strSql = new StringBuilder();
strSql.Append(" where 1=1");
if (!string.IsNullOrEmpty(parm.Name))
{
parm.Name = "%" + parm.Name + "%";
strSql.Append(" AND UserName like @Name");
}
if (!string.IsNullOrEmpty(parm.Code))
{
parm.Code = "%" + parm.Code + "%";
strSql.Append(" AND UserCode like @Code");
}
var list = userinfo.Page(parm.page, parm.rows, strSql.ToString(), parm);
page.rows = list.Items;
page.total = (int)list.TotalItems;
return(page);
}
public Page<order> ListByPage(BaseParm parm)
{
var page = new Page<order>(parm);
var strSql = new StringBuilder();
strSql.Append(" where 1=1");
if (!string.IsNullOrEmpty(parm.Name))
{
parm.Name = "%" + parm.Name + "%";
strSql.Append(" AND UserName like @Name");
}
if (!string.IsNullOrEmpty(parm.Type))
{
strSql.Append(" AND State = @Type");
}
if (!string.IsNullOrEmpty(parm.Code))
{
strSql.Append(" AND OrderNo = @Code");
}
if (parm.Query == "1")
{
parm.Query = "配送中";
strSql.Append(" AND SendState = @Query");
}
if (parm.End!=null) {
parm.End = parm.End.Value.AddDays(1);
strSql.Append(" AND CreateDate <@End");
}
if (parm.Start != null)
{
strSql.Append(" AND CreateDate >@Start");
}
var list = _db.Page<order>(parm.page, parm.rows, strSql.ToString(), parm);
page.rows = list.Items;
page.total = (int)list.TotalItems;
return page;
}
public ApiMessage <Good> GetGood(BaseParm parm)
{
var res = new ApiMessage <Good>();
var good = new Good();
var p = _dal.Get(parm.Id).Data;
if (string.IsNullOrEmpty(p?.ID))
{
res.Success = false;
res.Msg = "商品不存在";
return(res);
}
good.ID = p.ID;
good.Name = p.Name;
good.ImgList = p.Imgs.Select(n => new Img {
Url = n.url
}).ToList();
good.Detail = p.Detail;
parm.page = 1;
parm.rows = 1000;
var prices = _priceDal.List(parm).rows;
foreach (var ex in prices)
{
var s = new Spec();
s.ID = ex.UnitID;
s.Name = ex.Name;
s.MPrice = ex.MemberPrice;
s.Price = ex.Price;
s.StoreAmount = ex.Amount;
good.SpecList.Add(s);
}
res.Data = good;
return(res);
}
/// <summary>
///
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public JsonResult List(BaseParm parm)
{
var list = _bll.List(parm);
return(Json(list));
}
public Page <address> GetList(BaseParm parm)
{
return(dal.GetList(parm));
}
public Page <FavoriteEx> List(BaseParm parm)
{
return(_dal.List(parm));
}
public ApiMessage <List <StoreGood> > GetGoods(BaseParm parm)
{
return(_dal.GetGoods(parm));
}
public Page <product> List(BaseParm parm)
{
return(_dal.List(parm));
}
public Page <PriceEx> List(BaseParm parm)
{
return(_dal.List(parm));
}
/// <summary>
///
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public JsonResult List(BaseParm parm)
{
var json = _proBll.List(parm);
return(Json(json));
}
public Page <userinfo> List(BaseParm parm)
{
return(_dal.List(parm));
}
