private void BindData()
{
searchKey = Function.GetQueryString("key");
string where = "1=1";
if (searchKey != "")
{
where += " and CHARINDEX('" + searchKey + "',Title) > 0";
}
DataSet mySet = linksBLL.GetPageData(pageSize, pageIndex, where, "");
DataTable tableCount = mySet.Tables["Count"];
DataTable myTable = mySet.Tables["Data"];
int countRows = 0;
countRows = Convert.ToInt32(tableCount.Rows[0][0].ToString());
string[] urlParam = { "key", "cid1", "cid2" };
pageInfo = pg.pageForDynamic(countRows, 20, pageIndex, urlParam);
StringBuilder sb = new StringBuilder();
int i = 0;
int rowIndex = 0;
foreach (DataRow dr in myTable.Rows)
{
i++;
rowIndex = pageSize * (pageIndex - 1) + i;
sb.AppendFormat("<tr id='tr_{0}'>", dr["ID"].ToString());
sb.AppendFormat("<td align='center'>{0}</td>", rowIndex);
sb.AppendFormat("<td>{0}</td>", dr["Title"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["LinkURL"].ToString());
sb.Append("<td align='center'>");
sb.AppendFormat("<a href='InternalLinkEdit.aspx?id={0}'>修改</a> ", dr["ID"].ToString());
sb.AppendFormat("<a href='javascript:void(0)' onclick='InternalLinkDelete({0})'>删除</a>", dr["ID"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
}
if (sb.Length == 0)
{
sb.Append("<tr><td colspan='4'>没有相关数据</td></tr>");
}
linksList = sb.ToString();
}
private void BindData()
{
searchKey = Function.GetQueryString("key");
int routeClassID = -1;
string strWhere = "1=1 ";
//搜索 - 大类
searchClass1 = Function.GetQueryString("cid1");
if (Function.IsNumber(searchClass1))
{
routeClassID = Convert.ToInt32(searchClass1);
}
//搜索 - 小类
searchClass2 = Function.GetQueryString("cid2");
if (Function.IsNumber(searchClass2))
{
routeClassID = Convert.ToInt32(searchClass2);
}
//跟据传过来的类别ID
if (routeClassID != -1)
{
strWhere += " AND LinkClass = " + routeClassID;
}
if (!string.IsNullOrEmpty(searchKey))
{
strWhere += " AND CHARINDEX('" + searchKey + "',LinkUrl)>0";
}
DataSet mySet = linksBLL.GetPageData(pageSize, pageIndex, strWhere, "CreatedTime Desc");
DataTable tableCount = mySet.Tables["Count"];
DataTable myTable = mySet.Tables["Data"];
int countRows = 0;
countRows = Convert.ToInt32(tableCount.Rows[0][0].ToString());
string[] urlParam = { "key", "cid1", "cid2" };
pageInfo = pg.pageForDynamic(countRows, pageSize, pageIndex, urlParam);
StringBuilder sb = new StringBuilder();
int i = 0;
int rowIndex = 0;
foreach (DataRow dr in myTable.Rows)
{
i++;
rowIndex = pageSize * (pageIndex - 1) + i;
sb.AppendFormat("<tr id='tr_{0}'>", dr["ID"].ToString());
sb.AppendFormat("<td align='center'><input type='checkbox' name='linksCheckbox' id='checkbox{0}' value='{0}' /></td>", dr["ID"].ToString());
sb.AppendFormat("<td align='center'>{0}</td>", rowIndex);
sb.AppendFormat("<td>{0}</td>", dr["Title"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["LinkURL"].ToString());
string className = "首页";
if (dr["LinkClass"].ToString() != "0")
{
ClassLibrary.Model.RouteClass tclass = list.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == Convert.ToInt32(dr["LinkClass"].ToString())); });
className = tclass.ClassName;
}
sb.AppendFormat("<td>{0}</td>", className);
sb.AppendFormat("<td align='center'>{0}</td>", dr["CreatedTime"].ToString());
sb.Append("<td align='center'>");
sb.AppendFormat("<a href='LinksEdit.aspx?id={0}'>修改</a> ", dr["ID"].ToString());
sb.AppendFormat("<a href='javascript:void(0)' onclick='linksDelete({0})'>删除</a>", dr["ID"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
}
if (sb.Length == 0)
{
sb.Append("<tr><td colspan='5'>没有相关数据</td></tr>");
}
linksList = sb.ToString();
}
private void BindData()
{
searchKey = Function.GetQueryString("key");
supKey = Function.GetQueryString("sKey");
int routeClassID = 0;
string strWhere = "1=1 ";
//搜索 - 大类
searchClass1 = Function.GetQueryString("cid1");
if (Function.IsNumber(searchClass1))
{
routeClassID = Convert.ToInt32(searchClass1);
}
//搜索 - 小类
searchClass2 = Function.GetQueryString("cid2");
if (Function.IsNumber(searchClass2))
{
routeClassID = Convert.ToInt32(searchClass2);
}
//跟据传过来的类别ID
if (routeClassID != 0)
{
strWhere += " AND (CHARINDEX('," + routeClassID + ",',','+routesPrentClassID+',')>0)";
}
if (!string.IsNullOrEmpty(searchKey))
{
strWhere += " AND CHARINDEX('" + searchKey + "',Title)>0";
}
if (!string.IsNullOrEmpty(supKey))
{
strWhere += " AND CHARINDEX('" + supKey + "',Supplier)>0";
}
/*DataTable myTable = routeBLL.GetData(strWhere, "firstTime desc, createdTime desc");
*
* string[] urlParam = { "key", "cid1", "cid2" };
* myTable = pg.pagination(myTable, 20, urlParam);
* pageInfo = pg.pageNumList;*/
string strOrder = "isdisplay desc";
if (!string.IsNullOrEmpty(supKey))
{
strOrder += ",Supplier desc";
}
if (Function.GetQueryString("rorder") != "")
{
routeorder = Convert.ToInt32(Function.GetQueryString("rorder"));
}
if (Function.GetQueryString("torder") != "")
{
timeorder = Convert.ToInt32(Function.GetQueryString("torder"));
}
if (routeorder != 0)
{
if (routeorder == 1)
{
strOrder += ",RouteOrder asc, createdtime desc";
}
else if (routeorder == 2)
{
strOrder += ",RouteOrder desc, createdtime desc";
}
}
else if (timeorder != 0)
{
if (timeorder == 1)
{
strOrder += ",createdtime desc";
}
else if (timeorder == 2)
{
strOrder += ",createdtime asc";
}
}
else
{
strOrder += ",firstTime desc";
}
DataSet mySet = routeBLL.GetPageData(20, pageIndex, strWhere, strOrder);
DataTable tableCount = mySet.Tables["Count"];
DataTable myTable = mySet.Tables["Data"];
int countRows = 0;
countRows = Convert.ToInt32(tableCount.Rows[0][0].ToString());
string[] urlParam = { "key", "cid1", "cid2", "rorder", "torder", "sKey" };
pageInfo = pg.pageForDynamic(countRows, 20, pageIndex, urlParam);
StringBuilder sb = new StringBuilder();
foreach (DataRow dr in myTable.Rows)
{
sb.AppendFormat("<tr id='tr_{0}'>", dr["ID"].ToString());
sb.AppendFormat("<td align='center'><input type='checkbox' name='routeCheckbox' id='checkbox{0}' value='{0}' /></td>", dr["ID"].ToString());
string pingyin = rcList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == Convert.ToInt32(dr["LocationID"].ToString())); }).ClassNamePY;
sb.AppendFormat("<td title='{1}'><a href='/{3}/{2}.html' target='_blank'>{0}</a></td>", Function.Clip(dr["Title"].ToString(), 10, true), dr["Title"].ToString(), dr["ID"].ToString(), pingyin);
sb.AppendFormat("<td align='center'>{0}</td>", GetRouteClass(Convert.ToInt32(dr["LocationID"].ToString())));
sb.AppendFormat("<td align='center'>{0}<br/>{1}</td>", dr["Supplier"].ToString(), dr["SupplierTel"].ToString());
sb.AppendFormat("<td align='center'><input type='text' class='ipt' id='RoutePrice_{1}' value='{0}' maxlength='6' size='5'/><input type='button' class='button' value='修改' size='3' onclick='UpdateRoutePrice({1})' /></td>", Convert.ToInt32(dr["Price"]) == 0 ? 0 : Convert.ToInt32(dr["Price"]), Convert.ToInt32(dr["ID"].ToString()));
//sb.AppendFormat("<td align='center'>{0}</td>", dr["StartPosition"].ToString());
sb.AppendFormat("<td align='center'><input type='text' class='ipt' id='RouteOrder_{1}' value='{0}' maxlength='5' size='3'/><input type='button' class='button' value='修改' size='3' onclick='UpdateRouteOrder({1})' /></td>", dr["RouteOrder"].ToString(), Convert.ToInt32(dr["ID"].ToString()));
//sb.AppendFormat("<td align='center'>{0}</td>", Function.Clip(dr["Destination"].ToString(), 8, true));
//sb.AppendFormat("<td align='center'><select name='routeShow_{0}' onchange='UpdateRouteShow({0})'><option value='1'>是</option><option value='0'>否</option></select></td>", Convert.ToInt32(dr["ID"].ToString()));
//sb.AppendFormat("<td align='center'>{0}</td>", dr["RouteTime"].ToString());
//sb.AppendFormat("<td align='center'>{0}</td>", dr["TrafficModel"].ToString());
//sb.AppendFormat("<td align='center'>{0}</td>", dr["StartTime"].ToString());
sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToBoolean(dr["RecommendHot"]) ? "<span class='red'>是<span>" : "否");
sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToBoolean(dr["IsDisplay"]) ? "<span class='red'>是</span>" : "否");
sb.AppendFormat("<td align='center'>{0}</td>", dr["ViewCount"].ToString());
sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToDateTime(dr["firstTime"]).ToString("yyyy-MM-dd"));
sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToDateTime(dr["CreatedTime"]).ToString("yyyy-MM-dd"));
//sb.AppendFormat("<td align='center'>{0}</td>", dr["FirstTime"].ToString());
sb.Append("<td align='center'>");
//sb.AppendFormat("<a href='javascript:void(0)' onclick='routeCopy({0})'>复制</a> ", dr["ID"].ToString());
sb.AppendFormat("<a href='RouteEdit.aspx?id={0}'>修改</a> ", dr["ID"].ToString());
sb.AppendFormat("<a href='javascript:void(0)' onclick='routeDelete({0})'>删除</a> ", dr["ID"].ToString());
sb.AppendFormat("<a href='../RouteComment/RouteCommentList.aspx?routeId={0}'>查看评论</a>", dr["ID"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
}
dataRouteList = sb.ToString();
}
private void BindData()
{
int routeClassID = 0;
string strWhere = "1=1 ";
//搜索 - 大类
searchClass1 = Function.GetQueryString("cid1");
if (Function.IsNumber(searchClass1))
{
routeClassID = Convert.ToInt32(searchClass1);
}
//搜索 - 小类
searchClass2 = Function.GetQueryString("cid2");
if (Function.IsNumber(searchClass2))
{
routeClassID = Convert.ToInt32(searchClass2);
}
//跟据传过来的类别ID
if (routeClassID != 0)
{
strWhere += " AND RouteClassID=" + routeClassID;
}
strWhere += " AND month = 0";
DataSet mySet = siBLL.GetPageData(20, pageIndex, strWhere, "createdTime desc");
DataTable tableCount = mySet.Tables["Count"];
DataTable myTable = mySet.Tables["Data"];
int countRows = 0;
countRows = Convert.ToInt32(tableCount.Rows[0][0].ToString());
string[] urlParam = { "key", "cid1", "cid2" };
pageInfo = pg.pageForDynamic(countRows, 20, pageIndex, urlParam);
StringBuilder sb = new StringBuilder();
foreach (DataRow dr in myTable.Rows)
{
sb.AppendFormat("<tr id='tr_{0}'>", dr["ID"].ToString());
string className = rcList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == Convert.ToInt32(dr["RouteClassID"].ToString())); }).ClassName;
sb.AppendFormat("<td align='center'>{0}</td>", className);
string themeName = "";
if (dr["ThemeId"].ToString() != "0")
{
themeName = rcList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == Convert.ToInt32(dr["ThemeId"].ToString())); }).ClassName;
}
sb.AppendFormat("<td align='center'>{0}</td>", themeName);
int days = Convert.ToInt32(dr["Days"].ToString());
string dayName = Enum.GetName(typeof(SysConfig.Numbers), days) + "日游";
if (dr["MaxClassId"].ToString() == "2" && days == 5)
{
dayName += "及以下";
}
if (dr["MaxClassId"].ToString() == "1" && days == 7)
{
dayName += "及以上";
}
if (days == 11)
{
dayName += "及以上";
}
sb.AppendFormat("<td align='center'>{0}</td>", days == 0 ? "" : dayName);
string price = dr["Price"].ToString();
if (price != null && price != "")
{
string[] temPrice = price.Split('-');
if (temPrice[0] == "0")
{
price = temPrice[1] + "元以下";
}
else if (temPrice[1] == "0")
{
price = temPrice[0] + "元以上";
}
else
{
price += "元";
}
}
sb.AppendFormat("<td align='center'>{0}</td>", price);
sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToDateTime(dr["CreatedTime"]).ToString("yyyy-MM-dd"));
sb.Append("<td align='center'>");
sb.AppendFormat("<a href='SeoInfoEdit.aspx?id={0}'>修改</a> ", dr["ID"].ToString());
sb.AppendFormat("<a href='javascript:void(0)' onclick='seoInfoDelete({0})'>删除</a> ", dr["ID"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
}
dataSeoInfoList = sb.ToString();
}