/// <summary> /// 获取意见反馈信息 /// </summary> /// <param name="suggestionId">意见编号</param> /// <returns></returns> public virtual EyouSoft.Model.SystemStructure.ProductSuggestionInfo GetSuggestionInfo(string suggestionId) { EyouSoft.Model.SystemStructure.ProductSuggestionInfo info = null; DbCommand cmd = base.SystemStore.GetSqlStringCommand(SQL_SELECT_GetSuggestionInfo); base.SystemStore.AddInParameter(cmd, "SuggestionId", DbType.AnsiStringFixedLength, suggestionId); using (IDataReader rdr = DbHelper.ExecuteReader(cmd, base.SystemStore)) { if (rdr.Read()) { info = new EyouSoft.Model.SystemStructure.ProductSuggestionInfo(); info.SuggestionId = rdr.GetString(rdr.GetOrdinal("Id")); info.SuggestionType = (EyouSoft.Model.SystemStructure.ProductSuggestionType)rdr.GetByte(rdr.GetOrdinal("TypeId")); info.CompanyId = rdr["CompanyId"].ToString(); info.CompanyName = rdr["CompanyName"].ToString(); info.ContactName = rdr["ContactName"].ToString(); info.ContactTel = rdr["ContactTel"].ToString(); info.ContactMobile = rdr["ContactMobile"].ToString(); info.QQ = rdr["QQ"].ToString(); info.MQ = rdr["MQ"].ToString(); info.ContentText = rdr["ContentText"].ToString(); info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); } } return(info); }
protected void AddNewMessage(string type) { EyouSoft.IBLL.SystemStructure.IProductSuggestion IBll = EyouSoft.BLL.SystemStructure.ProductSuggestion.CreateInstance(); EyouSoft.Model.SystemStructure.ProductSuggestionType pst = EyouSoft.Model.SystemStructure.ProductSuggestionType.商铺; switch (type) { case "1": pst = EyouSoft.Model.SystemStructure.ProductSuggestionType.商铺; break; case "2": pst = EyouSoft.Model.SystemStructure.ProductSuggestionType.MQ; break; case "3": pst = EyouSoft.Model.SystemStructure.ProductSuggestionType.平台; break; case "4": pst = EyouSoft.Model.SystemStructure.ProductSuggestionType.个人中心; break; default: pst = EyouSoft.Model.SystemStructure.ProductSuggestionType.平台; break; } EyouSoft.Model.SystemStructure.ProductSuggestionInfo model = new EyouSoft.Model.SystemStructure.ProductSuggestionInfo(); model.CompanyName = Utils.InputText(this.txtCompany.Value); model.ContactName = Utils.InputText(this.txtComtact.Value); model.ContactTel = Utils.InputText(this.txtTelPhone.Value); model.ContentText = Utils.InputText(this.txtContentText.Value); model.IssueTime = DateTime.Now; model.ContactMobile = this.hideMobile.Value; model.MQ = this.hideMQ.Value; model.QQ = this.hideQQ.Value; model.SuggestionType = pst; //新增 IBll.InsertSuggestionInfo(model); }
/// <summary> /// 添加新的价格等级 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected bool InsertPrice() { string PriceName = Request.QueryString["PriceName"]; if (string.IsNullOrEmpty(PriceName)) { MessageBox.Show(this, "请输入价格等级名称!!"); return(false); } else { EyouSoft.IBLL.SystemStructure.IProductSuggestion bll = EyouSoft.BLL.SystemStructure.ProductSuggestion.CreateInstance(); EyouSoft.Model.SystemStructure.ProductSuggestionInfo model = new EyouSoft.Model.SystemStructure.ProductSuggestionInfo(); model.CompanyId = CompanyId; model.CompanyName = UserInfoModel.CompanyName; if (UserInfoModel.ContactInfo != null) { model.ContactMobile = UserInfoModel.ContactInfo.Mobile; model.ContactName = UserInfoModel.ContactInfo.ContactName; model.ContactTel = UserInfoModel.ContactInfo.Tel; model.MQ = UserInfoModel.ContactInfo.MQ; model.QQ = UserInfoModel.ContactInfo.QQ; } model.ContentText = PriceName; model.SuggestionId = Guid.NewGuid().ToString(); model.SuggestionType = EyouSoft.Model.SystemStructure.ProductSuggestionType.个人中心报价标准; bool Result = bll.InsertSuggestionInfo(model); model = null; bll = null; return(Result); } }
/// <summary> /// 写入意见反馈信息 /// </summary> /// <param name="info">意见反馈信息业务实体</param> /// <returns></returns> public virtual bool InsertSuggestionInfo(EyouSoft.Model.SystemStructure.ProductSuggestionInfo info) { DbCommand cmd = base.SystemStore.GetSqlStringCommand(SQL_INSERT_InsertSuggestionInfo); base.SystemStore.AddInParameter(cmd, "ID", DbType.String, info.SuggestionId); base.SystemStore.AddInParameter(cmd, "TypeID", DbType.Byte, (int)info.SuggestionType); base.SystemStore.AddInParameter(cmd, "CompanyID", DbType.String, info.CompanyId); base.SystemStore.AddInParameter(cmd, "CompanyName", DbType.String, info.CompanyName); base.SystemStore.AddInParameter(cmd, "ContactName", DbType.String, info.ContactName); base.SystemStore.AddInParameter(cmd, "ContactTel", DbType.String, info.ContactTel); base.SystemStore.AddInParameter(cmd, "ContactMobile", DbType.String, info.ContactMobile); base.SystemStore.AddInParameter(cmd, "QQ", DbType.String, info.QQ); base.SystemStore.AddInParameter(cmd, "MQ", DbType.String, info.MQ); base.SystemStore.AddInParameter(cmd, "ContentText", DbType.String, info.ContentText); return(DbHelper.ExecuteSql(cmd, base.SystemStore) == 1 ? true : false); }
/// <summary> /// 获取意见反馈信息集合 /// </summary> /// <param name="pageSize">每页显示记录数</param> /// <param name="pageIndex">当前页索引</param> /// <param name="recordCount">总记录数</param> /// <param name="companyName">公司名称 为null时不做为查询条件</param> /// <param name="contactName">联系人 为null时不做为查询条件</param> /// <param name="content">内容 为null时不做为查询条件</param> /// <param name="suggestionType">意见反馈类别 为null时不做为查询条件</param> /// <returns></returns> public virtual IList <EyouSoft.Model.SystemStructure.ProductSuggestionInfo> GetSuggestions(int pageSize, int pageIndex, ref int recordCount , string companyName, string contactName, string content, params EyouSoft.Model.SystemStructure.ProductSuggestionType[] suggestionType) { IList <EyouSoft.Model.SystemStructure.ProductSuggestionInfo> suggestions = new List <EyouSoft.Model.SystemStructure.ProductSuggestionInfo>(); StringBuilder cmdQuery = new StringBuilder(); string tableName = "tbl_ProductSuggestion"; string primaryKey = "Id"; string orderByString = "IssueTime DESC"; string fields = "*"; #region 拼接查询条件 cmdQuery.Append(" 1=1 "); if (suggestionType != null) { if (suggestionType.Length == 1) { cmdQuery.AppendFormat(" AND TypeId={0} ", (int)suggestionType[0]); } else if (suggestionType.Length > 1) { cmdQuery.Append(" AND TypeId IN ("); cmdQuery.Append((int)suggestionType[0]); for (int i = 1; i < suggestionType.Length; i++) { cmdQuery.Append(" ," + (int)suggestionType[i]); } cmdQuery.Append(" ) "); } } if (!string.IsNullOrEmpty(companyName)) { cmdQuery.AppendFormat(" AND CompanyName LIKE '%{0}%' ", companyName); } if (!string.IsNullOrEmpty(contactName)) { cmdQuery.AppendFormat(" AND ContactName LIKE '%{0}%' ", contactName); } if (!string.IsNullOrEmpty(content)) { cmdQuery.AppendFormat(" AND ContentText LIKE '%{0}%' ", content); } #endregion using (IDataReader rdr = DbHelper.ExecuteReader(base.SystemStore, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, cmdQuery.ToString(), orderByString)) { while (rdr.Read()) { EyouSoft.Model.SystemStructure.ProductSuggestionInfo info = new EyouSoft.Model.SystemStructure.ProductSuggestionInfo(); info.SuggestionId = rdr.GetString(rdr.GetOrdinal("Id")); info.SuggestionType = (EyouSoft.Model.SystemStructure.ProductSuggestionType)rdr.GetByte(rdr.GetOrdinal("TypeId")); info.CompanyId = rdr["CompanyId"].ToString(); info.CompanyName = rdr["CompanyName"].ToString(); info.ContactName = rdr["ContactName"].ToString(); info.ContactTel = rdr["ContactTel"].ToString(); info.ContactMobile = rdr["ContactMobile"].ToString(); info.QQ = rdr["QQ"].ToString(); info.MQ = rdr["MQ"].ToString(); info.ContentText = rdr["ContentText"].ToString(); info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); suggestions.Add(info); } } return(suggestions); }
/// <summary> /// 写入意见反馈信息 /// </summary> /// <param name="info">意见反馈信息业务实体</param> /// <returns></returns> public bool InsertSuggestionInfo(EyouSoft.Model.SystemStructure.ProductSuggestionInfo info) { info.SuggestionId = Guid.NewGuid().ToString(); return(dal.InsertSuggestionInfo(info)); }