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 beginDate, string endDate, int type, int status,string userID, int pageSize, int pageIndex, out int totalCount, out int pageCount)
{
string sqlWhere = "1=1";
if (type != -1)
{
sqlWhere += " and type="+type;
}
if (status != -1)
{
sqlWhere += " and status="+status;
}
if (!string.IsNullOrEmpty(keywords))
{
sqlWhere += " and status=" + status;
}
if (!string.IsNullOrEmpty(userID))
{
sqlWhere += " and CreateUserID='" + userID + "'";
}
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;
}
public static List<FeedBack> GetFeedBacks(string keywords, string beginDate, string endDate, int type, int status, int pageSize, int pageIndex, out int totalCount, out int pageCount)
{
string sqlWhere = "1=1";
if (type != -1)
{
sqlWhere += " and type="+type;
}
if (status != -1)
{
sqlWhere += " and status="+status;
}
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(beginDate))
{
sqlWhere += " and createtime>=" + beginDate;
}
if (!string.IsNullOrEmpty(endDate))
{
sqlWhere += " and createtime<=" +DateTime.Parse(endDate).AddDays(1);
}
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;
}
/// <summary>
/// 新增建议反馈
/// </summary>
public static bool InsertFeedBack(FeedBack model)
{
string filePath = model.FilePath;
if (!string.IsNullOrEmpty(filePath))
{
if (filePath.IndexOf("?") > 0)
{
filePath = filePath.Substring(0, filePath.IndexOf("?"));
}
FileInfo file = new FileInfo(HttpContext.Current.Server.MapPath(filePath));
filePath = FilePath + file.Name;
if (file.Exists)
{
file.MoveTo(HttpContext.Current.Server.MapPath(filePath));
}
}
model.FilePath = filePath;
return FeedBackDAL.BaseProvider.InsertFeedBack(model.Title, model.ContactName, model.MobilePhone, model.Type, model.FilePath, model.Remark, model.CreateUserID);
}