public static FeedBack GetFeedBackDetail(string id)
{
DataTable dt = FeedBackDAL.BaseProvider.GetFeedBackDetail(id);
FeedBack model = new FeedBack();
if (dt.Rows.Count > 0)
{
model.FillData(dt.Rows[0]);
}
return(model);
}
public static List <FeedBack> GetFeedBacks(string keywords, string userID, string beginDate, string endDate, int type, int status, int pageSize, int pageIndex, out int totalCount, out int pageCount)
{
string sqlWhere = "1=1";
if (!string.IsNullOrEmpty(keywords))
{
sqlWhere += " and (Title like '%" + keywords + "%'";
sqlWhere += " or ContactName like '%" + keywords + "%'";
sqlWhere += " or MobilePhone like '%" + keywords + "%'";
sqlWhere += " or Remark like '%" + keywords + "%' )";
}
if (!string.IsNullOrEmpty(userID))
{
sqlWhere += " and CreateUserID='" + userID + "'";
}
if (status != -1)
{
sqlWhere += " and status=" + status;
}
if (type != -1)
{
sqlWhere += " and type=" + type;
}
if (!string.IsNullOrEmpty(beginDate))
{
sqlWhere += " and createtime>='" + beginDate + "'";
}
if (!string.IsNullOrEmpty(endDate))
{
sqlWhere += " and createtime<='" + DateTime.Parse(endDate).AddDays(1).ToString("yyyy-MM-dd") + "'";
}
DataTable dt = CommonBusiness.GetPagerData("FeedBack", "*", sqlWhere, "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <FeedBack> list = new List <FeedBack>();
FeedBack model;
foreach (DataRow item in dt.Rows)
{
model = new FeedBack();
model.FillData(item);
list.Add(model);
}
return(list);
}
