private void BindOrderDetailData()
{
DataTable myTable = orderDetailBLL.GetData("orderNumber ='" + orderNumber + "'");
StringBuilder sb = new StringBuilder();
foreach (DataRow dr in myTable.Rows)
{
sb.Append("<tr>");
ClassLibrary.Model.Routes route = routeBLL.GetModel(Convert.ToInt32(dr["routeID"]));
string tmpClassPy = routeClassBll.GetModel(Convert.ToInt32(route.LocationID)).ClassNamePY;
sb.AppendFormat("<td><a href='{3}/{2}/{0}.html' target='_blank'>{1}</a></td>", dr["routeID"].ToString(), dr["RouteName"].ToString(), tmpClassPy, SysConfig.webSite);
string[] temp = dr["Number"].ToString().Split(',');
sb.AppendFormat("<td>{0}</td>", temp[0] + "大" + temp[1] + "小");
sb.AppendFormat("<td>{0}</td>", (Convert.ToInt32(dr["RoutePrice"]) == 0 ? "价格电讯" : "¥" + Convert.ToInt32(dr["RoutePrice"]) + "元"));
sb.AppendFormat("<td>{0}</td>", dr["RouteTime"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["StartTime"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["CreatedTime"].ToString());
sb.Append("</tr>");
}
dataOrderDetailList = sb.ToString();
}
private void BindOrderDetailData()
{
DataTable myTable = orderDetailBLL.GetData(" orderNumber ='" + orderNumber + "'");
myTable = pg.pagination(myTable, 20, "");
StringBuilder sb = new StringBuilder();
foreach (DataRow dr in myTable.Rows)
{
sb.AppendFormat("<tr id='tr_{0}'>", dr["ID"].ToString());
ClassLibrary.Model.Routes route = routeBLL.GetModel(Convert.ToInt32(dr["routeID"]));
string tmpClassPy = routeClassBll.GetModel(Convert.ToInt32(route.LocationID)).ClassNamePY;
sb.AppendFormat("<td><a href='/{2}/{1}.html' target='_blank'>{0}</a></td>", dr["RouteName"].ToString(), dr["routeID"].ToString(), tmpClassPy);
string[] temp = dr["Number"].ToString().Split(',');
sb.AppendFormat("<td>{0}</td>", temp[0] + "大" + temp[1] + "小");
//sb.AppendFormat("<td><input id='price_{0}' type='text' size='10' value='{1}' /><input type='button' class='button' value='修改' onclick='UpdateOrderDetailPrice({0},{2})' /></td>", dr["ID"].ToString(), Convert.ToInt32(dr["RoutePrice"]), dr["ordernumber"].ToString());
sb.AppendFormat("<td>¥{0}元</td>", Convert.ToInt32(dr["RoutePrice"]));
sb.AppendFormat("<td>{0}</td>", dr["RouteTime"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["StartTime"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["CreatedTime"].ToString());
sb.Append("</tr>");
}
dataOrderDetailList = sb.ToString();
}
private void BindInfo()
{
route = bll.GetModel(routeID);
if (route.routesClassID == "")
{
Response.StatusCode = 404;
Response.End();
}
gList = rcBLL.GetModelList(String.Empty);
if (route.ThemeID != "")
{
ClassLibrary.Model.RouteClass classmodel = gList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == Convert.ToInt32(route.ThemeID.Split(',')[0])); });
themeName = "<div class='detl_zt'>" + classmodel.ClassName + "</div>";
}
routeClassId = route.LocationID;
ClassLibrary.Model.RouteClass curClass = gList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == routeClassId); });
if (curClass.ClassNamePY != comePY)
{
Response.StatusCode = 404;
Response.End();
}
mipUrl = SysConfig.webSiteApp + "/" + comePY + "/" + routeID + ".html";
//购买事件
buyEventStr = mipUrl;
dateType = route.DateType;
price = Convert.ToInt32(route.Price);
childPrice = Convert.ToInt32(route.ChildPrice);
routeFeature = Function.AddTargetForMip(Function.UpdateStyleForMip(Function.UpdateImgTagForMip(replaceSite(route.RouteFeature))));
descriptionPrice = Function.AddTargetForMip(Function.UpdateStyleForMip(Function.UpdateImgTagForMip(replaceSite(route.DescriptionPrice))));
routeNotice = Function.AddTargetForMip(Function.UpdateStyleForMip(Function.UpdateImgTagForMip(replaceSite(route.RouteNotice))));
detailType = route.DetailType;
if (route.DatePrice != "")
{
string[] tmpDatePrice = route.DatePrice.Split('|');
string cDate = DateTime.Now.ToShortDateString().ToString();
for (int k = 0; k < tmpDatePrice.Length; k++)
{
string tmpPrices = tmpDatePrice[k];
if (tmpPrices == "")
{
continue;
}
string[] tmpPrice = tmpPrices.Split(',');
TimeSpan ts = DateTime.Parse(tmpPrice[0]) - DateTime.Now;
if (ts.TotalDays > 0)
{
datePrice += tmpPrices + "|";
}
}
}
string[] imgs = route.Image.Split(',');
image = SysConfig.webSite + SysConfig.UploadFilePathRoutesImg + imgs[0];
}
private void RouteCopy(HttpContext context)
{
string id = context.Request.QueryString["id"];
ClassLibrary.BLL.Routes routeBll = new ClassLibrary.BLL.Routes();
ClassLibrary.Model.Routes routemodel = routeBll.GetModel(int.Parse(id));
if (routemodel == null || routemodel.Title == "")
{
Print(context, "error");
return;
}
string[] oldImgs = routemodel.Image.Split(',');
string fileFullPath = context.Server.MapPath(SysConfig.UploadFilePathRoutesImg);
string newImgs = "";
for (int i = 0; i < oldImgs.Length; i++)
{
string ext = Path.GetExtension(oldImgs[i]);
string fileName = Function.GetRandomTime() + ext;
try
{
File.Copy(fileFullPath + oldImgs[i], fileFullPath + fileName);
} catch (Exception e) {
}
newImgs += fileName + ",";
}
if (!string.IsNullOrEmpty(newImgs))
{
newImgs = newImgs.Substring(0, newImgs.Length - 1);
}
routemodel.Image = newImgs;
routemodel.Display = false;
routemodel.ViewCount = 0;
routemodel.Order = 999;
routemodel.FirstTime = DateTime.Now.ToString("yyyy-MM-dd");
routemodel.CreatedTime = DateTime.Now;
if (routeBll.Add(routemodel) > 0)
{
if (routemodel.DetailType)
{
int routeId = routeBll.GetLastId();
ClassLibrary.BLL.RouteDetails rdBll = new ClassLibrary.BLL.RouteDetails();
List <ClassLibrary.Model.RouteDetails> detailList = rdBll.GetModelList("routeId = " + routemodel.ID);
foreach (ClassLibrary.Model.RouteDetails model in detailList)
{
model.RouteID = routeId;
rdBll.Add(model);
}
Print(context, "success");
}
}
else
{
Print(context, "error");
}
}
private void BindList()
{
DataTable myTable = comBLL.GetData("UserName='******'");
myTable = pg.pagination(myTable, 10, "");
pageInfo = pg.pageNumList;
StringBuilder sb = new StringBuilder();
List <ClassLibrary.Model.RouteClass> rcList = new List <ClassLibrary.Model.RouteClass>();
if (myTable.Rows.Count != 0)
{
ClassLibrary.BLL.RouteClass rcBLL = new ClassLibrary.BLL.RouteClass();
rcList = rcBLL.GetModelList(string.Empty);
}
int rowIndex = 0;
foreach (DataRow dr in myTable.Rows)
{
sb.Append("<tr'>");
ClassLibrary.Model.Routes route = routeBLL.GetModel(Convert.ToInt32(dr["routeID"]));
string tmpClassPy = rcList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == route.LocationID); }).ClassNamePY;
sb.AppendFormat("<td align='center'>{0}</td>", ++rowIndex);
sb.AppendFormat("<td align='center'><a href='{3}/{2}/{0}.html' target='_blank'>{1}</a></td>", dr["routeID"].ToString(), route.Title, tmpClassPy, SysConfig.webSite);
sb.AppendFormat("<td align='center'>{0}</td>", GetGradeImg(dr["Grade"].ToString()));
sb.AppendFormat("<td align='center'>{0}</td>", dr["Content"].ToString());
sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToBoolean(dr["Checked"]) ? "<span class='red'>已审核</span>" : "审核中");
sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToDateTime(dr["CreatedTime"]).ToString("yyyy-MM-dd"));
sb.Append("</tr>");
}
if (sb.Length == 0)
{
sb.Append("<tr><td colspan='6'>暂无评价！</td></tr>");
}
dataList = sb.ToString();
}
private void BindData(string sql)
{
DataTable myTable = routeCommentBLL.GetData(sql);
myTable = pg.pagination(myTable, 20, "");
pageInfo = pg.pageNumList;
StringBuilder sb = new StringBuilder();
foreach (DataRow dr in myTable.Rows)
{
sb.AppendFormat("<tr id='tr_{0}'>", dr["ID"].ToString());
ClassLibrary.Model.Routes rmodel = routeBLL.GetModel(Convert.ToInt32(dr["routeId"]));
string tmpClassPy = rcList.Find(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ID == rmodel.LocationID); }).ClassNamePY;
sb.AppendFormat("<td><a href='/{2}/{1}.html' target='_blank'>{0}</a></td>", Function.Clip(GetRoute(Convert.ToInt32(dr["routeID"])), 10, true), Convert.ToInt32(dr["routeID"]), tmpClassPy);
sb.AppendFormat("<td>{0}</td>", Convert.ToInt16(dr["Grade"].ToString()));
sb.AppendFormat("<td>{0}</td>", dr["UserName"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["Nickname"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["Email"].ToString());
sb.AppendFormat("<td>{0}</td>", Convert.ToBoolean(dr["Checked"]) ? "<span class='green'>是</span>" : "<span class='red'>否</span>");
sb.AppendFormat("<td>{0}</td>", dr["CreatedTime"].ToString());
sb.Append("<td>");
if (!Convert.ToBoolean(dr["Checked"]))
{
sb.AppendFormat("<a href='RouteCommentList.aspx?ID={0}'>审核</a> ", dr["ID"].ToString());
}
else
{
sb.Append(" ");
}
sb.AppendFormat("<a href='RouteCommentDetail.aspx?id={0}'>查看</a> ", dr["ID"].ToString());
sb.AppendFormat("<a href='javascript:void(0)' onclick='routeCommentDelete({0})'>删除</a>", dr["ID"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
}
dataRouteCommentList = sb.ToString();
}
//网站信息
private void GetWebInfo()
{
webMeta.Title = "重庆青年旅行社_重庆旅行社_重庆中国青年旅行社_重庆中青旅行社";
webMeta.Description = "重庆中国青年旅行社（www.qu17.com）称重庆青旅，旅游热线：400-017-5761.共青团市委直属重庆旅行社，中青旅集团成员单位，优质服务示范重庆旅行社，重庆青年旅行社具有国家旅游局颁证的出境旅游资质的国际旅行社，旅游品质最高的重庆旅行社，重庆十大金牌旅行社，出入境游、国内游、重庆周边游、长江三峡游为主导。";
webMeta.Keyword = "重庆旅行社,重庆青年旅行社,重庆中青旅,重庆中国青年旅行社,重庆旅游网";
string url = HttpContext.Current.Request.CurrentExecutionFilePath.ToLower();
string tmpTitle = "_重庆中国青年旅行社";
if (url.IndexOf("approutesearch.aspx") > -1)
{
webMeta.Title = "旅游线路搜索结果" + tmpTitle;
webMeta.Keyword = "";
webMeta.Description = "";
}
else if (url.IndexOf("approutelist.aspx") > -1)
{
string ping = Function.GetQueryString("py");
ClassLibrary.BLL.RouteClass routeClassBll = new ClassLibrary.BLL.RouteClass();
List <ClassLibrary.Model.RouteClass> rcList = routeClassBll.GetModelList("classNamePy='" + ping + "'");
if (rcList.Count > 0)
{
ClassLibrary.Model.RouteClass rc = rcList[0];
if (rc.ClassLevel == 4)
{
webMeta.Title = string.Format("{0}旅游线路行程_{0}跟团游报价_重庆中国青年旅行社", rc.ClassName);
webMeta.Keyword = string.Format("{0}旅游,{0}跟团游,{0}旅游行程报价,{0}旅游线路,重庆中青旅{0}旅游团", rc.ClassName);
webMeta.Description = string.Format("重庆中国青年旅行社设计{0}旅游线路行程,重庆到{0}旅游最新报价,{0}跟团游最具性价比的旅行社,重庆出发{0}旅游选择青旅品质服务享受旅途,重庆青旅热线400-017-5761.", rc.ClassName);
}
else if (rc.ClassLevel == 3)
{
if (rc.ID == (int)SysConfig.RouteClass.重庆)
{
webMeta.Title = "重庆周边游_重庆周边旅游线路报价_重庆中国青年旅行社";
webMeta.Keyword = "重庆周边旅游,重庆周边旅游线路,重庆周边旅游行程,重庆周边旅游报价";
webMeta.Description = "重庆周边旅游线路、周边旅游行程报价由重庆中国青年旅行社提供设计,重庆青旅热线400-017-5761.";
}
else if (rc.ParentID == (int)SysConfig.RouteClass.豪华船)
{
webMeta.Title = string.Format("重庆三峡{0}旅游_{0}三峡旅游报价", rc.ClassName);
webMeta.Keyword = string.Format("重庆三峡{0}旅游,三峡{0}旅游报价,重庆三峡旅游", rc.ClassName);
webMeta.Description = string.Format("重庆青年旅行社提供重庆三峡{0}旅游线路报价,重庆三峡{0}旅游费用,长江三峡豪华游船旅游价格,三峡{0}旅游要多少钱,详询中青旅电话400-017-5761.", rc.ClassName);
}
else
{
webMeta.Title = string.Format("{0}旅游线路行程_{0}跟团游报价_重庆中国青年旅行社", rc.ClassName);
webMeta.Keyword = string.Format("{0}旅游,{0}跟团游,{0}旅游行程报价,{0}旅游线路,重庆中青旅{0}旅游团", rc.ClassName);
webMeta.Description = string.Format("重庆中国青年旅行社设计{0}旅游线路行程,重庆到{0}旅游最新报价,{0}跟团游最具性价比的旅行社,重庆出发{0}旅游选择青旅品质服务享受旅途,重庆青旅热线400-017-5761.", rc.ClassName);
}
}
else if (rc.ClassLevel == 2)
{
if (rc.ParentID == (int)SysConfig.RouteClass.峡旅游)
{
if (rc.ID == (int)SysConfig.RouteClass.豪华船)
{
webMeta.Title = "三峡豪华游船_豪华游船航期表_重庆三峡豪华游轮_重庆中国青年旅行社";
webMeta.Keyword = "重庆三峡豪华游船,长江三峡游船,豪华游船航期表,三峡涉外豪华游轮";
webMeta.Description = "重庆中国青年旅行社提供各系列长江三峡豪华游轮,以及三峡涉外豪华游轮旅游品质服务,重庆三峡涉外豪华游轮预定,重庆中青旅热线：400-017-5761";
}
else
{
webMeta.Title = "三峡国内游船_重庆三峡国内船_重庆中国青年旅行社";
webMeta.Keyword = "重庆三峡国内游船,长江三峡游船,三峡国内游轮";
webMeta.Description = "重庆中国青年旅行社提供长江三峡国内游船,长江三峡旅游品质服务,重庆三峡国内游船预定,重庆中青旅热线：400-017-5761";
}
}
else
{
webMeta.Title = string.Format("{0}旅游线路行程_{0}跟团游报价_重庆中国青年旅行社", rc.ClassName);
webMeta.Keyword = string.Format("{0}旅游,{0}跟团游,{0}旅游行程报价,{0}旅游线路,重庆中青旅{0}旅游团", rc.ClassName);
webMeta.Description = string.Format("重庆中国青年旅行社设计{0}旅游线路行程,重庆到{0}旅游最新报价,{0}跟团游最具性价比的旅行社,重庆出发{0}旅游选择青旅品质服务享受旅途,重庆青旅热线400-017-5761.", rc.ClassName);
}
}
else
{
if (rc.ID == (int)SysConfig.RouteClass.国内旅游)
{
webMeta.Title = "国内旅游线路行程_重庆出发国内旅游线路_重庆中国青年旅行社";
webMeta.Keyword = "国内游线路,国内游行程,国内游报价,国内游跟团,重庆出发国内游";
webMeta.Description = "重庆出发国内旅游线路、国内旅游行程报价由重庆中国青年旅行社提供设计,重庆青旅热线400-017-5761.";
}
else if (rc.ID == (int)SysConfig.RouteClass.出境旅游)
{
webMeta.Title = "出境旅游线路行程_重庆出发出境旅游线路_重庆中国青年旅行社";
webMeta.Keyword = "出境游线路,出境游行程,出境游报价,出境游跟团,重庆出发出境游";
webMeta.Description = "重庆出发出境旅游线路、出境旅游行程报价由重庆中国青年旅行社提供设计,重庆青旅热线400-017-5761.";
}
else if (rc.ID == (int)SysConfig.RouteClass.峡旅游)
{
webMeta.Title = "重庆长江三峡旅游_重庆三峡旅游行程景点_重庆中国青年旅行社";
webMeta.Keyword = "重庆三峡旅游,长江三峡旅游线路,三峡旅游报价,三峡游景点,三峡游船预定";
webMeta.Description = "重庆三峡旅游行程、三峡游线路、长江三峡旅游报价由重庆中国青年旅行社提供设计,重庆青旅热线400-017-5761.";
}
}
}
else
{
ClassLibrary.BLL.RouteType rtBll = new ClassLibrary.BLL.RouteType();
List <ClassLibrary.Model.RouteType> rtList = rtBll.GetModelList("classNamePy='" + ping + "'");
if (rtList.Count > 0)
{
ClassLibrary.Model.RouteType rtc = rtList[0];
webMeta.Title = string.Format("{0}旅游线路_重庆出发{0}旅游报价", rtc.ClassName.Replace("游", "")) + tmpTitle;
webMeta.Keyword = string.Format("{0}旅游,{0}旅游报价,{0}旅游线路", rtc.ClassName.Replace("游", ""));
webMeta.Description = string.Format("重庆中国青年旅行社设计{0}旅游线路行程,重庆出发{0}旅游最新报价,{0}跟团游价格,重庆出发{0}旅游选择青旅品质服务享受旅途,重庆青旅热线400-017-5761.", rtc.ClassName.Replace("游", ""));
}
}
}
else if (url.IndexOf("approutedetail.aspx") > -1)
{
int id = Convert.ToInt32(Function.GetQueryString("id"));
ClassLibrary.BLL.Routes routeBll = new ClassLibrary.BLL.Routes();
ClassLibrary.Model.Routes rModel = routeBll.GetModel(id);
webMeta.Title = rModel.Title + tmpTitle;
if (rModel.SeoTitle != null && rModel.SeoTitle.Trim() != "")
{
webMeta.Title = rModel.SeoTitle;
}
webMeta.Keyword = rModel.SeoKeywords;
if (webMeta.Keyword == "")
{
webMeta.Keyword = rModel.Title;
}
webMeta.Description = rModel.SeoDescription;
if (webMeta.Description == "")
{
webMeta.Description = Function.Clip(Function.ClearHtml(rModel.RouteFeature + rModel.DescriptionRoute).Replace(" ", "").Replace(" ", ""), 80, false);
}
}
else if (url.IndexOf("appabout.aspx") > -1)
{
webMeta.Title = "重庆中国青年旅行社简介";
webMeta.Keyword = "";
webMeta.Description = "";
}
else if (url.IndexOf("apparticlelist.aspx") > -1)
{
string strId = Function.GetQueryString("id");
if (strId != "")
{
int classid = Convert.ToInt32(strId);
if (classid == (int)SysConfig.NewsClass.旅游资讯)
{
webMeta.Title = "重庆旅行社旅游资讯_最新旅游资讯指南" + tmpTitle;
webMeta.Description = "重庆旅游资讯,重庆旅游指南,旅游最新资讯,重庆旅行社资讯";
webMeta.Keyword = "重庆青年旅行社旅游资讯大致包含旅行社资讯,旅游相关实时新闻,旅游行业最新资讯消息,重庆以及周边旅游指南,重庆中青旅一如既往的高品质服务游客.";
}
else if (classid == (int)SysConfig.NewsClass.旅游攻略)
{
webMeta.Title = "重庆旅行社旅游攻略_最新旅游攻略" + tmpTitle;
webMeta.Description = "重庆旅游攻略,重庆旅游指南,旅游最新攻略";
webMeta.Keyword = "重庆青年旅行社旅游攻略大致包含旅游的吃、住、行、游、购、娱方面的介绍以及方式方法,重庆青旅更新的旅游攻略内容板块将更加方便您的出游.";
}
}
else
{
webMeta.Title = "旅游攻略网_旅游景点网_最新旅游指南_重庆中国青年旅行社";
webMeta.Keyword = "旅游攻略网,旅游景点网,最新旅游指南";
webMeta.Description = "重庆中国青年旅行社旅游攻略网旅游景点网提供各种旅游攻略,旅游景点排行,最新旅游资讯,旅游景点推荐,详情请咨询中青旅400-017-5761";
}
}
else if (url.IndexOf("apparticledetail.aspx") > -1)
{
int id = Convert.ToInt32(Function.GetQueryString("id"));
ClassLibrary.BLL.News newsBll = new ClassLibrary.BLL.News();
ClassLibrary.Model.News rModel = newsBll.GetModel(id);
webMeta.Title = rModel.Title + tmpTitle;
webMeta.Keyword = rModel.Keywords;
if (webMeta.Keyword == "")
{
webMeta.Keyword = rModel.Title;
}
webMeta.Description = rModel.Description;
if (webMeta.Description == "")
{
webMeta.Description = Function.Clip(Function.ClearHtml(rModel.Description).Replace(" ", "").Replace(" ", ""), 80, false);
}
}
else if (url.IndexOf("appnav.aspx") > -1)
{
webMeta.Title = "旅游目的地导航" + tmpTitle;
webMeta.Keyword = "";
webMeta.Description = "";
}
else if (url.IndexOf("apporder.aspx") > -1)
{
webMeta.Title = "订单提交信息" + tmpTitle;
webMeta.Keyword = "";
webMeta.Description = "";
}
else if (url.IndexOf("appshopcart.aspx") > -1)
{
webMeta.Title = "旅游订单信息" + tmpTitle;
webMeta.Keyword = "";
webMeta.Description = "";
}
else if (url.IndexOf("appsaleslist.aspx") > -1)
{
webMeta.Title = "特价旅游专区_最划算的旅游" + tmpTitle;
webMeta.Keyword = "青旅特价旅游,特价旅游旅行社,重庆旅行社特价团";
webMeta.Description = "重庆中国青年旅行社特价旅游专区产品为限时限量旅游线路,由于游客临时退位置或者旅行社原因,导致紧急处理的旅游产品,在整个旅游行业可以说是性价比最高,超级划算的特价旅游产品.";
}
}
//线路信息
private void BindInfo()
{
route = bll.GetModel(routeID);
if (route.routesClassID == "")
{
Response.StatusCode = 404;
Response.End();
}
gList = rcBLL.GetModelList(String.Empty);
if (route.ThemeID != "")
{
ClassLibrary.Model.RouteType classmodel = rtBll.GetModel(Convert.ToInt32(route.ThemeID.Split(',')[0]));
if (classmodel != null)
{
themeName = string.Format("<div class='info_zhuti'><a href='{0}/{1}/' target='_blank'>{2}</a></div>", SysConfig.webSite, classmodel.classNamePY, classmodel.ClassName);
}
}
routeClassId = route.LocationID;
traffic = route.TrafficModel;
if (traffic.IndexOf("自理") > -1)
{
traffic = traffic.Replace("自理去", "").Replace("自理回", "").Trim();
}
ClassLibrary.Model.RouteClass curClass = gList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == routeClassId); });
pingYin = curClass.ClassNamePY;
if (curClass.ClassLevel == 4)
{
parentId = curClass.ParentID;
displayName = curClass.ClassName;
displayPy = curClass.ClassNamePY;
}
else if (curClass.ID == (int)SysConfig.RouteClass.峡旅游 || curClass.ParentID == (int)SysConfig.RouteClass.峡旅游 || curClass.ParentID == (int)SysConfig.RouteClass.豪华船)
{
parentId = (int)SysConfig.RouteClass.峡旅游;
displayName = "三峡";
displayPy = "sanxia";
}
else
{
parentId = curClass.ID;
displayName = curClass.ClassName;
displayPy = curClass.ClassNamePY;
}
if (pingYin != comePY)
{
Response.StatusCode = 404;
Response.End();
}
//购买事件
buyEventStr = string.Format("buy2('{0}','{1}','{2}','{3}')",
route.ID,
Function.Clip(route.Title, 18, true),
route.RouteTime,
pingYin);
dateType = route.DateType;
price = Convert.ToInt32(route.Price);
childPrice = Convert.ToInt32(route.ChildPrice);
routeFeature = route.RouteFeature;
descriptionPrice = route.DescriptionPrice;
routeNotice = route.RouteNotice;
detailType = route.DetailType;
if (price == 0)
{
strPrice = "电询";
}
else
{
strPrice = "¥<em>" + price + "</em>起";
}
datePrice = "";
if (route.DatePrice != "")
{
string[] tmpDatePrice = route.DatePrice.Split('|');
string cDate = DateTime.Now.ToShortDateString().ToString();
for (int k = 0; k < tmpDatePrice.Length; k++)
{
string tmpPrices = tmpDatePrice[k];
if (tmpPrices == "")
{
continue;
}
string[] tmpPrice = tmpPrices.Split(',');
TimeSpan ts = DateTime.Parse(tmpPrice[0]) - DateTime.Now;
if (ts.TotalDays > 0)
{
datePrice += tmpPrices + "|";
}
}
}
StringBuilder sb = new StringBuilder();
string[] imgs = route.Image.Split(',');
if (imgs.Length <= 3)
{
inactive = "inactive";
}
int imgIndex = 0;
foreach (string img in imgs)
{
imgIndex++;
if (imgIndex == 1)
{
firstImg = ClassLibrary.Common.SysConfig.UploadFilePathRoutesImg + img;
}
sb.AppendFormat("<li class='{1}'><i></i><img src='{0}' alt='' width='100' height='63' /></li>", ClassLibrary.Common.SysConfig.UploadFilePathRoutesImg + img, imgIndex == 1 ? "on" : "");
}
smallImageList = sb.ToString();
}
private void EditRoute()
{
decimal price = 0;
int routeOrder = 0;
ClassLibrary.Model.Routes routeModel = new ClassLibrary.Model.Routes();
routeModel.ID = routeId;
routeModel.routesPrentClassID = "";
routeModel.Title = Request.Form["Title"];
if (Decimal.TryParse(Request.Form["Price"], out price))
{
routeModel.Price = price;
}
else
{
Response.Write("<script>alert('成人价格错误！');history.back(-1);</script>");
return;
}
if (Request.Form["ChildPrice"] == "")
{
routeModel.ChildPrice = 0;
}
else if (Decimal.TryParse(Request.Form["ChildPrice"], out price))
{
routeModel.ChildPrice = price;
}
else
{
Response.Write("<script>alert('小孩价格错误！');history.back(-1);</script>");
return;
}
if (Request.Form["routeOrder"] == "")
{
routeModel.Order = 9999;
}
else if (int.TryParse(Request.Form["routeOrder"], out routeOrder))
{
routeModel.Order = routeOrder;
}
else
{
Response.Write("<script>alert('线路排序错误！');history.back(-1);</script>");
return;
}
int advanceDay = 0;
if (int.TryParse(Request.Form["AdvanceDays"], out advanceDay))
{
routeModel.AdvanceDays = advanceDay;
}
routeModel.ThemeID = Request.Form["ThemeID"];
if (routeModel.ThemeID == null)
{
routeModel.ThemeID = "";
}
//routeModel.routesPrentClassID = ParentClassIDList(routeModel.routesClassID);
routeModel.StartPosition = Request.Form["StartPosition"];
routeModel.RouteTime = Request.Form["RouteTime"];
routeModel.TrafficModel = Request.Form["TrafficModel1"] + "去 " + Request.Form["TrafficModel2"] + "回";
//routeModel.DescriptionRoute = Request.Form["DescriptionRoute"];
routeModel.DescriptionPrice = ClassLibrary.BLL.WebClass.addInternelLink(Request.Form["DescriptionPrice"], 1, null);
routeModel.RecommendHot = Convert.ToBoolean(Request.Form["RecommendHot"]);
routeModel.SeoKeywords = Request.Form["SeoKeywords"];
routeModel.SeoDescription = Request.Form["SeoDescription"];
//routeModel.RouteFeature = Request.Form["RouteFeature"];
routeModel.RouteNotice = ClassLibrary.BLL.WebClass.addInternelLink(Request.Form["RouteNotice"], 1, null);
routeModel.Display = Convert.ToBoolean(Request.Form["Isdisplay"]);
routeModel.ViewCount = Convert.ToInt32(Request.Form["ViewCount"]);
routeModel.Destination = Request.Form["Destination"];
routeModel.Supplier = Request.Form["SupplierName"];
routeModel.SupplierTel = Request.Form["SupplierTel"];
routeModel.DateType = Convert.ToBoolean(Request.Form["DateType"]);
routeModel.SeoTitle = Request.Form["SeoTitle"];
routeModel.Bright = Request.Form["RouteBright"];
routeModel.BoatName = Request.Form["BoatName"];
routeModel.LocationID = Convert.ToInt32(Request.Form["locationid"]);
if (routeModel.LocationID == 0)
{
Response.Write("<script>alert('请正确选择线路地址！');history.back(-1);</script>");
return;
}
if (routeModel.DateType)
{
routeModel.DatePrice = Request.Form["DatePrice"];
}
routeModel.DetailType = Convert.ToBoolean(Request.Form["DetailType"]);
if (routeModel.DetailType)
{
routeModel.RouteTime = Request.Form["xing_day"];
/*for (int j = 1; j <= Int32.Parse(routeModel.RouteTime); j++)
* {
* if (Request.Form["route_" + j + "_0"] == null)
* {
* Response.Write("<script>alert('请输入第 " + j + " 天标题');history.back(-1);</script>");
* return;
* }
* if (Request.Form["route_" + j + "_1"] == null)
* {
* Response.Write("<script>alert('请输入第 " + j + " 天行程');history.back(-1);</script>");
* return;
* }
* }*/
routeModel.DescriptionRoute = Request.Form["route_1_1"];
}
string province = Request.Form["ProvinceCheckBox"];
if (province == null || province == "")
{
Response.Write("<script>alert('请选择线路目的地省市！');history.back(-1);</script>");
return;
}
routeModel.routesPrentClassID = ParentClassIDList(province) + ",";
string scenic = Request.Form["ScenicCheckBox"];
if (scenic == null)
{
scenic = "";
}
string[] temScenics = scenic.Split(',');
foreach (string temScenic in temScenics)
{
if (!routeModel.routesPrentClassID.Contains(temScenic))
{
routeModel.routesPrentClassID += temScenic + ",";
}
}
routeModel.routesPrentClassID = routeModel.routesPrentClassID.Substring(0, routeModel.routesPrentClassID.Length - 1);
int routeParentID = Convert.ToInt32(Request.Form["routeParentID"]);
if (scenic != "")
{
string[] scenicIds = scenic.Split(',');
routeModel.routesClassID = routeParentID + "," + scenicIds[0];
}
else
{
string[] scenicIds = province.Split(',');
routeModel.routesClassID = routeParentID + "," + scenicIds[0];
}
//string[] subRCIds = province.Split(',');
routeModel.RouteFeature = ClassLibrary.BLL.WebClass.addInternelLink(Request.Form["RouteFeature"], 1, null);
if (!routeModel.DetailType)
{
routeModel.DescriptionRoute = ClassLibrary.BLL.WebClass.addInternelLink(Request.Form["DescriptionRoute"], 1, null);
}
//图片
HttpFileCollection files = Request.Files;
int size = 0;
string fileFullPath = Server.MapPath(SysConfig.UploadFilePathRoutesImg);
Function.CreatedDirectory(fileFullPath);
string oldAppImage = Request.Form["appImage_Hidden"];
routeModel.AppImg = oldAppImage;
if (files.Count > 0)
{
string[] oldImages = Request.Form["Image_Hidden"].Split(',');
for (int i = 0; i < files.Count; i++)
{
HttpPostedFile file = files[i];
size = file.ContentLength;
if (size > 0)
{
string ext = Path.GetExtension(file.FileName);
string fileName = DateTime.Now.ToString("yyMMddHHmmssffff") + ext;
file.SaveAs(fileFullPath + fileName);
if (i == 0)
{
//缩图
Bitmap tmp = new Bitmap(fileFullPath + fileName);
Bitmap bmp0 = Function.MakeThumNail(tmp, 100, 64);
tmp.Dispose();
string appfileName = DateTime.Now.ToString("yyMMddHHmmssffff") + ext;
Function.SaveBitmapImg(bmp0, fileFullPath + appfileName, ((long)90));
//bmp0.Save(fileFullPath + fileName);
bmp0.Dispose();
routeModel.AppImg = appfileName;
if (oldAppImage != "")
{
Function.DeleteFile(fileFullPath + oldAppImage);
}
}
routeModel.Image += fileName + ",";
if (oldImages.Length > i)
{
Function.DeleteFile(fileFullPath + oldImages[i]);
}
}
else //没有新图片时使用对应的旧图
{
if (oldImages.Length > i)
{
routeModel.Image += oldImages[i] + ",";
}
}
}
if (!string.IsNullOrEmpty(routeModel.Image))
{
routeModel.Image = routeModel.Image.Substring(0, routeModel.Image.Length - 1);
}
}
else
{
routeModel.Image = Request.Form["Image_Hidden"];
}
if (routeModel.AppImg == "")
{
string fileName = routeModel.Image.Split(',')[0];
//缩图
Bitmap tmp = new Bitmap(fileFullPath + fileName);
Bitmap bmp0 = Function.MakeThumNail(tmp, 100, 64);
tmp.Dispose();
string ext = Path.GetExtension(fileName);
string appfileName = Function.GetRandomTime() + ext;
Function.SaveBitmapImg(bmp0, fileFullPath + appfileName, ((long)90));
bmp0.Dispose();
routeModel.AppImg = appfileName;
}
//end
if (routeBLL.Update(routeModel) > 0)
{
bool oldDetailType = Convert.ToBoolean(Request.Form["DetailType_Hidden"]);
if (oldDetailType)
{
//delete
ClassLibrary.BLL.RouteDetails routeDetailBll = new ClassLibrary.BLL.RouteDetails();
routeDetailBll.DeleteByRouteId(routeId);
}
if (routeModel.DetailType)
{
//update
ClassLibrary.Model.RouteDetails routeDetailModel;
ClassLibrary.BLL.RouteDetails routeDetailBll = new ClassLibrary.BLL.RouteDetails();
for (int j = 1; j <= Int32.Parse(routeModel.RouteTime); j++)
{
routeDetailModel = new ClassLibrary.Model.RouteDetails();
routeDetailModel.RouteID = routeModel.ID;
routeDetailModel.DayOrder = j;
routeDetailModel.DayTitle = Request.Form["route_" + j + "_0"];
if (Convert.ToBoolean(Request.Form["rdo_title_" + j]))
{
routeDetailModel.DayTitle = Request.Form["route_" + j + "_0_0"];
int snum = Convert.ToInt32(Request.Form["jd_title_sc" + j]);
for (int k = 1; k < snum; k++)
{
routeDetailModel.DayTitle += "<em class='tfc" + Request.Form["s_route_" + j + "_0_" + (k - 1)] + "'></em>";
routeDetailModel.DayTitle += Request.Form["route_" + j + "_0_" + k];
}
routeDetailModel.Titletype = true;
routeDetailModel.Scenicnum = snum;
}
routeDetailModel.DayDetail = ClassLibrary.BLL.WebClass.addInternelLink(Request.Form["route_" + j + "_1"], 1, null);
routeDetailModel.Breakfastdesc = Request.Form["route_" + j + "_6"];
routeDetailModel.Lunchdesc = Request.Form["route_" + j + "_7"];
routeDetailModel.Dinnerdesc = Request.Form["route_" + j + "_8"];
if (Request.Form["route_" + j + "_2"] != null)
{
routeDetailModel.BreakFast = true;
}
if (Request.Form["route_" + j + "_3"] != null)
{
routeDetailModel.Lunch = true;
}
if (Request.Form["route_" + j + "_4"] != null)
{
routeDetailModel.Dinner = true;
}
routeDetailModel.Hotel = Request.Form["route_" + j + "_5"];
routeDetailBll.Add(routeDetailModel);
}
}
Function.goMessagePage("修改路线", "操作成功", "Routes/RouteList.aspx");
}
else
{
Function.goMessagePage("修改路线", "操作失败，请稍后再试", "Routes/RouteList.aspx");
}
}
private void BindData()
{
myModel = routeBLL.GetModel(routeId);
if (myModel != null)
{
themeID = myModel.ThemeID;
routeClassId = Int32.Parse(myModel.routesClassID.Split(',')[1]);
routeParentId = Int32.Parse(myModel.routesClassID.Split(',')[0]);
trafficModel1 = myModel.TrafficModel.Substring(0, 2);
trafficModel2 = myModel.TrafficModel.Substring(4, 2);
title = myModel.Title;
price = Convert.ToInt32(myModel.Price);
routeOrder = myModel.Order;
startPosition = myModel.StartPosition;
routeTime = myModel.RouteTime;
descriptionRoute = myModel.DescriptionRoute;
descriptionPrice = myModel.DescriptionPrice;
recommendHot = myModel.RecommendHot;
destination = myModel.Destination;
supplierName = myModel.Supplier;
supplierTel = myModel.SupplierTel;
seoTitle = myModel.SeoTitle;
bright = myModel.Bright;
boatName = myModel.BoatName;
image = myModel.Image;
appImage = myModel.AppImg;
string[] images = myModel.Image.Split(',');
StringBuilder sbri = new StringBuilder();
for (int i = 0; i < images.Length; i++)
{
sbri.AppendLine("<div>");
sbri.AppendLine("<input type='file' name='Image' onchange='CheckImgFile(this)' />");
sbri.AppendFormat("<img src='{0}' width='70' height='50' />", ClassLibrary.Common.SysConfig.UploadFilePathRoutesImg + images[i]);
sbri.AppendLine("</div>");
}
routeImage = sbri.ToString();
seoKeywords = myModel.SeoKeywords;
seoDescription = myModel.SeoDescription;
viewCount = myModel.ViewCount;
detailType = myModel.DetailType;
dateType = myModel.DateType;
datePrice = "";
if (myModel.DatePrice != "")
{
string[] tmpDatePrice = myModel.DatePrice.Split('|');
string cDate = DateTime.Now.ToShortDateString().ToString();
for (int k = 0; k < tmpDatePrice.Length; k++)
{
string tmpPrices = tmpDatePrice[k];
if (tmpPrices == "")
{
continue;
}
string[] tmpPrice = tmpPrices.Split(',');
TimeSpan ts = DateTime.Parse(tmpPrice[0]) - DateTime.Now;
if (ts.TotalDays > 0)
{
datePrice += tmpPrices + "|";
}
}
}
childPrice = Convert.ToInt32(myModel.ChildPrice);
advanceDays = myModel.AdvanceDays;
routeFeature = myModel.RouteFeature;
routeNotice = myModel.RouteNotice;
isdisplay = myModel.Display;
routeParentClassIds = myModel.routesPrentClassID;
if (detailType)
{
routeList = routeDetailBll.GetModelList("RouteID = '" + routeId + "' order by dayOrder");
StringBuilder sb = new StringBuilder();
for (int i = 1; i <= routeList.Count; i++)
{
ClassLibrary.Model.RouteDetails detail = routeList[i - 1];
sb.AppendFormat("<div class='fieldset xingcheng-by-day' id='day_{0}'>", i);
//sb.AppendFormat("<dl><dd><b>第{0}天：<input class='text' id='route_{0}_0' name='route_{0}_0' style='width:300px;' value='{1}'/></b>{2}</dd></dl>", i, detail.DayTitle, (i != 1) ? (" <a id='remove_day" + i + "' href='#' onclick='xingcheng_remove_day();return false;' style='display:" + ((i == routeList.Count) ? "" : "none") + "'>删除第" + i + "天行程</a>") : "");
sb.AppendFormat("<dl><dd><b>第{0}天：<input type='radio' name='rdo_title_{0}' value='False' {1} onclick='checkTitle(this,{0})' />按标题<input class='text' id='route_{0}_0' name='route_{0}_0' value='{3}' style='width:300px;{2}' />",
i, detail.Titletype ? "" : "checked='checked'", detail.Titletype ? "display:none;" : "", detail.Titletype ? "" : detail.DayTitle);
sb.AppendFormat("<input type='radio' name='rdo_title_{0}' value='True' {1} onclick='checkTitle(this,{0})' />按景点</b>{2}</dd></dl>",
i, detail.Titletype ? "checked='checked'" : "", (i != 1) ? (" <a id='remove_day" + i + "' href='#' onclick='xingcheng_remove_day();return false;' style='display:" + ((i == routeList.Count) ? "" : "none") + "'>删除第" + i + "天行程</a>") : "");
if (detail.Titletype)
{
string[] dtitle = new string[detail.Scenicnum];
string[] dslt = new string[detail.Scenicnum - 1];
string tle = detail.DayTitle;
dtitle[0] = tle.Substring(0, tle.IndexOf("<em"));
for (int m = 1; m < detail.Scenicnum; m++)
{
tle = tle.Substring(tle.IndexOf("tfc") + 3);
dslt[m - 1] = tle.Substring(0, tle.IndexOf("'"));
tle = tle.Substring(tle.IndexOf("</em>") + 5);
if (m == detail.Scenicnum - 1)
{
dtitle[m] = tle;
}
else
{
dtitle[m] = tle.Substring(0, tle.IndexOf("<em"));
}
}
//555<em class='tfc2'></em>444<em class='tfc3'></em>333<em class='tfc1'></em>222<em class='tfc2'></em>111<em class='tfc3'></em>900
sb.AppendFormat("<dl class='titleByJd' id='jd_title_{0}'><dd><input class='text' id='route_{0}_0_0' name='route_{0}_0_0' size='10' value='{1}' /></dd>", i, dtitle[0]);
for (int n = 1; n < detail.Scenicnum; n++)
{
sb.AppendFormat("<dd><select name='s_route_{0}_0_{1}'><option value='1' {2}>=飞机=</option><option value='2' {3}>=汽车=</option><option value='3' {4}>=轮船=</option><option value='4' {5}>=火车=</option></select>",
i, n - 1, dslt[n - 1] == "1" ? "selected" : "", dslt[n - 1] == "2" ? "selected" : "", dslt[n - 1] == "3" ? "selected" : "", dslt[n - 1] == "4" ? "selected" : "");
sb.AppendFormat("<input class='text' id='route_{0}_0_{1}' name='route_{0}_0_{1}' size='10' value='{2}' /></dd>", i, n, dtitle[n]);
}
sb.AppendFormat("<a href='#?' onclick='xingcheng_add_jd({0});'>+添加</a><a href='#?' onclick='xingcheng_remove_jd({0});'>-减少</a>", i);
sb.AppendFormat("<input type='hidden' id='jd_title_sc{0}' name='jd_title_sc{0}' value='{1}' /></dl>", i, detail.Scenicnum);
}
sb.AppendFormat("<dl><dt>行程安排：</dt>");
sb.AppendFormat("<dd><div class='add_del_box'>");
sb.AppendFormat("<textarea id='route_{0}_1' name='route_{0}_1' style='width:700px;' rows='15'>{1}</textarea>", i, detail.DayDetail);
sb.AppendFormat("</div></dd></dl>");
sb.AppendFormat("<dl class='hotel'><dd>");
sb.AppendFormat("<div class='floatL'>早餐：<input id='route_{0}_2' name='route_{0}_2' type='checkbox' {2} /><input class='text text160' id='route_{0}_6' name='route_{0}_6' type='text' size='20' value='{1}' /></div>", i, detail.Breakfastdesc, detail.BreakFast ? "checked" : "");
sb.AppendFormat("<div class='floatL'>中餐：<input id='route_{0}_3' name='route_{0}_3' type='checkbox' {2} /><input class='text text160' id='route_{0}_7' name='route_{0}_7' type='text' size='20' value='{1}' /></div>", i, detail.Lunchdesc, detail.Lunch ? "checked" : "");
sb.AppendFormat("<div class='floatL'>晚餐：<input id='route_{0}_4' name='route_{0}_4' type='checkbox' {2} /><input class='text text160' id='route_{0}_8' name='route_{0}_8' type='text' size='20' value='{1}' /></div>", i, detail.Dinnerdesc, detail.Dinner ? "checked" : "");
sb.AppendFormat("</dd></dl>");
sb.AppendFormat("<dl><dt>住宿：<input type='text' class='text text160' id='route_{0}_5' name='route_{0}_5' value='{1}'/></dt></dl></div>", i, detail.Hotel);
}
routeDetails = sb.ToString();
}
else
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<div class='fieldset xingcheng-by-day' id='day_1'>");
//sb.AppendFormat("<dl><dd><b>第1天：<input class='text' id='route_1_0' name='route_1_0' style='width:300px;' /></b></dd></dl>");
sb.AppendFormat("<dl><dd><b>第1天：<input type='radio' name='rdo_title_1' value='False' checked='checked' onclick='checkTitle(this,1)' />按标题<input class='text' id='route_1_0' name='route_1_0' style='width:300px;' />");
sb.AppendFormat("<input type='radio' name='rdo_title_1' value='True' onclick='checkTitle(this,1)' />按景点</b></dd></dl>");
sb.AppendFormat("<dl><dt>行程安排：</dt>");
sb.AppendFormat("<dd><div class='add_del_box'>");
sb.AppendFormat("<textarea id='route_1_1' name='route_1_1' style='width:700px;' rows='15'></textarea>");
sb.AppendFormat("</div></dd></dl>");
sb.AppendFormat("<dl class='hotel'><dd>");
sb.AppendFormat("<div class='floatL'>早餐：<input id='route_1_2' name='route_1_2' type='checkbox' /><input class='text text160' id='route_1_6' name='route_1_6' type='text' size='20' /></div>");
sb.AppendFormat("<div class='floatL'>中餐：<input id='route_1_3' name='route_1_3' type='checkbox' /><input class='text text160' id='route_1_7' name='route_1_7' type='text' size='20' /></div>");
sb.AppendFormat("<div class='floatL'>晚餐：<input id='route_1_4' name='route_1_4' type='checkbox' /><input class='text text160' id='route_1_8' name='route_1_8' type='text' size='20' /></div>");
sb.AppendFormat("</dd></dl>");
sb.AppendFormat("<dl><dt>住宿：<input type='text' class='text text160' id='route_1_5' name='route_1_5' /></dt></dl></div>");
routeDetails = sb.ToString();
}
}
else
{
Function.goMessagePage("修改路线", "操作失败，数据不存在!", "Routes/RouteList.aspx");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">Routes对象</param>
public int Add(ClassLibrary.Model.Routes model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("INSERT INTO {0}(", table));
strSql.Append("routesClassID,routesPrentClassID,Title,Price,Image,StartPosition,Destination,RouteTime,TrafficModel,DescriptionRoute,DescriptionPrice," +
"ViewCount,LastUpdateTimeRoute,LastUpdateTimePrice,RecommendHot,CreatedTime,ThemeID,SeoKeywords,SeoDescription,RouteOrder,IsDisplay,FirstTime," +
"DetailType,ChildPrice,DatePrice,DateType,AdvanceDays,RouteFeature,RouteNotice,Supplier,seoTitle,Bright,BoatName,LocationID,SupplierTel,appImg");
strSql.Append(") VALUES (");
strSql.Append("@routesClassID,@routesPrentClassID,@Title,@Price,@Image,@StartPosition,@Destination,@RouteTime,@TrafficModel,@DescriptionRoute,@DescriptionPrice," +
"@ViewCount,@LastUpdateTimeRoute,@LastUpdateTimePrice,@RecommendHot,@CreatedTime,@ThemeID,@SeoKeywords,@SeoDescription,@RouteOrder,@IsDisplay,@FirstTime," +
"@DetailType,@ChildPrice,@DatePrice,@DateType,@AdvanceDays,@RouteFeature,@RouteNotice,@Supplier,@seoTitle,@Bright,@BoatName,@LocationID,@SupplierTel,@appImg)");
SqlParameter[] parameters =
{
new SqlParameter("@routesClassID", SqlDbType.NVarChar, 20),
new SqlParameter("@routesPrentClassID", SqlDbType.NVarChar, 200),
new SqlParameter("@Title", SqlDbType.NVarChar, 200),
new SqlParameter("@Price", SqlDbType.Decimal, 9),
new SqlParameter("@Image", SqlDbType.NVarChar, 400),
new SqlParameter("@StartPosition", SqlDbType.NVarChar, 60),
new SqlParameter("@Destination", SqlDbType.NVarChar, 60),
new SqlParameter("@RouteTime", SqlDbType.NVarChar, 40),
new SqlParameter("@TrafficModel", SqlDbType.NVarChar, 40),
new SqlParameter("@DescriptionRoute", SqlDbType.NText),
new SqlParameter("@DescriptionPrice", SqlDbType.NText),
new SqlParameter("@ViewCount", SqlDbType.Int, 4),
new SqlParameter("@LastUpdateTimeRoute", SqlDbType.DateTime, 8),
new SqlParameter("@LastUpdateTimePrice", SqlDbType.DateTime, 8),
new SqlParameter("@RecommendHot", SqlDbType.Bit, 1),
new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8),
new SqlParameter("@ThemeID", SqlDbType.NVarChar, 50),
new SqlParameter("@SeoKeywords", SqlDbType.NVarChar, 500),
new SqlParameter("@SeoDescription", SqlDbType.NVarChar, 500),
new SqlParameter("@RouteOrder", SqlDbType.Int, 9),
new SqlParameter("@IsDisplay", SqlDbType.Bit, 1),
new SqlParameter("@FirstTime", SqlDbType.NVarChar, 10),
new SqlParameter("@DetailType", SqlDbType.Bit, 1),
new SqlParameter("@ChildPrice", SqlDbType.Decimal, 9),
new SqlParameter("@DatePrice", SqlDbType.NVarChar, 2000),
new SqlParameter("@DateType", SqlDbType.Bit, 1),
new SqlParameter("@AdvanceDays", SqlDbType.Int, 4),
new SqlParameter("@RouteFeature", SqlDbType.NText),
new SqlParameter("@RouteNotice", SqlDbType.NText),
new SqlParameter("@Supplier", SqlDbType.NVarChar, 20),
new SqlParameter("@seoTitle", SqlDbType.NVarChar, 100),
new SqlParameter("@Bright", SqlDbType.NVarChar, 100),
new SqlParameter("@BoatName", SqlDbType.NVarChar, 10),
new SqlParameter("@LocationID", SqlDbType.Int, 4),
new SqlParameter("@SupplierTel", SqlDbType.NVarChar, 20),
new SqlParameter("@appImg", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.routesClassID;
parameters[1].Value = model.routesPrentClassID;
parameters[2].Value = model.Title;
parameters[3].Value = model.Price;
parameters[4].Value = model.Image;
parameters[5].Value = model.StartPosition;
parameters[6].Value = model.Destination;
parameters[7].Value = model.RouteTime;
parameters[8].Value = model.TrafficModel;
parameters[9].Value = model.DescriptionRoute;
parameters[10].Value = model.DescriptionPrice;
parameters[11].Value = model.ViewCount;
parameters[12].Value = model.LastUpdateTimeRoute;
parameters[13].Value = model.LastUpdateTimePrice;
parameters[14].Value = model.RecommendHot;
parameters[15].Value = model.CreatedTime;
parameters[16].Value = model.ThemeID;
parameters[17].Value = model.SeoKeywords;
parameters[18].Value = model.SeoDescription;
parameters[19].Value = model.Order;
parameters[20].Value = model.Display;
parameters[21].Value = model.FirstTime;
parameters[22].Value = model.DetailType;
parameters[23].Value = model.ChildPrice;
parameters[24].Value = model.DatePrice;
parameters[25].Value = model.DateType;
parameters[26].Value = model.AdvanceDays;
parameters[27].Value = model.RouteFeature;
parameters[28].Value = model.RouteNotice;
parameters[29].Value = model.Supplier;
parameters[30].Value = model.SeoTitle;
parameters[31].Value = model.Bright;
parameters[32].Value = model.BoatName;
parameters[33].Value = model.LocationID;
parameters[34].Value = model.SupplierTel;
parameters[35].Value = model.AppImg;
return(SQLHelper.Execute(strSql.ToString(), parameters));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="ID">主键ID</param>
/// <returns>Routes对象</returns>
public ClassLibrary.Model.Routes GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT *");
strSql.Append(" FROM ");
strSql.Append(table);
strSql.Append(string.Format(" WHERE {0}=@{0}", pk));
SqlParameter[] parameters =
{
new SqlParameter("@" + pk, SqlDbType.Int, 6)
};
parameters[0].Value = ID;
ClassLibrary.Model.Routes model = new ClassLibrary.Model.Routes();
DataTable dt = SQLHelper.Query(strSql.ToString(), parameters);
model.ID = ID;
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["routesClassID"] != DBNull.Value)
{
model.routesClassID = Convert.ToString(dt.Rows[0]["routesClassID"]);
}
if (dt.Rows[0]["routesPrentClassID"] != DBNull.Value)
{
model.routesPrentClassID = Convert.ToString(dt.Rows[0]["routesPrentClassID"]);
}
if (dt.Rows[0]["ThemeID"] != DBNull.Value)
{
model.ThemeID = Convert.ToString(dt.Rows[0]["ThemeID"]);
}
if (dt.Rows[0]["Title"] != DBNull.Value)
{
model.Title = Convert.ToString(dt.Rows[0]["Title"]);
}
if (dt.Rows[0]["Price"] != DBNull.Value)
{
model.Price = Convert.ToDecimal(dt.Rows[0]["Price"]);
}
if (dt.Rows[0]["Image"] != DBNull.Value)
{
model.Image = Convert.ToString(dt.Rows[0]["Image"]);
}
if (dt.Rows[0]["StartPosition"] != DBNull.Value)
{
model.StartPosition = Convert.ToString(dt.Rows[0]["StartPosition"]);
}
if (dt.Rows[0]["Destination"] != DBNull.Value)
{
model.Destination = Convert.ToString(dt.Rows[0]["Destination"]);
}
if (dt.Rows[0]["RouteTime"] != DBNull.Value)
{
model.RouteTime = Convert.ToString(dt.Rows[0]["RouteTime"]);
}
if (dt.Rows[0]["TrafficModel"] != DBNull.Value)
{
model.TrafficModel = Convert.ToString(dt.Rows[0]["TrafficModel"]);
}
if (dt.Rows[0]["DescriptionRoute"] != DBNull.Value)
{
model.DescriptionRoute = Convert.ToString(dt.Rows[0]["DescriptionRoute"]);
}
if (dt.Rows[0]["DescriptionPrice"] != DBNull.Value)
{
model.DescriptionPrice = Convert.ToString(dt.Rows[0]["DescriptionPrice"]);
}
if (dt.Rows[0]["ViewCount"] != DBNull.Value)
{
model.ViewCount = Convert.ToInt32(dt.Rows[0]["ViewCount"]);
}
if (dt.Rows[0]["LastUpdateTimeRoute"] != DBNull.Value)
{
model.LastUpdateTimeRoute = Convert.ToDateTime(dt.Rows[0]["LastUpdateTimeRoute"]);
}
if (dt.Rows[0]["LastUpdateTimePrice"] != DBNull.Value)
{
model.LastUpdateTimePrice = Convert.ToDateTime(dt.Rows[0]["LastUpdateTimePrice"]);
}
if (dt.Rows[0]["RecommendHot"] != DBNull.Value)
{
model.RecommendHot = Convert.ToBoolean(dt.Rows[0]["RecommendHot"]);
}
if (dt.Rows[0]["CreatedTime"] != DBNull.Value)
{
model.CreatedTime = Convert.ToDateTime(dt.Rows[0]["CreatedTime"]);
}
if (dt.Rows[0]["SeoKeywords"] != DBNull.Value)
{
model.SeoKeywords = Convert.ToString(dt.Rows[0]["SeoKeywords"]);
}
if (dt.Rows[0]["SeoDescription"] != DBNull.Value)
{
model.SeoDescription = Convert.ToString(dt.Rows[0]["SeoDescription"]);
}
if (dt.Rows[0]["IsDisplay"] != DBNull.Value)
{
model.Display = Convert.ToBoolean(dt.Rows[0]["IsDisplay"]);
}
model.FirstTime = dt.Rows[0]["FirstTime"].ToString();
if (dt.Rows[0]["DetailType"] != DBNull.Value)
{
model.DetailType = Convert.ToBoolean(dt.Rows[0]["DetailType"]);
}
if (dt.Rows[0]["DateType"] != DBNull.Value)
{
model.DateType = Convert.ToBoolean(dt.Rows[0]["DateType"]);
}
if (dt.Rows[0]["DatePrice"] != DBNull.Value)
{
model.DatePrice = Convert.ToString(dt.Rows[0]["DatePrice"]);
}
if (dt.Rows[0]["ChildPrice"] != DBNull.Value)
{
model.ChildPrice = Convert.ToDecimal(dt.Rows[0]["ChildPrice"]);
}
if (dt.Rows[0]["AdvanceDays"] != DBNull.Value)
{
model.AdvanceDays = Convert.ToInt32(dt.Rows[0]["AdvanceDays"]);
}
if (dt.Rows[0]["RouteFeature"] != DBNull.Value)
{
model.RouteFeature = Convert.ToString(dt.Rows[0]["RouteFeature"]);
}
if (dt.Rows[0]["RouteNotice"] != DBNull.Value)
{
model.RouteNotice = Convert.ToString(dt.Rows[0]["RouteNotice"]);
}
if (dt.Rows[0]["RouteOrder"] != DBNull.Value)
{
model.Order = Convert.ToInt32(dt.Rows[0]["RouteOrder"]);
}
if (dt.Rows[0]["Supplier"] != DBNull.Value)
{
model.Supplier = Convert.ToString(dt.Rows[0]["Supplier"]);
}
if (dt.Rows[0]["seoTitle"] != DBNull.Value)
{
model.SeoTitle = Convert.ToString(dt.Rows[0]["seoTitle"]);
}
if (dt.Rows[0]["Bright"] != DBNull.Value)
{
model.Bright = Convert.ToString(dt.Rows[0]["Bright"]);
}
if (dt.Rows[0]["BoatName"] != DBNull.Value)
{
model.BoatName = Convert.ToString(dt.Rows[0]["BoatName"]);
}
if (dt.Rows[0]["LocationID"] != DBNull.Value)
{
model.LocationID = Convert.ToInt32(dt.Rows[0]["LocationID"]);
}
if (dt.Rows[0]["SupplierTel"] != DBNull.Value)
{
model.SupplierTel = Convert.ToString(dt.Rows[0]["SupplierTel"]);
}
if (dt.Rows[0]["appImg"] != DBNull.Value)
{
model.AppImg = Convert.ToString(dt.Rows[0]["appImg"]);
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">Routes对象</param>
/// <returns>影响行数</returns>
public int Update(ClassLibrary.Model.Routes model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("UPDATE {0} SET ", table));
strSql.Append("routesClassID=@routesClassID,");
strSql.Append("routesPrentClassID=@routesPrentClassID,");
strSql.Append("Title=@Title,");
strSql.Append("Price=@Price,");
strSql.Append("Image=@Image,");
strSql.Append("StartPosition=@StartPosition,");
strSql.Append("Destination=@Destination,");
strSql.Append("RouteTime=@RouteTime,");
strSql.Append("TrafficModel=@TrafficModel,");
strSql.Append("DescriptionRoute=@DescriptionRoute,");
strSql.Append("DescriptionPrice=@DescriptionPrice,");
strSql.Append("ViewCount=@ViewCount,");
strSql.Append("LastUpdateTimeRoute=@LastUpdateTimeRoute,");
strSql.Append("LastUpdateTimePrice=@LastUpdateTimePrice,");
strSql.Append("RecommendHot=@RecommendHot,");
strSql.Append("CreatedTime=@CreatedTime,");
strSql.Append("ThemeID=@ThemeID,");
strSql.Append("SeoKeywords=@SeoKeywords,");
strSql.Append("SeoDescription=@SeoDescription,");
strSql.Append("RouteOrder=@RouteOrder,");
strSql.Append("IsDisplay=@IsDisplay,");;
strSql.Append("DetailType=@DetailType,");
strSql.Append("ChildPrice=@ChildPrice,");
strSql.Append("DatePrice=@DatePrice,");
strSql.Append("DateType=@DateType,");
strSql.Append("AdvanceDays=@AdvanceDays,");
strSql.Append("RouteFeature=@RouteFeature,");
strSql.Append("RouteNotice=@RouteNotice,");
strSql.Append("Supplier=@Supplier,");
strSql.Append("seoTitle=@seoTitle,");
strSql.Append("Bright=@Bright,");
strSql.Append("BoatName=@BoatName,");
strSql.Append("LocationID=@LocationID,");
strSql.Append("SupplierTel=@SupplierTel,");
strSql.Append("appImg=@appImg ");
strSql.Append(" WHERE ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 6),
new SqlParameter("@routesClassID", SqlDbType.NVarChar, 20),
new SqlParameter("@routesPrentClassID", SqlDbType.NVarChar, 200),
new SqlParameter("@Title", SqlDbType.NVarChar, 200),
new SqlParameter("@Price", SqlDbType.Decimal, 9),
new SqlParameter("@Image", SqlDbType.NVarChar, 400),
new SqlParameter("@StartPosition", SqlDbType.NVarChar, 60),
new SqlParameter("@Destination", SqlDbType.NVarChar, 60),
new SqlParameter("@RouteTime", SqlDbType.NVarChar, 40),
new SqlParameter("@TrafficModel", SqlDbType.NVarChar, 40),
new SqlParameter("@DescriptionRoute", SqlDbType.NText),
new SqlParameter("@DescriptionPrice", SqlDbType.NText),
new SqlParameter("@ViewCount", SqlDbType.Int, 6),
new SqlParameter("@LastUpdateTimeRoute", SqlDbType.DateTime, 8),
new SqlParameter("@LastUpdateTimePrice", SqlDbType.DateTime, 8),
new SqlParameter("@RecommendHot", SqlDbType.Bit, 1),
new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8),
new SqlParameter("@ThemeID", SqlDbType.NVarChar, 50),
new SqlParameter("@SeoKeywords", SqlDbType.NVarChar, 500),
new SqlParameter("@SeoDescription", SqlDbType.NVarChar, 500),
new SqlParameter("@RouteOrder", SqlDbType.Int, 9),
new SqlParameter("@IsDisplay", SqlDbType.Bit, 1),
new SqlParameter("@DetailType", SqlDbType.Bit, 1),
new SqlParameter("@ChildPrice", SqlDbType.Decimal, 9),
new SqlParameter("@DatePrice", SqlDbType.NVarChar, 2000),
new SqlParameter("@DateType", SqlDbType.Bit, 1),
new SqlParameter("@AdvanceDays", SqlDbType.Int, 4),
new SqlParameter("@RouteFeature", SqlDbType.NText),
new SqlParameter("@RouteNotice", SqlDbType.NText),
new SqlParameter("@Supplier", SqlDbType.NVarChar, 20),
new SqlParameter("@seoTitle", SqlDbType.NVarChar, 100),
new SqlParameter("@Bright", SqlDbType.NVarChar, 100),
new SqlParameter("@BoatName", SqlDbType.NVarChar, 10),
new SqlParameter("@LocationID", SqlDbType.Int, 4),
new SqlParameter("@SupplierTel", SqlDbType.NVarChar, 20),
new SqlParameter("@appImg", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.routesClassID;
parameters[2].Value = model.routesPrentClassID;
parameters[3].Value = model.Title;
parameters[4].Value = model.Price;
parameters[5].Value = model.Image;
parameters[6].Value = model.StartPosition;
parameters[7].Value = model.Destination;
parameters[8].Value = model.RouteTime;
parameters[9].Value = model.TrafficModel;
parameters[10].Value = model.DescriptionRoute;
parameters[11].Value = model.DescriptionPrice;
parameters[12].Value = model.ViewCount;
parameters[13].Value = model.LastUpdateTimeRoute;
parameters[14].Value = model.LastUpdateTimePrice;
parameters[15].Value = model.RecommendHot;
parameters[16].Value = model.CreatedTime;
parameters[17].Value = model.ThemeID;
parameters[18].Value = model.SeoKeywords;
parameters[19].Value = model.SeoDescription;
parameters[20].Value = model.Order;
parameters[21].Value = model.Display;
parameters[22].Value = model.DetailType;
parameters[23].Value = model.ChildPrice;
parameters[24].Value = model.DatePrice;
parameters[25].Value = model.DateType;
parameters[26].Value = model.AdvanceDays;
parameters[27].Value = model.RouteFeature;
parameters[28].Value = model.RouteNotice;
parameters[29].Value = model.Supplier;
parameters[30].Value = model.SeoTitle;
parameters[31].Value = model.Bright;
parameters[32].Value = model.BoatName;
parameters[33].Value = model.LocationID;
parameters[34].Value = model.SupplierTel;
parameters[35].Value = model.AppImg;
return(SQLHelper.Execute(strSql.ToString(), parameters));
}
