/// <summary>
/// 添加营销公司
/// </summary>
/// <param name="item">营销公司实体对象</param>
/// <returns>true:成功 false:失败</returns>
public bool Add(EyouSoft.Model.CommunityStructure.MarketingCompany item)
{
if (item == null)
{
return(false);
}
return(dal.Add(item));
}
/// <summary>
/// 添加营销公司
/// </summary>
/// <param name="item">营销公司实体对象</param>
/// <returns>true:成功 false:失败</returns>
public virtual bool Add(EyouSoft.Model.CommunityStructure.MarketingCompany item)
{
DbCommand comm = this._database.GetSqlStringCommand(SQL_MarketingCompany_Add);
this._database.AddInParameter(comm, "@CompanyName", DbType.String, item.CompanyName);
this._database.AddInParameter(comm, "@ProvinceId", DbType.Int32, item.ProvinceId);
this._database.AddInParameter(comm, "@CityId", DbType.Int32, item.CityId);
this._database.AddInParameter(comm, "@Contact", DbType.String, item.Contact);
this._database.AddInParameter(comm, "@ContactWay", DbType.String, item.ContactWay);
this._database.AddInParameter(comm, "@Question", DbType.String, item.Question);
this._database.AddInParameter(comm, "@Category", DbType.Byte, (int)item.MarketingCompanyType);
return(DbHelper.ExecuteSql(comm, this._database) > 0 ? true : false);
}
protected int type = 0; //提交类型
protected void Page_Load(object sender, EventArgs e)
{
string strSave = EyouSoft.Common.Utils.GetFormValue("hidSave");
int sType = EyouSoft.Common.Utils.GetInt(Request.Form["hidType"], 0);
if (!IsPostBack)
{
type = EyouSoft.Common.Utils.GetInt(Request.QueryString["type"]);
}
if (strSave == "save" && sType > 0)//保存
{
string strCompantyName = EyouSoft.Common.Utils.GetFormValue("txtCompanyName", 250);
int provinceID = EyouSoft.Common.Utils.GetInt(Request.Form[ProvinceAndCityList1.FindControl("ddl_ProvinceList").UniqueID], 0);
int cityID = EyouSoft.Common.Utils.GetInt(Request.Form[ProvinceAndCityList1.FindControl("ddl_CityList").UniqueID], 0);
string strName = EyouSoft.Common.Utils.GetFormValue("txtName", 250);
string strTel = EyouSoft.Common.Utils.GetFormValue("txtTel", 250);
string strContent = EyouSoft.Common.Utils.GetFormValue("txtContent");
EyouSoft.Model.CommunityStructure.MarketingCompany modelMarket = new EyouSoft.Model.CommunityStructure.MarketingCompany();
modelMarket.CompanyName = strCompantyName;
modelMarket.ProvinceId = provinceID;
modelMarket.CityId = cityID;
modelMarket.Contact = strName;
modelMarket.ContactWay = strTel;
modelMarket.Question = strContent;
modelMarket.RegisterDate = DateTime.Now;
modelMarket.MarketingCompanyType = (EyouSoft.Model.CommunityStructure.MarketingCompanyType)(sType);
bool result = EyouSoft.BLL.CommunityStructure.MarketingCompany.CreateInstance().Add(modelMarket);
if (result)
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this.Page, string.Format("alert('提交成功！');window.parent.Boxy.getIframeDialog('{0}').hide();", EyouSoft.Common.Utils.GetQueryStringValue("iframeId")));
}
else
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this.Page, string.Format("alert('提交失败！');window.parent.Boxy.getIframeDialog('{0}').hide();", EyouSoft.Common.Utils.GetQueryStringValue("iframeId")));
}
}
}
/// <summary>
/// 分页获取营销公司数据
/// </summary>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageIndex">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <param name="provinceId">省份,null不作条件</param>
/// <param name="cityId">城市,null不作条件</param>
/// <param name="marketingCompany">营销公司类型</param>
/// <param name="companyName">公司名称</param>
/// <param name="startDate">开始时间(注册)</param>
/// <param name="endDate">结束时间(注册)</param>
/// <returns>营销公司集合</returns>
public virtual IList <EyouSoft.Model.CommunityStructure.MarketingCompany> GetMarketingCompany(int pageSize, int pageIndex,
ref int recordCount, int?provinceId, int?cityId, EyouSoft.Model.CommunityStructure.MarketingCompanyType?marketingCompanyType,
string companyName, DateTime?startDate, DateTime?endDate)
{
string tableName = "tbl_MarketingCompany";
string fields = "ID,CompanyName,ProvinceId,CityId,Contact,ContactWay,Question,Category,RegisterDate";
string identityColumnName = "ID";
StringBuilder query = new StringBuilder(" 1=1 ");
string orderBy = " RegisterDate DESC";
if (provinceId.HasValue) //省份
{
query.AppendFormat(" AND ProvinceId = {0}", provinceId);
}
if (cityId.HasValue) //城市
{
query.AppendFormat(" AND CityId = {0}", cityId);
}
if (marketingCompanyType.HasValue) //营销公司类型
{
query.AppendFormat(" AND Category = {0}", (int)marketingCompanyType);
}
if (!string.IsNullOrEmpty(companyName)) //单位名称
{
query.AppendFormat(" AND CompanyName like'%{0}%'", companyName);
}
if (startDate.HasValue) //开始时间
{
query.AppendFormat(" AND DATEDIFF(dd,RegisterDate,'{0}') <= 0", startDate);
}
if (endDate.HasValue) //结束时间
{
query.AppendFormat(" AND DATEDIFF(dd,RegisterDate,'{0}') >= 0", endDate);
}
IList <EyouSoft.Model.CommunityStructure.MarketingCompany> list = new List <EyouSoft.Model.CommunityStructure.MarketingCompany>();
EyouSoft.Model.CommunityStructure.MarketingCompany item = null;
using (IDataReader reader = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount,
tableName, identityColumnName, fields, query.ToString(), orderBy))
{
while (reader.Read())
{
list.Add(item = new EyouSoft.Model.CommunityStructure.MarketingCompany()
{
ID = (int)reader["ID"],
CompanyName = reader["CompanyName"].ToString(),
ProvinceId = (int)reader["ProvinceId"],
CityId = (int)reader["CityId"],
Contact = reader["Contact"].ToString(),
ContactWay = reader["ContactWay"].ToString(),
Question = reader.IsDBNull(reader.GetOrdinal("Question")) ? string.Empty : reader["Question"].ToString(),
MarketingCompanyType = (EyouSoft.Model.CommunityStructure.MarketingCompanyType)Enum.Parse(typeof(EyouSoft.Model.CommunityStructure.MarketingCompanyType), reader["Category"].ToString()),
RegisterDate = DateTime.Parse(reader["RegisterDate"].ToString())
});
}
}
return(list);
}
