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