/// <summary>
/// 新增建议反馈
/// </summary>
public static bool InsertFeedBack(FeedBack model)
{
//string temFilePath = model.FilePath;
//string fileUrl = string.Empty;
//if (!string.IsNullOrEmpty(temFilePath))
//{
// if (temFilePath.IndexOf("?") > 0)
// {
// temFilePath = temFilePath.Substring(0, temFilePath.IndexOf("?"));
// }
// FileInfo file = new FileInfo(HttpContext.Current.Server.MapPath(temFilePath));
// fileUrl = FilePath + file.Name;
// if (file.Exists)
// {
// file.MoveTo(HttpContext.Current.Server.MapPath(fileUrl));
// }
//}
//model.FilePath = fileUrl;
return FeedBackDAL.BaseProvider.InsertFeedBack(model.Title, model.ContactName, model.MobilePhone,
model.Type, model.FilePath, model.Remark, model.CreateUserID);
}
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;
}
