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