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