protected void Page_Load(object sender, EventArgs e) { if (Request["p"] != null) pageIndex = Convert.ToInt32(Request["p"]); else pageIndex = 1; //根据categoryid,分类显示列表 if (Request["PlanClassifyID"] != null)//&& Request["month"] == "") { condition = "StationPlan.IsDelete = 0 and PlanClassifyID = " + Convert.ToInt32(Request["PlanClassifyID"]); } else { condition = "StationPlan.IsDelete = 0"; } DataPager p = new ExclusiveDataPager(); result = p.PageData(pageIndex, pageSize, "StationPlan", "*", "StationPlanID", condition, "desc"); GridView1.DataSource = result.Result; GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Request["p"] != null) pageIndex = Convert.ToInt32(Request["p"]); else pageIndex = 1; //根据categoryid,分类显示列表 if (Request["categoryid"] != null)//&& Request["month"] == "") { condition = "NewsCategoryID = " + Convert.ToInt32(Request["categoryid"]); } // 根据年份与月份显示 if (Request["NewsYear"] != null && Request["month"] == "") { condition = "NewsYear = " + Convert.ToInt32(Request["NewsYear"]); } if (Request["NewsYear"] != null && Request["month"] != "") { condition = "NewsYear = " + Convert.ToInt32(Request["NewsYear"]) + "And NewsMonth= " + Convert.ToInt32(Request["month"]); } DataPager p = new ExclusiveDataPager(); result = p.PageData(pageIndex, pageSize, "News", "*", "NewsID", condition, "desc"); GridView1.DataSource = result.Result; GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { // FAQList.DataSource = FAQ.GetQuestionCategory(false, Cache); // FAQList.DataBind(); if (Request["p"] != null) { pageIndex = Convert.ToInt32(Request["p"]); } else { pageIndex = 1; } if (Request["OilProjectDirectionID"] != null) { condition = "OilProject.IsDelete = 0 and OilProject.Confirm = True and OilProject.OilProjectDirectionID = OilProjectDirection.OilProjectDirectionID and OilProjectDirection.OilProjectDirectionID=" + Convert.ToInt32(Request["OilProjectDirectionID"]); } else { condition = "OilProject.IsDelete = 0 and OilProject.Confirm = True and OilProject.OilProjectDirectionID = OilProjectDirection.OilProjectDirectionID "; } DataPager p = new ExclusiveDataPager(); result_direction = p.PageData(1, 100, "OilProjectDirection", "*", "OilProjectDirectionID", condition_direction, null); result1 = p.PageData(pageIndex, pageSize, "OilProject,OilProjectDirection", "*", "OilProjectID", condition, "desc"); ProjectList.DataSource = result_direction.Result; ProjectList.DataBind(); GridView1.DataSource = result1.Result; GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { XmlDocument document = new XmlDocument(); document.Load(Server.MapPath("~/Footer.xml")); // picture = ResolveUrl(document.DocumentElement.SelectSingleNode("picture").InnerText); if (Request["newsId"] != null) { newsFrame = "NewsContent.aspx?newsid=" + Request["newsId"]; } else { newsFrame = "NewsTempate.aspx"; } //新闻列表更新 if (Request["p"] != null) pageIndex = Convert.ToInt32(Request["p"]); else pageIndex = 1; //根据categoryid,分类显示列表 if (Request["categoryid"] != null)//&& Request["month"] == "") { condition += " and NewsCategoryID = " + Convert.ToInt32(Request["categoryid"]); } // 根据年份与月份显示 if (Request["NewsYear"] != null && Request["month"] == "") { condition += " and NewsYear = " + Convert.ToInt32(Request["NewsYear"]); } if (Request["NewsYear"] != null && Request["month"] != "") { condition += " and NewsYear = " + Convert.ToInt32(Request["NewsYear"]) + "And NewsMonth= " + Convert.ToInt32(Request["month"]); } DataPager p = new ExclusiveDataPager(); result = p.PageData(pageIndex, pageSize, "News", "*", "NewsID", condition, "desc"); GridView1.DataSource = result.Result; GridView1.DataBind(); }
void bindData() { //if (Request["p"] != null) // pageIndex = Convert.ToInt32(Request["p"]); //else // pageIndex = 1; DataPager p = new ExclusiveDataPager(); //result = p.PageData(pageIndex, pageSize, "OilProject INNER JOIN UPR ON OilProject.OilProjectTitle = UPR.ProjectName", "*", "OilProjectID", ("UPR.UserName='******'"), "asc"); string dsStr = "select top 10 * from OilProject INNER JOIN UPR ON OilProject.OilProjectTitle = UPR.ProjectName where (OilProject.OilProjectID="+pid+" and IsDelete=0) order by OilProjectID asc"; //"select * from OilProject where IsDelete=" + 0; DataSet ds = DBHelper.INST.ExecuteSqlDS(dsStr); GridView1.DataSource = ds;//result1.Result; GridView1.DataBind(); ds.Dispose(); string pcStr = "select OilProjectContent from OilProject INNER JOIN UPR ON OilProject.OilProjectTitle = UPR.ProjectName where (OilProject.OilProjectID=" + pid + ")"; DataSet pcDS = DBHelper.INST.ExecuteSqlDS(pcStr); lb.Text= pcDS.Tables[0].Rows[0][0].ToString(); pcDS.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { // FAQList.DataSource = FAQ.GetQuestionCategory(false, Cache); // FAQList.DataBind(); if (Request["p"] != null) { pageIndex = Convert.ToInt32(Request["p"]); i = (Convert.ToInt32(Request["p"]) - 1) * 7 + 1; } else { pageIndex = 1; i = 1; } DataPager p = new ExclusiveDataPager(); result = p.PageData(pageIndex, pageSize, "FAQ", "*", "FAQID", condition, "desc"); FAQList.DataSource = result.Result; FAQList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { // XmlDocument document = new XmlDocument(); // document.Load(Server.MapPath("~/Footer.xml")); // picture = ResolveUrl(document.DocumentElement.SelectSingleNode("picture").InnerText); if (Request["p"] != null) { pageIndex = Convert.ToInt32(Request["p"]); } else { pageIndex = 1; } if (Request["NewRecruitsCategoryID"] != null) { condition = "NewRecruits.IsDelete = 0 and NewRecruits.NewRecruitsCategoryID = NewRecruitsCategory.NewRecruitsCategoryID and NewRecruits.OilProjectDirectionID = OilProjectDirection.OilProjectDirectionID and NewRecruitsCategory.NewRecruitsCategoryID=" + Convert.ToInt32(Request["NewRecruitsCategoryID"]); } else if (Request["OilProjectDirectionID"] != null) { condition = "NewRecruits.IsDelete = 0 and NewRecruits.NewRecruitsCategoryID = NewRecruitsCategory.NewRecruitsCategoryID and NewRecruits.OilProjectDirectionID = OilProjectDirection.OilProjectDirectionID and NewRecruits.OilProjectDirectionID=" + Convert.ToInt32(Request["OilProjectDirectionID"]); }else { condition = "NewRecruits.IsDelete = 0 and NewRecruits.NewRecruitsCategoryID = NewRecruitsCategory.NewRecruitsCategoryID and NewRecruits.OilProjectDirectionID = OilProjectDirection.OilProjectDirectionID"; } DataPager p = new ExclusiveDataPager(); result_category = p.PageData(1, 100, "NewRecruitsCategory", "*", "NewRecruitsCategoryID", condition_category, "asc"); // result_direction = p.PageData(1, 10, "OilProjectDirectionTitle", "*", "OilProjectDirectionID", condition_direction, "asc"); result1 = p.PageData(pageIndex, pageSize, "NewRecruits,NewRecruitsCategory,OilProjectDirection", "*", "NewRecruitsID", condition, "asc"); NewRecruitsList.DataSource = result_category.Result; // OilProjectList.DataSource = result_direction.Result; NewRecruitsList.DataBind(); // OilProjectList.DataBind(); GridView1.DataSource = result1.Result; GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { // FAQList.DataSource = FAQ.GetQuestionCategory(false, Cache); // FAQList.DataBind(); if (Request["p"] != null) { pageIndex = Convert.ToInt32(Request["p"]); } else { pageIndex = 1; } if (Request["ProjectID"] != null)//&& Request["month"] == "") { condition = "ProjectID = " + Convert.ToInt32(Request["ProjectID"]); } DataPager p = new ExclusiveDataPager(); result = p.PageData(pageIndex, pageSize, "NewRecruits", "*", "NewRecruitsID", condition, "desc"); NewRecruitsList.DataSource = result.Result; NewRecruitsList.DataBind(); }
void bindData() { if (Request["p"] != null) pageIndex = Convert.ToInt32(Request["p"]); else pageIndex = 1; DataPager p = new ExclusiveDataPager(); result = p.PageData(pageIndex, pageSize, "FAQ", "*", "FAQID", null, "desc"); GridView1.DataSource = result.Result; GridView1.DataKeyNames = new string[] { "FAQID" }; GridView1.DataBind(); }
void bindData() { if (Request["p"] != null) pageIndex = Convert.ToInt32(Request["p"]); else pageIndex = 1; DataPager p = new ExclusiveDataPager(); result = p.PageData(pageIndex, pageSize, "CooperationEnterprises", "*", "EnterprisesID", null, "asc"); string dsStr = "select * from CooperationEnterprises where IsDelete=" + 0; DataSet ds = DBHelper.INST.ExecuteSqlDS(dsStr); GridView1.DataSource = ds;//result1.Result; GridView1.DataBind(); ds.Dispose(); /* GridView1.DataSource = result.Result; GridView1.DataKeyNames = new string[] { "EnterprisesID" }; GridView1.DataBind(); */ }
void bindData() { InitPage(); DataPager p = new ExclusiveDataPager(); //result1 = p.PageData(pageIndex, pageSize, "NewRecruits", "distinct ProjectName", "OilProjectDirectionID", condition, "asc"); string dsStr = "select * from OilProjectDirection where IsDelete=" + 0; DataSet ds = DBHelper.INST.ExecuteSqlDS(dsStr); GridView1.DataSource = ds;//result1.Result; GridView1.DataBind(); ds.Dispose(); }
void bindData() { InitPage(); if (Request["p"] != null) pageIndex = Convert.ToInt32(Request["p"]); else pageIndex = 1; DataPager p = new ExclusiveDataPager(); result = p.PageData(pageIndex, pageSize, "StationPlan", "*", "StationPlanID", null, "asc"); string dsStr = "select * from StationPlan where IsDelete=" + 0; DataSet ds = DBHelper.INST.ExecuteSqlDS(dsStr); GridView1.DataSource = ds;//result1.Result; GridView1.DataBind(); ds.Dispose(); }
void bindData() { InitPage(); if (Request["p"] != null) pageIndex = Convert.ToInt32(Request["p"]); else pageIndex = 1; DataPager p = new ExclusiveDataPager(); HttpContext context = HttpContext.Current; //result = p.PageData(pageIndex, pageSize, "OilProject INNER JOIN UPR ON OilProject.OilProjectTitle = UPR.ProjectName", "*", "OilProjectID", ("UPR.UserName='******'"), "asc"); Users u = Users.load(context.User.Identity.Name); string dsStr = "select top 10 * from OilProject INNER JOIN UPR ON OilProject.OilProjectTitle = UPR.ProjectName where (UPR.UserName='******' and IsDelete=0) order by OilProjectID asc"; //"select * from OilProject where IsDelete=" + 0; DataSet ds = DBHelper.INST.ExecuteSqlDS(dsStr); GridView1.DataSource = ds;//result1.Result; GridView1.DataBind(); ds.Dispose(); }
void bindData() { InitPage(); if (Request["p"] != null) pageIndex = Convert.ToInt32(Request["p"]); else pageIndex = 1; DataPager p = new ExclusiveDataPager(); string dsStr = "select * from NewRecruitsCategory where IsDelete=0 "; DataSet ds = DBHelper.INST.ExecuteSqlDS(dsStr); GridView1.DataSource = ds;//result1.Result; GridView1.DataBind(); ds.Dispose(); }
public static PageResult PageData(int pageIndex, int pageSize, string table) { DataPager impl = new ExclusiveDataPager(); return impl.PageData(pageIndex, pageSize, table, "*", table + "ID", null, "desc"); }
void bindData() { //if (Request["p"] != null) // pageIndex = Convert.ToInt32(Request["p"]); //else // pageIndex = 1; DataPager p = new ExclusiveDataPager(); //result = p.PageData(pageIndex, pageSize, "OilProject INNER JOIN UPR ON OilProject.OilProjectTitle = UPR.ProjectName", "*", "OilProjectID", ("UPR.UserName='******'"), "asc"); string dsStr = "select top 10 * from OilProject INNER JOIN UPR ON OilProject.OilProjectTitle = UPR.ProjectName where (OilProject.OilProjectID="+pid+" and IsDelete=0) order by OilProjectID asc"; //"select * from OilProject where IsDelete=" + 0; DataSet ds = DBHelper.INST.ExecuteSqlDS(dsStr); GridView1.DataSource = ds;//result1.Result; GridView1.DataBind(); string str = "select top 6 UserName +' '+ '(' + LoginName +')' as clUser from Users ";////////////////////////////////////////////// //DataTable d2 = dbObj.GetDataSet(dbObj.GetCommandStr(str), "Users"); DataSet d2 = DBHelper.INST.ExecuteSqlDS(str); this.clistUser.DataSource = d2; this.clistUser.DataTextField = "clUser"; this.clistUser.DataBind(); ds.Dispose(); d2.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataPager p = new ExclusiveDataPager(); String condition = "IsDelete = 0"; News.DataSource = (p.PageData(1, 5, "News", "*", "NewsID", condition, "desc")).Result; News.DataBind(); DataPager pp = new ExclusiveDataPager(); Plans.DataSource = (pp.PageData(1, 5, "StationPlan", "*", "StationPlanID", condition, "desc")).Result; Plans.DataBind(); DataPager ppp = new ExclusiveDataPager(); string project_condition = "IsDelete = 0 and Confirm = True"; OilProject.DataSource = (ppp.PageData(1, 5, "OilProject", "*", "OilProjectID", project_condition, "desc")).Result; OilProject.DataBind(); } XmlDocument document = new XmlDocument(); document.Load(Server.MapPath("~/Footer.xml")); XmlNode titleNode1 = document.DocumentElement.SelectSingleNode("pictures").SelectSingleNode("//picture[@id='1']").SelectSingleNode("item"); picture[0] = ResolveUrl(titleNode1.InnerText); pictureUrl[0] = ResolveUrl(titleNode1.Attributes["url"].Value); for (int i = 1; i <= 2; i++) { titleNode1 = titleNode1.NextSibling; picture[i] = ResolveUrl(titleNode1.InnerText); pictureUrl[i] = ResolveUrl(titleNode1.Attributes["url"].Value); } XmlNode titleNode2 = document.DocumentElement.SelectSingleNode("pictures").SelectSingleNode("//picture[@id='2']").SelectSingleNode("item"); picture1[0] =ResolveUrl( titleNode2.InnerText); pictureUrl1[0] = ResolveUrl(titleNode2.Attributes["url"].Value); for (int j = 1; j <= 2; j++) { titleNode2 = titleNode2.NextSibling; picture1[j] = ResolveUrl(titleNode2.InnerText); pictureUrl1[j] = ResolveUrl(titleNode2.Attributes["url"].Value); } XmlNode titleNode3 = document.DocumentElement.SelectSingleNode("buttons").SelectSingleNode("//buttonImage[@id='1']").SelectSingleNode("item"); buttonImage[0] = ResolveUrl(titleNode3.InnerText); buttonImageUrl[0] = ResolveUrl(titleNode3.Attributes["url"].Value); for (int i = 1; i <= 12; i++) { titleNode3 = titleNode3.NextSibling; buttonImage[i] = ResolveUrl(titleNode3.InnerText); buttonImageUrl[i] = ResolveUrl(titleNode3.Attributes["url"].Value); } /* * 从XML文件中载入主页中间的标题与链接 */ XmlNode titleNode = document.DocumentElement.SelectSingleNode("footer"); titleName[0] = titleNode.SelectSingleNode("//catalogue[@id='2']").Attributes["value"].Value; titleUrl[0] = ResolveUrl(titleNode.SelectSingleNode("//catalogue[@id='2']").Attributes["url"].Value); titleName[1] = titleNode.SelectSingleNode("//catalogue[@id='4']").Attributes["value"].Value; titleUrl[1] = ResolveUrl(titleNode.SelectSingleNode("//catalogue[@id='4']").Attributes["url"].Value); titleName[2] = titleNode.SelectSingleNode("//catalogue[@id='3']").Attributes["value"].Value; titleUrl[2] = ResolveUrl(titleNode.SelectSingleNode("//catalogue[@id='3']").Attributes["url"].Value); }