/// <summary>
/// 获取区域列表
/// </summary>
/// <param name="req"></param>
/// <param name="size"></param>
/// <returns></returns>
public List <AllInOne_AreaInfo> GetList(AreaReq req, int size, int userId, int lv)
{
var search = req.search ?? "";
var order = req.orderField;
var desc = Convert.ToBoolean(req.isDesc);
var index = Convert.ToInt32(req.pageIndex);
//var size = 5;
var orderStr = $"order by {order} ";
if (desc)
{
orderStr += " desc ";
}
else
{
orderStr += " asc ";
}
var dict = new Dictionary <string, string>
{
{ "@search", $"%{search}%" }
};
var condition = " isDeleted=0 ";
if (lv != 100)
{
condition += $" and createUserId={userId}";
}
if (!search.IsNullOrEmpty())
{
condition += " and name like @search ";
}
return(SqlHelper.Instance.GetViewPaging <AllInOne_AreaInfo>("AllInOne_AreaInfo", "select * from AllInOne_AreaInfo ", condition, index, size, orderStr, dict));
}
public string GetAreaList(AreaReq req)
{
var userId = Convert.ToInt32(Session["userId"]);
var lv = Convert.ToInt32(Session["lv"]);
var r = AllFunc.Instance.GetAreaList(req, userId, lv);
return(JsonConvert.SerializeObject(r));
}
/// <summary>
/// 获取区域列表总数
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public int GetCount(AreaReq req, int userId, int lv)
{
var search = req.search ?? "";
var dict = new Dictionary <string, string>
{
{ "@search", $"%{search}%" }
};
var condition = " isDeleted=0 ";
if (lv != 100)
{
condition += $" and createUserId={userId}";
}
if (!search.IsNullOrEmpty())
{
condition += " and name like @search ";
}
var list = SqlHelper.Instance.GetDistinctCount <AllInOne_AreaInfo>("AllInOne_AreaInfo", condition, dict);
return(list.Count);
}
