private void RptBind() { Cms.BLL.sc_stores bll = new Cms.BLL.sc_stores(); DataTable dt = bll.GetList("").Tables[0]; this.rptList.DataSource = dt; this.rptList.DataBind(); Cms.BLL.C_Column cm = new Cms.BLL.C_Column(); string classname = cm.GetModel(27).className; bool bladd = adminUser.setpurview(classname, "add"); bool blEdit = adminUser.setpurview(classname, "Edit"); bool blDelete = adminUser.setpurview(classname, "Delete"); if (!bladd) { btnadd.Visible = false; } if (!blEdit) { btnSave.Visible = false; } if (!blDelete) { btnDelete.Visible = false; } }
public static string getcloumnid(int classid) { string result = ""; Cms.BLL.C_Column bll = new Cms.BLL.C_Column(); DataSet ds = bll.GetList("parentId=" + classid); StringBuilder sbuBuilder = new StringBuilder(); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { sbuBuilder.Append(ds.Tables[0].Rows[i]["classId"].ToString() + ","); } if (sbuBuilder.Length > 1) { sbuBuilder.Remove(sbuBuilder.Length - 1, 1); } result = sbuBuilder.ToString(); } else { result = classid.ToString(); } return(result); }
//数据绑定 private void RptBind() { Cms.BLL.C_Column bll = new Cms.BLL.C_Column(); DataTable dt = bll.GetList(0, Cms.Common.Enums.NavigationEnum.System.ToString()); this.rptList.DataSource = dt; this.rptList.DataBind(); bool bladd = adminUser.setpurview("频道管理", "add"); bool blEdit = adminUser.setpurview("频道管理", "Edit"); bool blDelete = adminUser.setpurview("频道管理", "Delete"); if (!bladd) { btnadd.Visible = false; } if (!blEdit) { btnSave.Visible = false; } if (!blDelete) { btnDelete.Visible = false; } }
private static string InitChildListNav(DataRow dr) { DataSet dtt = new Cms.BLL.C_Column().GetList("parentId=" + dr["classid"] + " and isShowChannel=1 order by orderNumber desc"); dtt.Tables[0].Columns.Add("Operate", typeof(string)); dtt.Tables[0].Columns.Add("Colum", typeof(String)); string temp = ""; string strchar = ""; if (dtt.Tables[0].Rows.Count > 0) { for (int k = 0; k < dtt.Tables[0].Rows.Count; k++) { DataRow dro = dtt.Tables[0].Rows[k]; Cms.BLL.C_Column bllcolumn1 = new Cms.BLL.C_Column(); DataSet dtt1 = bllcolumn1.GetList("parentId=" + dro["classid"] + " and isShowChannel=1 order by orderNumber desc"); if (dtt1.Tables[0].Rows.Count > 0) { DataRow dro1 = dtt.Tables[0].Rows[k]; strchar += "<li class='current'><a href='" + getCloumnUrl(Convert.ToInt32(dro1["classId"].ToString())) + "'>" + dro1["className"] + "</a><div class='submenu'>"; strchar += InitChildListNav(dro1); strchar += "</div></li>"; } else { temp += "<a href='" + getCloumnUrl(Convert.ToInt32(dro["classId"].ToString())) + "'><span>——</span> " + dro["className"].ToString() + "</a>"; } } } return(strchar + temp); }
/// <summary> /// 递归栏目信息 /// </summary> /// <param name="n"></param> public void ListControl_Bind(int n) { Cms.BLL.C_Column bllcolumn = new Cms.BLL.C_Column(); Cms.Model.C_Column modelcolumn = new Cms.Model.C_Column(); DataSet dt = bllcolumn.GetList("parentId=" + n + "order by orderNumber desc"); dt.Tables[0].Columns.Add("Operate", typeof(string)); //操作 dt.Tables[0].Columns.Add("Colum", typeof(String)); //在dt中增加字段名为Colum的列 if (dt.Tables[0].Rows.Count > 0) { for (int i = 0; i < dt.Tables[0].Rows.Count; i++) { DataRow dr = dt.Tables[0].Rows[i]; string strchar = ""; dr["operate"] = "<a href='Column_edit.aspx?action=add&classid=" + dr["classid"].ToString() + "&parentId=" + dr["parentId"].ToString() + "'>[添加下级]</a> <a href='Column_edit.aspx?action=edit&classid=" + dr["classid"].ToString() + "&parentId=" + dr["parentId"].ToString() + "'>[编辑]</a> <a href='Column_list.aspx??action=del&classID=" + dr["classid"].ToString() + "&classname=" + dr["className"].ToString() + " ' onclick='return confirm(\"真的要删除该栏目以及子栏目和栏目下的新闻吗?不可恢复!\");'>[删除]</a> "; strchar += "<tr onmouseover=this.bgColor='#EBFFDC'; onmouseout=this.bgColor='#ffffff'; bgcolor='#ffffff'>"; strchar += "<td align=\"center\"><input type='checkbox'/></td> "; strchar += "<td align=\"left\">" + dr["classid"].ToString() + "</td> "; strchar += "<td align=\"left\" >" + dr["className"].ToString() + "</td>"; strchar += "<td align=\"center\" >" + GetClassisShowChannel(dr["isShowChannel"].ToString()) + "</td>"; strchar += "<td align=\"center\" >" + GetClassAttrbute(dr["modelId"].ToString()) + "</td>"; strchar += "<td align=\"left\" >" + dr["orderNumber"].ToString() + "</td>"; strchar += "<td align=\"center\" >" + dr["operate"].ToString() + "</td>"; strchar += "</tr>"; strchar = InitChild(dr, strchar, 2); dr["Colum"] = strchar; } } this.rptList.DataSource = dt; this.rptList.DataBind(); }
/// <summary> /// 递归栏目信息 /// </summary> /// <param name="n"></param> public void ListControl_Bind(int n) { Cms.BLL.C_Column bllcolumn = new Cms.BLL.C_Column(); Cms.Model.C_Column modelcolumn = new Cms.Model.C_Column(); DataSet dt = bllcolumn.GetList("parentId=" + n + ""); dt.Tables[0].Columns.Add("Operate", typeof(string)); //操作 dt.Tables[0].Columns.Add("Colum", typeof(String)); //在dt中增加字段名为Colum的列 if (dt.Tables[0].Rows.Count > 0) { for (int i = 0; i < dt.Tables[0].Rows.Count; i++) { DataRow dr = dt.Tables[0].Rows[i]; string strchar = ""; strchar += "<td style='white-space:nowrap;word-break:break-all;overflow:hidden;' >"; strchar += "<input id='rptList_ctl00_hidName' type='hidden' name='rptList$ctl00$hidName' Value='" + dr["className"].ToString() + "' runat='server' />"; strchar += "<input id=='rptList_ctl00_hidActionType' type='hidden' name='rptList$ctl00$hidActionType' Value='" + dr["action_type"].ToString() + "' runat='server' />"; strchar += "<input id='rptList_ctl00_hidLayer' type='hidden' name='rptList$ctl00$hidLayer' Value='" + dr["class_layer"].ToString() + "' runat='server' />"; strchar += "<span class='folder-open'></span>"; strchar += dr["className"].ToString(); strchar += "</td>"; strchar = InitChild(dr, strchar, 2); dr["Colum"] = strchar; } } this.rptList.DataSource = dt; this.rptList.DataBind(); }
public static string listNav(int classId) { string result = ""; DataSet dt = new Cms.BLL.C_Column().GetList("parentId=" + getParentId(classId) + " and isShowChannel=1 order by orderNumber desc"); dt.Tables[0].Columns.Add("Operate", typeof(string)); //操作 dt.Tables[0].Columns.Add("Colum", typeof(String)); //在dt中增加字段名为Colum的列 if (dt.Tables[0].Rows.Count > 0) { for (int i = 0; i < dt.Tables[0].Rows.Count; i++) { DataRow dr = dt.Tables[0].Rows[i]; string strchar = ""; if (dr["classId"].ToString() == classId.ToString()) { strchar += " <li class='current'><a href='" + getCloumnUrl(Convert.ToInt32(dr["classId"].ToString())) + "'>" + dr["className"] + "</a><div class='submenu'>"; } else { strchar += "<li><a href='" + getCloumnUrl(Convert.ToInt32(dr["classId"].ToString())) + "'>" + dr["className"] + "</a><div class='submenu'>"; } strchar += InitChildListNav(dr); strchar += "</div></li>"; result = result + strchar; } } return(result); }
private void RptBind(int id) { Cms.BLL.C_article_category bll = new Cms.BLL.C_article_category(); DataTable dt = bll.GetList(0, this.channel_id, "where channel_id=" + id); this.rptList.DataSource = dt; this.rptList.DataBind(); Cms.BLL.C_Column cm = new Cms.BLL.C_Column(); string classname = cm.GetModel(27).className; bool bladd = adminUser.setpurview(classname, "add"); bool blEdit = adminUser.setpurview(classname, "Edit"); bool blDelete = adminUser.setpurview(classname, "Delete"); if (!bladd) { btnadd.Visible = false; } if (!blEdit) { btnSave.Visible = false; } if (!blDelete) { btnDelete.Visible = false; } }
public static string getCloumnUrl(int id) { string result = ""; Cms.Model.C_Column model = new Cms.BLL.C_Column().GetModel(id); if (model != null) { if (model.linkUrl != null && model.linkUrl == "") { if (model.modelId == 1) { DataSet ds = new Cms.BLL.C_Column().GetList(1, "parentId=" + id, "orderNumber desc,classId asc"); if (ds != null && ds.Tables[0].Rows.Count > 0) { result = "/htm/" + ds.Tables[0].Rows[0]["tpl_channel"].ToString() + ".aspx?classId=" + ds.Tables[0].Rows[0]["classId"].ToString(); } } else { result = "/htm/" + model.tplChannel + ".aspx?classId=" + id; } } else { result = model.linkUrl; } } return(result); }
public void getArticle() { string parentId = Request["parentId"]; int pagenow = Convert.ToInt32(Request["page"] ?? "0"); int pageSize = Convert.ToInt32(Request["pageSize"] ?? "3"); int start = (pagenow - 1) * pageSize + 1; int end = pagenow * pageSize; if (pagenow == 0) { end = 3; } string tearname = new Cms.BLL.C_Column().GetModel(Convert.ToInt32(parentId)).name.ToString(); string str = "SELECT * FROM ( SELECT ROW_NUMBER() OVER (order by T.orderNumber desc, T.articleId desc )AS Row, T.* from view_channel_" + tearname + " T WHERE parentId=" + parentId + " ) TT WHERE TT.Row between " + start + " and " + end + " order by orderNumber desc,articleId desc"; DataSet ds = Cms.DBUtility.DbHelperSQL.Query(str); if (ds != null && ds.Tables[0].Rows.Count > 0) { string strJson = ConvertJson.ToJson(ds); Response.Write(strJson); Response.End(); } else { Response.Write("{\"status\":1}"); Response.End(); } }
//美化列表 protected void rptList_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item) { Literal LitFirst = (Literal)e.Item.FindControl("LitFirst"); HiddenField hidLayer = (HiddenField)e.Item.FindControl("hidLayer"); string LitStyle = "<span style=\"display:inline-block;width:{0}px;\"></span>{1}{2}"; string LitImg1 = "<span class=\"folder-open\"></span>"; string LitImg2 = "<span class=\"folder-line\"></span>"; LinkButton lb = (LinkButton)e.Item.FindControl("lbedit"); LinkButton lbadd = (LinkButton)e.Item.FindControl("lbadd"); Cms.BLL.C_Column cm = new Cms.BLL.C_Column(); string classname = cm.GetModel(27).className; bool blEdit = adminUser.setpurview(classname, "Edit"); bool bladd = adminUser.setpurview(classname, "Edit"); if (!bladd) { lbadd.Visible = false; } if (!blEdit) { lb.Visible = false; } int classLayer = Convert.ToInt32(hidLayer.Value); if (classLayer == 1) { LitFirst.Text = LitImg1; } else { LitFirst.Text = string.Format(LitStyle, (classLayer - 2) * 24, LitImg2, LitImg1); } } }
private void NavBind() { Cms.BLL.C_Column bll = new Cms.BLL.C_Column(); DataTable ds = bll.GetList(0); this.rptList.DataSource = ds; this.rptList.DataBind(); }
public static void RepeaterCloumn(int id, Repeater rep) { DataSet dt = new Cms.BLL.C_Column().GetList("parentId=" + id + " and isShowChannel=1 order by orderNumber desc");//导航 if (dt != null && dt.Tables[0].Rows.Count > 0) { rep.DataSource = dt.Tables[0].DefaultView; rep.DataBind(); } }
public static void RepeaterArticleWhere(int top, int classId, string where, Repeater rep) { string workname = new Cms.BLL.C_Column().GetModel(classId).name.ToString(); DataSet ds = Cms.DBUtility.DbHelperSQL.Query("SELECT * FROM ( SELECT ROW_NUMBER() OVER (order by T.orderNumber desc,T.articleId desc )AS Row, T.* from view_channel_" + workname + " T WHERE parentId=" + classId + where + " ) TT WHERE TT.Row between 0 and " + top); if (ds != null && ds.Tables[0].Rows.Count > 0) { rep.DataSource = ds.Tables[0].DefaultView; rep.DataBind(); } }
public static string getWapContentUrl(int id, int articleId) { string result = ""; Cms.Model.C_Column model = new Cms.BLL.C_Column().GetModel(id); if (model != null) { result = "/m/" + model.tplContent + ".aspx?classId=" + id + "&articleId=" + articleId; } return(result); }
public static string getCloumnPicurl(int id) { string result = ""; Cms.BLL.C_Column bllColumn = new Cms.BLL.C_Column(); DataSet ds = bllColumn.GetList("classId=" + id); if (ds != null && ds.Tables[0].Rows.Count > 0) { result = ds.Tables[0].Rows[0]["photoUrl"].ToString(); } return(result); }
public static string crumb(int classId) { string result = "<li class='house'> <a href='/'>首页</a> ></li> {parent} <li class='shicol'> <a href='{linkUrl}'>{className}</a></li>"; Cms.Model.C_Column model = new Cms.BLL.C_Column().GetModel(classId); if (model != null) { result = result.Replace("{linkUrl}", ToAspx.getCloumnUrl(model.classId)); result = result.Replace("{className}", model.className); result = result.Replace("{parent}", InitChildCrumb(Convert.ToInt32(model.parentId))); } return(result); }
public static string getCloumnIntro(int id) { string result = ""; Cms.BLL.C_Column bllColumn = new Cms.BLL.C_Column(); DataSet ds = bllColumn.GetList("classId=" + id); if (ds != null && ds.Tables[0].Rows.Count > 0) { result = GetToHtml(ds.Tables[0].Rows[0]["intro"].ToString()); } return(result); }
public void bind_RepeaterNav() { Cms.BLL.C_Column bllColumn = new Cms.BLL.C_Column(); DataSet ds = bllColumn.GetList("parentId=0 and nav_type='system' and isHidden=0 order by ordernumber desc"); string strNav = ""; string role_id = ""; string role_type = ""; HttpCookie cookie = System.Web.HttpContext.Current.Request.Cookies["admin"]; if (cookie != null) { role_id = (string)cookie.Values["adminid"]; role_type = (string)cookie.Values["adminType"]; } else if (Session["adminid"] != null) { role_id = (string)Session["adminid"]; role_type = (string)Session["adminType"]; } Cms.BLL.C_admin_role_value bllrole_value = new Cms.BLL.C_admin_role_value(); if (ds != null && ds.Tables[0].Rows.Count > 0) { StringBuilder sbuBuilder = new StringBuilder(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataSet ds1 = null; if (role_type == "1") { ds1 = ds; } else { ds1 = bllrole_value.GetList("nav_name='" + ds.Tables[0].Rows[i]["className"].ToString() + "' and role_id=" + Convert.ToInt32(role_id)); } if (ds1 != null && ds1.Tables[0].Rows.Count > 0) { sbuBuilder.Append("<li><a href='index.aspx?id=" + ds.Tables[0].Rows[i]["classId"].ToString() + "'><i class='icon-" + i + "'></i><span>" + ds.Tables[0].Rows[i]["className"].ToString() + "</span></a></li>"); } else { continue; } } strNav = sbuBuilder.ToString(); } Application["strNav"] = strNav; }
private string InitChild(DataRow dr, string strchar, int n) { Cms.BLL.C_Column bllcolumn = new Cms.BLL.C_Column(); Cms.Model.C_Column modelcolumn = new Cms.Model.C_Column(); DataSet dtt = bllcolumn.GetList("parentId=" + dr["classid"] + "order by orderNumber desc"); dtt.Tables[0].Columns.Add("Operate", typeof(string)); dtt.Tables[0].Columns.Add("Colum", typeof(String)); if (dtt.Tables[0].Rows.Count > 0) { string s = " "; for (int j = 1; j <= n; j++) { s += " "; } for (int k = 0; k < dtt.Tables[0].Rows.Count; k++) { DataRow dro = dtt.Tables[0].Rows[k]; string flag = "├"; if (dtt.Tables[0].Rows.Count == 1) { flag = "├"; } else { if (k == 0) { flag = "├"; } if (k == dtt.Tables[0].Rows.Count - 1) { flag = "├"; } } dro["operate"] = "<a href='Column_edit.aspx?action=add&classid=" + dro["classid"].ToString() + "&parentId=" + dro["parentId"].ToString() + "'>[添加下级]</a> <a href='Column_edit.aspx?action=edit&classid=" + dro["classid"].ToString() + "&parentId=" + dro["parentId"].ToString() + "'>[编辑]</a> <a href='Column_list.aspx?action=del&classid=" + dro["classid"].ToString() + "&classname=" + dro["className"].ToString() + " ' onclick='return confirm(\"真的要删除?栏目删除之后,该栏目下的新闻也将删除,不可恢复!\");'>[删除]</a>"; strchar += "<tr onmouseover=this.bgColor='#EBFFDC'; onmouseout=this.bgColor='#ffffff'; bgcolor='#ffffff'>"; strchar += "<td align=\"center\"><input type='checkbox'/></td> "; strchar += "<td align=\"left\">" + dro["classid"].ToString() + "</td> "; strchar += "<td align=\"left\" >" + s + flag + dro["className"].ToString() + "</td>"; strchar += "<td align=\"center\" >" + GetClassisShowChannel(dro["isShowChannel"].ToString()) + "</td>"; strchar += "<td align=\"center\" >" + GetClassAttrbute(dro["modelId"].ToString()) + "</td>"; strchar += "<td align=\"left\" >" + dro["orderNumber"].ToString() + "</td>"; strchar += "<td align=\"center\" >" + dro["Operate"].ToString() + "</td>"; strchar += "</tr>"; strchar = InitChild(dro, strchar, n + 8); } } return(strchar); }
public static string getContentUrlsub(int id) { string result = ""; Cms.BLL.C_Column bllColumn = new Cms.BLL.C_Column(); Cms.BLL.C_article bllarticle = new Cms.BLL.C_article(); int parentid = Convert.ToInt32(bllarticle.GetModel(id).parentId); DataSet ds = bllColumn.GetList("classId=" + parentid); if (ds != null && ds.Tables[0].Rows.Count > 0) { result = GetToHtml(ds.Tables[0].Rows[0]["contentUrl"].ToString()); } return(result); }
public static Cms.Model.C_Column getCloumnName(int id) { Cms.Model.C_Column result; Cms.Model.C_Column model = new Cms.BLL.C_Column().GetModel(id); if (model.parentId == 26) { result = model; } else { Cms.Model.C_Column modelParent = new Cms.BLL.C_Column().GetModel(Convert.ToInt32(model.parentId)); result = modelParent; } return(result); }
public void getcolumn() { Cms.BLL.C_Column bll = new Cms.BLL.C_Column(); DataTable dt = bll.GetList(26, Cms.Common.Enums.NavigationEnum.WebSite.ToString()); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { ListItem myitem = new ListItem(); myitem.Value = dt.Rows[i]["classId"].ToString(); myitem.Text = dt.Rows[i]["className"].ToString(); cblItem.Items.Add(myitem); } } }
private static int getParentId(int classId) { int result = 26; Cms.Model.C_Column model = new Cms.BLL.C_Column().GetModel(classId); if (model.class_layer == 2) { result = model.classId; } else { result = getParentId(Convert.ToInt32(model.parentId)); } return(result); }
protected void btnDelete_Click(object sender, EventArgs e) { Cms.BLL.C_Column bll = new Cms.BLL.C_Column(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { adminUser.AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), bll.GetModel(id).className); //记录日志 bll.Delete(id); } } JscriptMsg("删除数据成功!", "channel_list.aspx", "Success"); }
/// <summary> /// 权限控制编辑 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void rptList_ItemDataBound(object sender, RepeaterItemEventArgs e) { LinkButton lbedit = e.Item.FindControl("lbedit") as LinkButton; Cms.BLL.C_Column cm = new Cms.BLL.C_Column(); string classname = cm.GetModel(84).className; bool blEdit = adminUser.setpurview(classname, "Edit"); if (!blEdit) { lbedit.Visible = false; } }
protected void btnSave_Click(object sender, EventArgs e) { Cms.BLL.C_Column bll = new Cms.BLL.C_Column(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); int sortId; if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("ordernumber")).Text.Trim(), out sortId)) { sortId = 99; } int counts = Cms.DBUtility.DbHelperSQL.ExecuteSql("update C_car_type set sort_id=" + sortId + " where id='" + id + "'");//修改 } JscriptMsg("保存排序成功!", "list.aspx", "Success"); }
//美化列表 protected void rptList_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item) { Literal LitFirst = (Literal)e.Item.FindControl("LitFirst"); LinkButton lb = (LinkButton)e.Item.FindControl("lbedit"); Cms.BLL.C_Column cm = new Cms.BLL.C_Column(); string classname = cm.GetModel(27).className; bool blEdit = adminUser.setpurview(classname, "Edit"); if (!blEdit) { lb.Visible = false; } } }
private string InitChild(DataRow dr, string strchar, int n) { Cms.BLL.C_Column bllcolumn = new Cms.BLL.C_Column(); Cms.Model.C_Column modelcolumn = new Cms.Model.C_Column(); DataSet dtt = bllcolumn.GetList("parentId=" + dr["classid"] + ""); dtt.Tables[0].Columns.Add("Operate", typeof(string)); dtt.Tables[0].Columns.Add("Colum", typeof(String)); if (dtt.Tables[0].Rows.Count > 0) { string s = " "; for (int j = 1; j <= n; j++) { s += " "; } for (int k = 0; k < dtt.Tables[0].Rows.Count; k++) { DataRow dro = dtt.Tables[0].Rows[k]; string flag = "├"; if (dtt.Tables[0].Rows.Count == 1) { flag = "├"; } else { if (k == 0) { flag = "├"; } if (k == dtt.Tables[0].Rows.Count - 1) { flag = "├"; } } strchar += "<td style='white-space:nowrap;word-break:break-all;overflow:hidden;' >"; strchar += "<input id='rptList_ctl00_hidName' type='hidden' name='rptList$ctl00$hidName' Value='" + dro["className"].ToString() + "' runat='server' />"; strchar += "<input id=='rptList_ctl00_hidActionType' type='hidden' name='rptList$ctl00$hidActionType' Value='" + dro["action_type"].ToString() + "' runat='server' />"; strchar += "<input id='rptList_ctl00_hidLayer' type='hidden' name='rptList$ctl00$hidLayer' Value='" + dro["class_layer"].ToString() + "' runat='server' />"; strchar += "<span class='folder-open'></span>"; strchar += dro["className"].ToString(); strchar += "</td>"; strchar = InitChild(dro, strchar, n + 8); } } return(strchar); }
public void getProxy() { string tearname = new Cms.BLL.C_Column().GetModel(103).name.ToString(); DataSet ds = Cms.DBUtility.DbHelperSQL.Query("SELECT * FROM ( SELECT ROW_NUMBER() OVER (order by T.orderNumber desc, T.articleId desc )AS Row, T.* from C_article T WHERE parentId in (97,117,118,119,120,121) ) TT WHERE TT.Row between 0 and 3 order by orderNumber desc,articleId desc"); if (ds != null && ds.Tables[0].Rows.Count > 0) { string strJson = ConvertJson.ToJson(ds); Response.Write(strJson); Response.End(); } else { Response.Write(""); Response.End(); } }