private static void Test_UrlInfo()
{
var model = new UrlInfo
{
Url = "http:www.baidu.com",
UrlMd5 = "atSDsdfsfsfsdsffw",
ShortVal = "adEwF",
Comment = "百度",
State = 1,
CreateTime = DateTime.Now
};
var urlInfoDao=new UrlInfoDao();
var isOkDelete = urlInfoDao.DeleteById(1);
var id = urlInfoDao.Add(model);
var isOkUpdate = urlInfoDao.UpdateById(new UrlInfo() {Comment = "百度update"}, id);
var model01 = urlInfoDao.FindById(id);
var whereModel = new UrlInfo { Id = id };
var model02 = urlInfoDao.FindList(whereModel, "id=@id", 1);
//---
//---
//todo where--比较推荐的写法--可以提高程序的可读性
var where = new WhereEntity<UrlInfo>()
{
Model = new UrlInfo() { Id = id },
Sql = "id=@id",
OrderBy = "id"
};
//
var model03 = urlInfoDao.FindListByPage(where.Model, where.Sql, where.OrderBy, 0, 10);
var count = urlInfoDao.Count(where.Model, where.Sql);
}
private static void Test_Person()
{
var model = new Person
{
Username = "******",
Password = "******",
Age = 1
};
var personDao=new PersonDao();
var isOkDelete = personDao.DeleteById(1);
var id = personDao.Add(model);
var isOkUpadte = personDao.UpdateById(new Person() {Username = "******"}, id);
var model01 = personDao.FindById(id);
var whereModel = new Person {Id = id};
var model02 = personDao.FindList(whereModel, "id=@id", 1);
//---
#region where--比较推荐的写法--可以提高程序的可读性
var where = new WhereEntity<Person>()
{
Model = new Person() { Id = id },
Sql = "id=@id",
OrderBy="id"
};
//
var model03 = personDao.FindListByPage(where.Model, where.Sql, where.OrderBy, 0, 10);
var count = personDao.Count(where.Model, where.Sql);
#endregion
}
private static void Test_Person()
{
var model = new Person
{
Username = "******",
Password = "******",
Age = 1
};
var personDao = new PersonDao();
var isOkDelete = personDao.DeleteById(1);
var id = personDao.Add(model);
var isOkUpadte = personDao.UpdateById(new Person()
{
Username = "******"
}, id);
var model01 = personDao.FindById(id);
var whereModel = new Person {
Id = id
};
var model02 = personDao.FindList(whereModel, "id=@id", 1);
//---
#region where--比较推荐的写法--可以提高程序的可读性
var where = new WhereEntity <Person>()
{
Model = new Person()
{
Id = id
},
Sql = "id=@id",
OrderBy = "id"
};
//
var model03 = personDao.FindListByPage(where.Model, where.Sql, where.OrderBy, 0, 10);
var count = personDao.Count(where.Model, where.Sql);
#endregion
}
/// <summary>
/// 模糊搜索等 + '&price=' + price + '&except=' + except + '&yy=' + yuyi;
/// </summary>
/// <returns></returns>
public ActionResult getPhoneNum(AgentWhereEntity pageInfo)
{
int ipage = pageInfo.page == null ? 1 : int.Parse(pageInfo.page.ToString());
if (pageInfo.orderby == "sale_price")
{
pageInfo.orderby = "price";
}
if (string.IsNullOrEmpty(pageInfo.ordername))
{
pageInfo.orderby = "TelphoneID";//按照最后一位排序
pageInfo.ordername = "desc";
}
string search = "";
if (!string.IsNullOrEmpty(pageInfo.search))
{
search = pageInfo.search;
}
else if (!string.IsNullOrEmpty(pageInfo.precise_num))
{
search = pageInfo.precise_num;
}
WhereEntity whereEntity = new WhereEntity()
{
page = pageInfo.page,
price = pageInfo.price,
Grade = pageInfo.regex,//规律
search = search,
search_is_end = pageInfo.search_is_end,
province = pageInfo.province,
City = pageInfo.city,//小写为城市编号，这里其实是中文带市
orderby = pageInfo.orderby,
ordername = pageInfo.ordername,
nomore = pageInfo.isNormal, //
Operator = pageInfo.isp, //运营商
repeatNumber = pageInfo.repeatNumber,
except = pageInfo.exceptNumber,
moreNumber = pageInfo.moreNumber,
birthdayNumber = pageInfo.birthdayNumber
};
Pagination pagination = new Pagination()
{
rows = 40,
page = ipage,
sidx = pageInfo.orderby,
sord = pageInfo.ordername
};
var data = tlbll.GetPageListH5(pagination, whereEntity.ToJson());
var jsonData = new
{
current_page = pagination.page,
data = data,
last_page = pagination.total,
total = pagination.records,
discount = OperatorAgentProvider.Provider.Current().FuDong//折扣100.相当于不打折
};
return(Json(jsonData));
}
