/// <summary> /// 初始化 /// </summary> private void InitPage() { int TeamId = EyouSoft.Common.Utils.GetInt(Request.QueryString["id"]); if (TeamId > 0) { EyouSoft.Model.ShopStructure.RouteTeamCustomization model = EyouSoft.BLL.ShopStructure.RouteTeamCustomization.CreateInstance().GetModel(TeamId); CarContent = model.CarContent; ContactCompanyName = model.ContactCompanyName; ContactName = model.ContactName; ContactTel = model.ContactTel; DinnerContent = model.DinnerContent; GuideContent = model.GuideContent; IssueTime = model.IssueTime.ToShortDateString(); OtherContent = model.OtherContent; PlanDate = model.PlanDate.ToShortDateString(); PlanPeopleNum = model.PlanPeopleNum; ResideContent = model.ResideContent; ShoppingInfo = model.ShoppingInfo; if (!string.IsNullOrEmpty(model.TravelContent)) { TravelContent = EyouSoft.Common.Domain.FileSystem + model.TravelContent; } model = null; } }
/// <summary> /// 新增团队制定 /// </summary> /// <param name="model">高级网店团队制定实体</param> /// <returns>true:成功;false:失败</returns> public virtual bool Add(EyouSoft.Model.ShopStructure.RouteTeamCustomization model) { bool IsTrue = false; DbCommand dc = _currentBase.GetSqlStringCommand(SQL_RouteTeamCustomization_Add); _currentBase.AddInParameter(dc, "CarContent", DbType.String, model.CarContent); _currentBase.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyId); _currentBase.AddInParameter(dc, "ContactCompanyName", DbType.String, model.ContactCompanyName); _currentBase.AddInParameter(dc, "ContactName", DbType.String, model.ContactName); _currentBase.AddInParameter(dc, "ContactTel", DbType.String, model.ContactTel); _currentBase.AddInParameter(dc, "DinnerContent", DbType.String, model.DinnerContent); _currentBase.AddInParameter(dc, "GuideContent", DbType.String, model.GuideContent); _currentBase.AddInParameter(dc, "OperatorId", DbType.AnsiStringFixedLength, model.OperatorId); _currentBase.AddInParameter(dc, "OtherContent", DbType.String, model.OtherContent); _currentBase.AddInParameter(dc, "PlanDate", DbType.DateTime, model.PlanDate); _currentBase.AddInParameter(dc, "PlanPeopleNum", DbType.Int32, model.PlanPeopleNum); _currentBase.AddInParameter(dc, "ResideContent", DbType.String, model.ResideContent); _currentBase.AddInParameter(dc, "ShoppingInfo", DbType.String, model.ShoppingInfo); _currentBase.AddInParameter(dc, "TravelContent", DbType.String, model.TravelContent); _currentBase.AddInParameter(dc, "IssueTime", DbType.String, model.IssueTime); int AffectedRows = DbHelper.ExecuteSql(dc, _currentBase); IsTrue = AffectedRows > 0 ? true : false; return(IsTrue); }
/// <summary> /// 获取团队制定实体 /// </summary> /// <param name="Id">团队制定的编号(主键)</param> /// <returns></returns> public virtual EyouSoft.Model.ShopStructure.RouteTeamCustomization GetModel(int Id) { EyouSoft.Model.ShopStructure.RouteTeamCustomization model = new EyouSoft.Model.ShopStructure.RouteTeamCustomization(); DbCommand dc = _currentBase.GetSqlStringCommand(SQL_RouteTeamCustomization_Select); _currentBase.AddInParameter(dc, "Id", DbType.Int32, Id); using (IDataReader dr = DbHelper.ExecuteReader(dc, _currentBase)) { while (dr.Read()) { model.CarContent = dr.IsDBNull(dr.GetOrdinal("CarContent")) ? "" : dr.GetString(dr.GetOrdinal("CarContent")); model.CompanyId = dr.IsDBNull(dr.GetOrdinal("CompanyId")) ? "" : dr.GetString(dr.GetOrdinal("CompanyId")); model.ContactCompanyName = dr.IsDBNull(dr.GetOrdinal("ContactCompanyName")) ? "" : dr.GetString(dr.GetOrdinal("ContactCompanyName")); model.ContactName = dr.GetString(dr.GetOrdinal("ContactName")); model.ContactTel = dr.GetString(dr.GetOrdinal("ContactTel")); model.DinnerContent = dr.IsDBNull(dr.GetOrdinal("DinnerContent")) ? "" : dr.GetString(dr.GetOrdinal("DinnerContent")); model.GuideContent = dr.IsDBNull(dr.GetOrdinal("GuideContent")) ? "" : dr.GetString(dr.GetOrdinal("GuideContent")); model.Id = dr.GetInt32(dr.GetOrdinal("Id")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OperatorId = dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? "" : dr.GetString(dr.GetOrdinal("OperatorId")); model.OtherContent = dr.IsDBNull(dr.GetOrdinal("OtherContent")) ? "" : dr.GetString(dr.GetOrdinal("OtherContent")); model.PlanDate = dr.GetDateTime(dr.GetOrdinal("PlanDate")); model.PlanPeopleNum = dr.GetInt32(dr.GetOrdinal("PlanPeopleNum")); model.ResideContent = dr.IsDBNull(dr.GetOrdinal("ResideContent")) ? "" : dr.GetString(dr.GetOrdinal("ResideContent")); model.ShoppingInfo = dr.IsDBNull(dr.GetOrdinal("ShoppingInfo")) ? "" : dr.GetString(dr.GetOrdinal("ShoppingInfo")); model.TravelContent = dr.IsDBNull(dr.GetOrdinal("TravelContent")) ? "" : dr.GetString(dr.GetOrdinal("TravelContent")); } } return(model); }
/// <summary> /// 获取团队制定信息(分页) /// </summary> /// <param name="PageSize">每页条数</param> /// <param name="PageIndex">当前页数</param> /// <param name="RecordCount">总记录数</param> /// <param name="CompanyId">公司编号</param> /// <returns>团队制定信息集合</returns> public virtual IList <EyouSoft.Model.ShopStructure.RouteTeamCustomization> GetList(int PageSize, int PageIndex, ref int RecordCount, string CompanyId) { IList <EyouSoft.Model.ShopStructure.RouteTeamCustomization> ResultList = new List <EyouSoft.Model.ShopStructure.RouteTeamCustomization>(); EyouSoft.Model.ShopStructure.RouteTeamCustomization model = null; string StrFileds = "[Id],[OperatorId],[CompanyId],[PlanDate],[PlanPeopleNum],[TravelContent],[ResideContent],[DinnerContent],[CarContent],[GuideContent],[ShoppingInfo],[OtherContent],[ContactName],[ContactCompanyName],[ContactTel],[IssueTime]"; string StrQuery = string.Format("[CompanyId]='{0}' ", CompanyId); string StrOrderBy = " IssueTime DESC"; using (IDataReader dr = DbHelper.ExecuteReader(_currentBase, PageSize, PageIndex, ref RecordCount, "tbl_RouteTeamCustomization", "[Id]", StrFileds, StrQuery, StrOrderBy)) { while (dr.Read()) { model = new EyouSoft.Model.ShopStructure.RouteTeamCustomization(); model.CarContent = dr.IsDBNull(dr.GetOrdinal("CarContent")) ? "" : dr.GetString(dr.GetOrdinal("CarContent")); model.CompanyId = dr.IsDBNull(dr.GetOrdinal("CompanyId")) ? "" : dr.GetString(dr.GetOrdinal("CompanyId")); model.ContactCompanyName = dr.IsDBNull(dr.GetOrdinal("ContactCompanyName")) ? "" : dr.GetString(dr.GetOrdinal("ContactCompanyName")); model.ContactName = dr.GetString(dr.GetOrdinal("ContactName")); model.ContactTel = dr.GetString(dr.GetOrdinal("ContactTel")); model.DinnerContent = dr.IsDBNull(dr.GetOrdinal("DinnerContent")) ? "" : dr.GetString(dr.GetOrdinal("DinnerContent")); model.GuideContent = dr.IsDBNull(dr.GetOrdinal("GuideContent")) ? "" : dr.GetString(dr.GetOrdinal("GuideContent")); model.Id = dr.GetInt32(dr.GetOrdinal("Id")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OperatorId = dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? "" : dr.GetString(dr.GetOrdinal("OperatorId")); model.OtherContent = dr.IsDBNull(dr.GetOrdinal("OtherContent")) ? "" : dr.GetString(dr.GetOrdinal("OtherContent")); model.PlanDate = dr.GetDateTime(dr.GetOrdinal("PlanDate")); model.PlanPeopleNum = dr.GetInt32(dr.GetOrdinal("PlanPeopleNum")); model.ResideContent = dr.IsDBNull(dr.GetOrdinal("ResideContent")) ? "" : dr.GetString(dr.GetOrdinal("ResideContent")); model.ShoppingInfo = dr.IsDBNull(dr.GetOrdinal("ShoppingInfo")) ? "" : dr.GetString(dr.GetOrdinal("ShoppingInfo")); model.TravelContent = dr.IsDBNull(dr.GetOrdinal("TravelContent")) ? "" : dr.GetString(dr.GetOrdinal("TravelContent")); ResultList.Add(model); } } model = null; return(ResultList); }
/// <summary> /// 获取团队制定信息 /// </summary> /// <param name="CompanyId">公司编号</param> /// <returns></returns> public virtual IList <EyouSoft.Model.ShopStructure.RouteTeamCustomization> GetList(string CompanyId) { IList <EyouSoft.Model.ShopStructure.RouteTeamCustomization> ResultList = new List <EyouSoft.Model.ShopStructure.RouteTeamCustomization>(); EyouSoft.Model.ShopStructure.RouteTeamCustomization model = null; string StrSql = "SELECT [Id],[OperatorId],[CompanyId],[PlanDate],[PlanPeopleNum],[TravelContent],[ResideContent],[DinnerContent],[CarContent],[GuideContent],[ShoppingInfo],[OtherContent],[ContactName],[ContactCompanyName],[ContactTel],[IssueTime] FROM tbl_RouteTeamCustomization WHERE [CompanyId]=@CompanyId"; DbCommand dc = _currentBase.GetSqlStringCommand(StrSql); _currentBase.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, CompanyId); using (IDataReader dr = DbHelper.ExecuteReader(dc, _currentBase)) { while (dr.Read()) { model = new EyouSoft.Model.ShopStructure.RouteTeamCustomization(); model.CarContent = dr.IsDBNull(dr.GetOrdinal("CarContent")) ? "" : dr.GetString(dr.GetOrdinal("CarContent")); model.CompanyId = dr.IsDBNull(dr.GetOrdinal("CompanyId")) ? "" : dr.GetString(dr.GetOrdinal("CompanyId")); model.ContactCompanyName = dr.IsDBNull(dr.GetOrdinal("ContactCompanyName")) ? "" : dr.GetString(dr.GetOrdinal("ContactCompanyName")); model.ContactName = dr.GetString(dr.GetOrdinal("ContactName")); model.ContactTel = dr.GetString(dr.GetOrdinal("ContactTel")); model.DinnerContent = dr.IsDBNull(dr.GetOrdinal("DinnerContent")) ? "" : dr.GetString(dr.GetOrdinal("DinnerContent")); model.GuideContent = dr.IsDBNull(dr.GetOrdinal("GuideContent")) ? "" : dr.GetString(dr.GetOrdinal("GuideContent")); model.Id = dr.GetInt32(dr.GetOrdinal("Id")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OperatorId = dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? "" : dr.GetString(dr.GetOrdinal("OperatorId")); model.OtherContent = dr.IsDBNull(dr.GetOrdinal("OtherContent")) ? "" : dr.GetString(dr.GetOrdinal("OtherContent")); model.PlanDate = dr.GetDateTime(dr.GetOrdinal("PlanDate")); model.PlanPeopleNum = dr.GetInt32(dr.GetOrdinal("PlanPeopleNum")); model.ResideContent = dr.IsDBNull(dr.GetOrdinal("ResideContent")) ? "" : dr.GetString(dr.GetOrdinal("ResideContent")); model.ShoppingInfo = dr.IsDBNull(dr.GetOrdinal("ShoppingInfo")) ? "" : dr.GetString(dr.GetOrdinal("ShoppingInfo")); model.TravelContent = dr.IsDBNull(dr.GetOrdinal("TravelContent")) ? "" : dr.GetString(dr.GetOrdinal("TravelContent")); ResultList.Add(model); } } model = null; return(ResultList); }
/// <summary> /// 添加团队制定信息 /// </summary> private void Add() { string PlanDate = Request.Form["PlanDate"]; string ContactTel = Request.Form["ContactTel"]; string ContactCompanyName = Request.Form["ContactCompanyName"]; string ContactName = Request.Form["ContactName"]; int PlanPeopleNum = Utils.GetInt(Request.Form["PlanPeopleNum"]); #region 验证 string StrErrorMsg = string.Empty; if (string.IsNullOrEmpty(PlanDate)) { StrErrorMsg += "-计划日期不能为空!\n"; } if (string.IsNullOrEmpty(ContactTel)) { StrErrorMsg += "-联系电话不能为空!\n"; } if (string.IsNullOrEmpty(ContactCompanyName)) { StrErrorMsg += "-单位名称不能为空! \n"; } if (string.IsNullOrEmpty(ContactName)) { StrErrorMsg += "-联系人不能为空!\n"; } if (PlanPeopleNum < 1) { StrErrorMsg += "-计划人数必须大于0!\n"; } if (!string.IsNullOrEmpty(StrErrorMsg)) { StrErrorMsg = "[{isSuccess:false,Message:'" + StrErrorMsg + "'}]"; Response.Clear(); Response.Write(StrErrorMsg); Response.End(); } #endregion EyouSoft.Model.ShopStructure.RouteTeamCustomization model = new EyouSoft.Model.ShopStructure.RouteTeamCustomization(); model.CarContent = Utils.GetFormValue("CarContent"); model.CompanyId = CompanyId; model.ContactCompanyName = Utils.GetFormValue("ContactCompanyName"); model.ContactName = Utils.GetFormValue("ContactName"); model.ContactTel = Utils.GetFormValue("ContactTel"); model.DinnerContent = Utils.GetFormValue("DinnerContent"); model.GuideContent = Utils.GetFormValue("GuideContent"); model.IssueTime = DateTime.Now; if (this.SiteUserInfo != null) { model.OperatorId = this.SiteUserInfo.ID; } else { model.OperatorId = ""; } model.OtherContent = Utils.GetFormValue("OtherContent"); model.PlanDate = Utils.GetDateTime(PlanDate); model.PlanPeopleNum = PlanPeopleNum; model.ResideContent = Utils.GetFormValue("ResideContent"); model.ShoppingInfo = Utils.GetFormValue("ShoppingInfo"); model.TravelContent = Utils.GetFormValue("ctl00$MainPlaceHolder$SingleFileUpload1$hidFileName"); bool IsTrue = EyouSoft.BLL.ShopStructure.RouteTeamCustomization.CreateInstance().Add(model); if (IsTrue) { Response.Clear(); Response.Write("[{isSuccess:true,Message:'提交成功,我们将尽快联系你'}]"); Response.End(); } }
/// <summary> /// 新增团队制定 /// </summary> /// <param name="model">高级网店团队制定实体</param> /// <returns>true:成功;false:失败</returns> public bool Add(EyouSoft.Model.ShopStructure.RouteTeamCustomization model) { return(dal.Add(model)); }