/// <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));
}
