Exemple #1
0
        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;
        }
Exemple #3
0
        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);
        }