/// <summary>
/// 获取区域列表
/// </summary>
/// <param name="req"></param>
/// <param name="size"></param>
/// <returns></returns>
public List <AllInOne_ProtocolInfo> GetList(ProtocolListReq req, int size)
{
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 = " 1=1 ";
if (!search.IsNullOrEmpty())
{
condition += " and (protocolName like @search or protocolNo like @search)";
}
return(SqlHelper.Instance.GvpForCommon <AllInOne_ProtocolInfo>("protocolno", "AllInOne_ProtocolInfo", "select * from AllInOne_ProtocolInfo ", condition, index, size, orderStr, dict));
}
/// <summary>
/// 获取区域列表总数
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public int GetCount(ProtocolListReq req)
{
var search = req.search ?? "";
var dict = new Dictionary <string, string>
{
{ "@search", $"%{search}%" }
};
var condition = " 1=1 ";
if (!search.IsNullOrEmpty())
{
condition += " and (protocolName like @search or protocolNo like @search)";
}
var list = SqlHelper.Instance.GdcForCommon <AllInOne_ProtocolInfo>("protocolno", "AllInOne_ProtocolInfo", condition, dict);
return(list.Count);
}
public string GetProtocolList(ProtocolListReq req)
{
var r = AllFunc.Instance.GetProtocolList(req);
return(JsonConvert.SerializeObject(r));
}
