protected void btnexecl_Click(object sender, System.EventArgs e)
{
System.Data.DataTable dataTable = new System.Data.DataTable();
new System.Text.StringBuilder();
dataTable = PMAction.GetPrjInfo(this.txtPrjCode.Text.Trim(), this.txtprjName.Text.Trim(), "", "", this.txtStartDate.Text.Trim(), this.txtEndDate.Text.Trim(), base.UserCode, 0, 0);
System.Data.DataTable dataTable2 = new System.Data.DataTable();
dataTable2.Columns.Add(new System.Data.DataColumn("序号", typeof(string)));
dataTable2.Columns.Add(new System.Data.DataColumn("项目编号", typeof(string)));
dataTable2.Columns.Add(new System.Data.DataColumn("项目名称", typeof(string)));
dataTable2.Columns.Add(new System.Data.DataColumn("建设单位", typeof(string)));
dataTable2.Columns.Add(new System.Data.DataColumn("工程造价", typeof(string)));
dataTable2.Columns.Add(new System.Data.DataColumn("项目地点", typeof(string)));
dataTable2.Columns.Add(new System.Data.DataColumn("开始时间", typeof(string)));
dataTable2.Columns.Add(new System.Data.DataColumn("结束时间", typeof(string)));
dataTable2.Columns.Add(new System.Data.DataColumn("项目状态", typeof(string)));
foreach (System.Data.DataRow dataRow in dataTable.Rows)
{
System.Data.DataRow dataRow2 = dataTable2.NewRow();
dataRow2["序号"] = dataRow["TypeCode"].ToString();
dataRow2["项目编号"] = dataRow["PrjCode"].ToString();
dataRow2["项目名称"] = dataRow["PrjName"].ToString();
dataRow2["建设单位"] = dataRow["Owner"].ToString();
dataRow2["工程造价"] = dataRow["PrjCost"].ToString();
dataRow2["项目地点"] = dataRow["PrjPlace"].ToString();
dataRow2["开始时间"] = dataRow["StartDate"].ToString();
dataRow2["结束时间"] = dataRow["EndDate"].ToString();
string value = string.Empty;
if (dataRow["PrjState"].ToString() == "-1")
{
value = "在建";
}
if (dataRow["PrjState"].ToString() == "4")
{
value = "在建";
}
if (dataRow["PrjState"].ToString() == "6")
{
value = "停工";
}
if (dataRow["PrjState"].ToString() == "7")
{
value = "竣工";
}
if (dataRow["PrjState"].ToString() == "8")
{
value = "验收";
}
if (dataRow["PrjState"].ToString() == "9")
{
value = "维保";
}
if (dataRow["PrjState"].ToString() == "0")
{
value = "";
}
dataRow2["项目状态"] = value;
dataTable2.Rows.Add(dataRow2);
}
new Common2().ExportToExecelAll(dataTable2, "项目信息.xls", base.Request.Browser.Browser);
}
public void DG1_BIND()
{
System.Data.DataTable dataSource = new System.Data.DataTable();
this.AspNetPager1.RecordCount = PMAction.GetPrjCount(this.txtPrjCode.Text.Trim(), this.txtprjName.Text.Trim(), "", "", this.txtStartDate.Text.Trim(), this.txtEndDate.Text.Trim(), base.UserCode);
dataSource = PMAction.GetPrjInfo(this.txtPrjCode.Text.Trim(), this.txtprjName.Text.Trim(), "", "", this.txtStartDate.Text.Trim(), this.txtEndDate.Text.Trim(), base.UserCode, this.AspNetPager1.PageSize, this.AspNetPager1.CurrentPageIndex);
this.gvPrjInfo.DataSource = dataSource;
this.gvPrjInfo.DataBind();
}
public void ShowTaskList()
{
System.Data.DataTable dataSource = new System.Data.DataTable();
this.AspNetPager1.RecordCount = PMAction.GetPrjCount(this.txtPrjCode.Text.Trim(), this.txtprjName.Text.Trim(), this.txtOwner.Text.Trim(), this.txtPrjPlace.Text.Trim(), "", "", base.UserCode);
dataSource = PMAction.GetPrjInfo(this.txtPrjCode.Text.Trim(), this.txtprjName.Text.Trim(), this.txtOwner.Text.Trim(), this.txtPrjPlace.Text.Trim(), "", "", base.UserCode, this.AspNetPager1.PageSize, this.AspNetPager1.CurrentPageIndex);
this.gvPrjInfo.DataSource = dataSource;
this.gvPrjInfo.DataBind();
}