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