public List <OtherShiyaInfo> SearchList(OtherShiyaSearchInfo searchInfo)
{
using (var conn = new SqlConnection(connectString))
{
string sql = "select * from OtherShiya";
string condition = PrepareCondition(searchInfo).ToString();
if (!string.IsNullOrEmpty(condition))
{
sql += " where " + condition;
}
return(conn.Query <OtherShiyaInfo>(sql).ToList());
}
}
public List <OtherShiyaInfo> SearchList(int currentPage, int pageSize, OtherShiyaSearchInfo searchInfo, ref int count)
{
using (var conn = new SqlConnection(connectString))
{
ShopMssqlPagerClass pc = new ShopMssqlPagerClass();
pc.TableName = "OtherShiya";
pc.Fields = "saleid,shuigongid,shiyaid,customerid,orderId,truename,mobile,address,anname,anmobile,housetype,kaifashang,jiazhuang,kongtiao,guanjian,pushe,baohu,beizhu,zongfa,hunzhuang,huaheng,xiangqian,guolvqi,jietou,baoyastart,baoyaend,yunxing,jiance,shiyaname,shiyamobile,gaozhi,stat,addtime ";
pc.CurrentPage = currentPage;
pc.PageSize = pageSize;
pc.OrderField = "[id]";
pc.MssqlCondition = PrepareCondition(searchInfo);
count = pc.Count;
return(conn.Query <OtherShiyaInfo>(pc).ToList());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//CheckAdminPower("ReadPifa", PowerCheckType.Single);
string action = RequestHelper.GetQueryString <string>("Action");
int id = RequestHelper.GetQueryString <int>("Id");
if (id > 0)
{
switch (action)
{
case "Delete":
//CheckAdminPower("DeleteUserPifa", PowerCheckType.Single);
OtherShiyaBLL.Delete(id);
AdminLogBLL.Add(ShopLanguage.ReadLanguage("DeleteRecord"), "试压记录", id);
break;
default:
break;
}
}
status = RequestHelper.GetQueryString <int>("status");
OtherShiyaSearchInfo Searchmodel = new OtherShiyaSearchInfo();
Searchmodel.mobile = RequestHelper.GetQueryString <string>("mobile");
Searchmodel.truename = RequestHelper.GetQueryString <string>("truename");
if (status >= 0)
{
Searchmodel.stat = status;
}
else
{
status = -1;
}
mobile.Text = Searchmodel.mobile;
truename.Text = Searchmodel.truename;
PageSize = Session["AdminPageSize"] == null ? 20 : Convert.ToInt32(Session["AdminPageSize"]);
var Lists = OtherShiyaBLL.SearchList(CurrentPage, PageSize, Searchmodel, ref Count);
//Count = userList.Count;
AdminPageSize.Text = Session["AdminPageSize"] == null ? "20" : Session["AdminPageSize"].ToString();
BindControl(Lists, RecordList, MyPager);
}
}
/// <summary>
/// 组合搜索条件
/// </summary>
/// <param name="mssqlCondition"></param>
/// <param name="userMessageSearch">UserPifaSeachInfo模型变量</param>
public MssqlCondition PrepareCondition(OtherShiyaSearchInfo SearchInfo)
{
MssqlCondition mssqlCondition = new MssqlCondition();
mssqlCondition.Add("[saleid]", SearchInfo.saleid, ConditionType.Equal);
mssqlCondition.Add("[shuigongid]", SearchInfo.shuigongid, ConditionType.Equal);
mssqlCondition.Add("[shiyaid]", SearchInfo.shiyaid, ConditionType.Equal);
mssqlCondition.Add("[customerid]", SearchInfo.customerid, ConditionType.Equal);
mssqlCondition.Add("[orderId]", SearchInfo.orderId, ConditionType.Equal);
mssqlCondition.Add("[truename]", SearchInfo.truename, ConditionType.Like);
mssqlCondition.Add("[mobile]", SearchInfo.mobile, ConditionType.Like);
mssqlCondition.Add("[address]", SearchInfo.address, ConditionType.Like);
mssqlCondition.Add("[anname]", SearchInfo.anname, ConditionType.Like);
mssqlCondition.Add("[anmobile]", SearchInfo.anmobile, ConditionType.Like);
mssqlCondition.Add("[shiyaname]", SearchInfo.shiyaname, ConditionType.Like);
mssqlCondition.Add("[shiyamobile]", SearchInfo.shiyamobile, ConditionType.Like);
mssqlCondition.Add("[stat]", SearchInfo.stat, ConditionType.Equal);
mssqlCondition.Add("[addtime]", SearchInfo.addtime, ConditionType.MoreOrEqual);
mssqlCondition.Add("[addtime]", SearchInfo.addtime, ConditionType.Less);
return(mssqlCondition);
}
public static List <OtherShiyaInfo> SearchList(int currentPage, int pageSize, OtherShiyaSearchInfo searchInfo, ref int count)
{
return(dal.SearchList(currentPage, pageSize, searchInfo, ref count));
}
public static List <OtherShiyaInfo> SearchList(OtherShiyaSearchInfo searchInfo)
{
return(dal.SearchList(searchInfo));
}
