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