protected void btnExcel_Click(object sender, System.EventArgs e)
{
System.Collections.Generic.List <int> prjState = this.GetPrjState();
DataTable all = TenderInfo.GetAll(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtName.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, null, base.UserCode, this.hfldTenderPrjManager.Value, false, 3, this.AspNetPager1.CurrentPageIndex, 2147483647, "", "BidFlowState");
System.Collections.Generic.List <string> list = new System.Collections.Generic.List <string>();
foreach (DataControlField dataControlField in this.gvwProject.Columns)
{
string headerText = dataControlField.HeaderText;
if (headerText != "")
{
list.Add(headerText);
}
}
string[] source = new string[]
{
"No",
"StateText",
"Person",
"PrjCode",
"PrjName",
"WorkUnitName",
"PrjCost",
"Duration",
"InputDate"
};
string[] totalField = new string[]
{
"PrjCost"
};
ExcelHelper.ExportExcel(all, list.ToArray(), source.ToArray <string>(), totalField, base.Title.Trim() + ".xls", base.Request.Browser.Browser);
}
private void bindGv()
{
System.Collections.Generic.List <int> prjState = this.GetPrjState();
int count = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtName.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, null, base.UserCode, this.txtTenderPrjManager.Text, 3, "", "BidFlowState");
this.AspNetPager1.RecordCount = count;
this.gvwProject.DataSource = TenderInfo.GetAll(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtName.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, null, base.UserCode, this.txtTenderPrjManager.Text, false, 3, this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageSize, "", "BidFlowState");
this.gvwProject.DataBind();
}
protected void bindGv()
{
System.Collections.Generic.List <int> prjState = new System.Collections.Generic.List <int>
{
18
};
System.Collections.Generic.List <int> flowState = new System.Collections.Generic.List <int>(1);
string text = this.txtName.Text;
int count = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, flowState, base.UserCode, text, 4, null, "GiveUpFlowState");
this.AspNetPager1.RecordCount = count;
this.AspNetPager1.PageSize = NBasePage.pagesize;
DataTable all = TenderInfo.GetAll(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, flowState, base.UserCode, text, false, 4, this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageSize, null, "GiveUpFlowState");
this.gvDataInfo.DataSource = all;
this.gvDataInfo.DataBind();
}
protected void btnExport_Click(object sender, System.EventArgs e)
{
System.Collections.Generic.List <int> prjState = new System.Collections.Generic.List <int>
{
int.Parse(ProjectParameter.Initiate),
int.Parse(ProjectParameter.GiveUpState)
};
System.Collections.Generic.List <int> flowState = new System.Collections.Generic.List <int>
{
1
};
DataTable all = TenderInfo.GetAll(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, flowState, base.UserCode, this.txtName.Text, false, 4, this.AspNetPager1.CurrentPageIndex, 2147483647, ProjectParameter.Approval, null);
string[] headerName = new string[]
{
"序号",
"项目状态",
"项目跟踪人",
"项目编号",
"项目名称",
"建设单位",
"项目类型",
"工程造价",
"工程工期",
"立项申请日期"
};
string[] fieldName = new string[]
{
"",
"StateText",
"Person",
"PrjCode",
"PrjName",
"WorkUnitName",
"PrjTypeName",
"PrjCost",
"Duration",
"InputDate"
};
string[] totalField = new string[]
{
"PrjCost"
};
ExcelHelper.ExportExcel(all, headerName, fieldName, totalField, "报名项目一览.xls", base.Request.Browser.Browser);
}
protected void bindGv()
{
System.Collections.Generic.List <int> list = new System.Collections.Generic.List <int>
{
2,
3,
18,
19
};
if (this.dropPrjState.SelectedValue != "")
{
list.Clear();
list.Add(int.Parse(this.dropPrjState.SelectedValue));
}
System.Collections.Generic.List <int> flowState = new System.Collections.Generic.List <int>(1);
string text = this.txtName.Text;
int count = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, list, flowState, base.UserCode, text, 4, ProjectParameter.Approval, null);
this.AspNetPager1.RecordCount = count;
this.AspNetPager1.PageSize = NBasePage.pagesize;
DataTable all = TenderInfo.GetAll(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, list, flowState, base.UserCode, text, false, 4, this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageSize, ProjectParameter.Approval, null);
this.gvDataInfo.DataSource = all;
this.gvDataInfo.DataBind();
string value = string.Empty;
if (this.dropPrjState.SelectedValue != string.Empty)
{
value = this.dropPrjState.SelectedValue;
}
if (string.IsNullOrEmpty(value))
{
System.Collections.Generic.List <int> prjState = new System.Collections.Generic.List <int>
{
2
};
int count2 = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, flowState, base.UserCode, text, 4, ProjectParameter.Approval, null);
prjState = new System.Collections.Generic.List <int>
{
3
};
int count3 = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, flowState, base.UserCode, text, 4, ProjectParameter.Approval, null);
prjState = new System.Collections.Generic.List <int>
{
19
};
int count4 = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, flowState, base.UserCode, text, 4, ProjectParameter.Approval, null);
prjState = new System.Collections.Generic.List <int>
{
18
};
int count5 = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, flowState, base.UserCode, text, 4, ProjectParameter.Approval, null);
string text2 = "<span style='margin-left:3px;margin-right:3px;'>";
string text3 = "</span>";
this.lblTotal.Text = string.Concat(new object[]
{
"汇总：信息立项",
text2,
count2,
text3,
"项，报名通过",
text2,
count3,
text3,
"项，报名不通过",
text2,
count4,
text3,
"项，放弃",
text2,
count5,
text3,
"项"
});
return;
}
int num = 0;
int num2 = 0;
int num3 = 0;
int num4 = 0;
System.Collections.Generic.List <int> prjState2 = new System.Collections.Generic.List <int>
{
System.Convert.ToInt32(value)
};
int count6 = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState2, flowState, base.UserCode, text, 4, ProjectParameter.Approval, null);
if (System.Convert.ToInt32(value) == 2)
{
num = count6;
}
else
{
if (System.Convert.ToInt32(value) == 3)
{
num2 = count6;
}
else
{
if (System.Convert.ToInt32(value) == 19)
{
num4 = count6;
}
else
{
if (System.Convert.ToInt32(value) == 18)
{
num3 = count6;
}
}
}
}
string text4 = "<span style='margin-left:3px;margin-right:3px;'>";
string text5 = "</span>";
this.lblTotal.Text = string.Concat(new object[]
{
"汇总：信息立项",
text4,
num,
text5,
"项，报名通过",
text4,
num2,
text5,
"项, 报名不通过",
text4,
num4,
text5,
"项，放弃",
text4,
num3,
text5,
"项"
});
}
private void bindGv()
{
System.Collections.Generic.List <int> list = new System.Collections.Generic.List <int>();
if (string.IsNullOrEmpty(this.dropPrjState.SelectedValue))
{
list = new System.Collections.Generic.List <int>
{
int.Parse(ProjectParameter.Initiate),
int.Parse(ProjectParameter.Prequalification),
int.Parse(ProjectParameter.QualificationPass),
int.Parse(ProjectParameter.QualificationFail)
};
}
else
{
list.Add(System.Convert.ToInt32(this.dropPrjState.SelectedValue));
}
System.Collections.Generic.List <int> flowState = new System.Collections.Generic.List <int>
{
1
};
string text = this.txtName.Text;
int count = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, list, flowState, base.UserCode, text, 4, ProjectParameter.Initiate, "InitiateFlowState");
this.AspNetPager1.RecordCount = count;
this.AspNetPager1.PageSize = NBasePage.pagesize;
DataTable all = TenderInfo.GetAll(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, list, flowState, base.UserCode, text, true, 4, this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageSize, ProjectParameter.Initiate, "InitiateFlowState");
this.gvwProject.DataSource = all;
this.gvwProject.DataBind();
int num = 0;
int num2 = 0;
int num3 = 0;
int num4 = 0;
for (int i = 0; i < all.Rows.Count; i++)
{
if (all.Rows[i]["PrjState"].ToString() == ProjectParameter.Prequalification)
{
num++;
}
else
{
if (all.Rows[i]["PrjState"].ToString() == ProjectParameter.QualificationPass)
{
num2++;
}
else
{
if (all.Rows[i]["PrjState"].ToString() == ProjectParameter.QualificationFail)
{
num3++;
}
else
{
if (all.Rows[i]["PrjState"].ToString() == ProjectParameter.GiveUpState)
{
num4++;
}
}
}
}
}
string text2 = "<span style='margin-left:3px;margin-right:3px;'>";
string text3 = "</span>";
this.lblTotal.Text = string.Concat(new object[]
{
"汇总：正在预审",
text2,
num,
text3,
"项，预审通过",
text2,
num2,
text3,
"项，预审失败",
text2,
num3,
text3,
"项，放弃",
text2,
num4,
text3,
"项"
});
}
public DataTable GetReportData()
{
System.Collections.Generic.List <int> list = new System.Collections.Generic.List <int>();
if (string.IsNullOrEmpty(this.dropPrjState.SelectedValue))
{
list = new System.Collections.Generic.List <int>
{
int.Parse(ProjectParameter.Prequalification),
int.Parse(ProjectParameter.QualificationPass),
int.Parse(ProjectParameter.QualificationFail)
};
}
else
{
list.Add(System.Convert.ToInt32(this.dropPrjState.SelectedValue));
}
System.Collections.Generic.List <int> flowState = new System.Collections.Generic.List <int>
{
1
};
DataTable all = TenderInfo.GetAll(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, list, flowState, base.UserCode, this.txtName.Text, true, 4, this.AspNetPager1.CurrentPageIndex, 2147483647, ProjectParameter.Initiate, "InitiateFlowState");
DataTable dataTable = new DataTable();
dataTable.Columns.Add("序号");
dataTable.Columns.Add("项目状态");
dataTable.Columns.Add("项目跟踪人");
dataTable.Columns.Add("项目编号");
dataTable.Columns.Add("项目名称");
dataTable.Columns.Add("建设单位");
dataTable.Columns.Add("工程造价");
dataTable.Columns.Add("工程工期");
dataTable.Columns.Add("立项申请日期");
if (all.Rows.Count > 0)
{
for (int i = 0; i < all.Rows.Count; i++)
{
DataRow dataRow = dataTable.NewRow();
dataRow["序号"] = (i + 1).ToString();
dataRow["项目状态"] = all.Rows[i]["StateText"].ToString();
dataRow["项目跟踪人"] = all.Rows[i]["Person"].ToString();
dataRow["项目编号"] = all.Rows[i]["PrjCode"].ToString();
dataRow["项目名称"] = all.Rows[i]["PrjName"].ToString();
dataRow["建设单位"] = all.Rows[i]["WorkUnitName"].ToString();
dataRow["工程造价"] = all.Rows[i]["PrjCost"].ToString();
dataRow["工程工期"] = all.Rows[i]["Duration"].ToString();
dataRow["立项申请日期"] = all.Rows[i]["InputDate"].ToString();
dataTable.Rows.Add(dataRow);
}
DataRow dataRow2 = dataTable.NewRow();
dataRow2["序号"] = "合计";
dataRow2["项目状态"] = "";
dataRow2["项目跟踪人"] = "";
dataRow2["项目编号"] = "";
dataRow2["项目名称"] = "";
dataRow2["建设单位"] = "";
dataRow2["工程造价"] = all.Compute("SUM(PrjCost)", string.Empty).ToString();
dataRow2["工程工期"] = "";
dataRow2["立项申请日期"] = "";
dataTable.Rows.Add(dataRow2);
}
return(dataTable);
}
private void bindGv()
{
System.Collections.Generic.List <int> prjState = this.GetPrjState();
int count = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtName.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, null, base.UserCode, this.txtTenderPrjManager.Text, 3, ProjectParameter.QualificationPass, "PftFlowState");
this.AspNetPager1.RecordCount = count;
this.gvwProject.DataSource = TenderInfo.GetAll(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtName.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, null, base.UserCode, this.txtTenderPrjManager.Text, false, 3, this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageSize, ProjectParameter.QualificationPass, "PftFlowState");
this.gvwProject.DataBind();
string value = string.Empty;
if (this.dropPrjState.SelectedValue != string.Empty)
{
value = this.dropPrjState.SelectedValue;
}
if (string.IsNullOrEmpty(value))
{
System.Collections.Generic.List <int> prjState2 = new System.Collections.Generic.List <int>
{
4
};
int count2 = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtName.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState2, null, base.UserCode, this.txtTenderPrjManager.Text, 3, ProjectParameter.QualificationPass, "PftFlowState");
prjState2 = new System.Collections.Generic.List <int>
{
15
};
int count3 = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtName.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState2, null, base.UserCode, this.txtTenderPrjManager.Text, 3, ProjectParameter.QualificationPass, "PftFlowState");
prjState2 = new System.Collections.Generic.List <int>
{
18
};
int count4 = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtName.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState2, null, base.UserCode, this.txtTenderPrjManager.Text, 3, ProjectParameter.QualificationPass, "PftFlowState");
string text = "<span style='margin-left:3px;margin-right:3px;'>";
string text2 = "</span>";
this.lblTotal.Text = string.Concat(new object[]
{
"汇总：投标",
text,
count2,
text2,
"项，预审通过",
text,
count3,
text2,
"项，放弃",
text,
count4,
text2,
"项"
});
return;
}
int num = 0;
int num2 = 0;
int num3 = 0;
System.Collections.Generic.List <int> prjState3 = new System.Collections.Generic.List <int>
{
System.Convert.ToInt32(value)
};
int count5 = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtName.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState3, null, base.UserCode, this.txtTenderPrjManager.Text, 3, ProjectParameter.QualificationPass, "PftFlowState");
if (System.Convert.ToInt32(value) == 4)
{
num = count5;
}
else
{
if (System.Convert.ToInt32(value) == 16)
{
num2 = count5;
}
else
{
if (System.Convert.ToInt32(value) == 18)
{
num3 = count5;
}
}
}
string text3 = "<span style='margin-left:3px;margin-right:3px;'>";
string text4 = "</span>";
this.lblTotal.Text = string.Concat(new object[]
{
"汇总：投标",
text3,
num,
text4,
"项，预审通过",
text3,
num2,
text4,
"项，放弃",
text3,
num3,
text4,
"项"
});
}
private void bindGv()
{
System.Collections.Generic.List <int> prjState = new System.Collections.Generic.List <int>
{
1,
2
};
System.Collections.Generic.List <int> flowState = new System.Collections.Generic.List <int>();
if (this.dropWFState.SelectedValue != "")
{
flowState = new System.Collections.Generic.List <int>
{
int.Parse(this.dropWFState.SelectedValue)
};
}
string text = this.txtName.Text;
int count = TenderInfo.GetCount(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, flowState, base.UserCode, text, 1, null, null);
this.AspNetPager1.RecordCount = count;
this.AspNetPager1.PageSize = NBasePage.pagesize;
DataTable all = TenderInfo.GetAll(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, flowState, base.UserCode, text, true, 1, this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageSize, null, null);
this.gvwProject.DataSource = all;
this.gvwProject.DataBind();
int num = 0;
int num2 = 0;
int num3 = 0;
int num4 = 0;
DataTable flowStateSummarizingInfo = TenderInfo.GetFlowStateSummarizingInfo(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, flowState, base.UserCode, text, null, null);
if (flowStateSummarizingInfo != null && flowStateSummarizingInfo.Rows.Count > 0)
{
DataRow dataRow = flowStateSummarizingInfo.Rows[0];
num = DBHelper.GetInt(dataRow["100"]);
num += DBHelper.GetInt(dataRow["-1"]);
num += DBHelper.GetInt(dataRow["0"]);
num2 = DBHelper.GetInt(dataRow["1"]);
num3 = DBHelper.GetInt(dataRow["-2"]);
num4 = DBHelper.GetInt(dataRow["-3"]);
}
string text2 = "<span style='margin-left:3px;margin-right:3px;'>";
string text3 = "</span>";
this.lblTotal.Text = string.Concat(new object[]
{
"汇总：正在申请",
text2,
num,
text3,
"项，已批准(立项)",
text2,
num2,
text3,
"项，已驳回",
text2,
num3,
text3,
"项，重报",
text2,
num4,
text3,
"项"
});
}
public DataTable GetReportData()
{
System.Collections.Generic.List <int> prjState = new System.Collections.Generic.List <int>
{
1,
2
};
System.Collections.Generic.List <int> flowState = new System.Collections.Generic.List <int>();
if (this.dropWFState.SelectedValue != "")
{
flowState = new System.Collections.Generic.List <int>
{
int.Parse(this.dropWFState.SelectedValue)
};
}
DataTable all = TenderInfo.GetAll(this.txtPrjName.Text, this.txtPrjCode.Text, this.txtOwner.Text, this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text, this.txtEndTime.Text, prjState, flowState, base.UserCode, this.txtName.Text, true, 1, this.AspNetPager1.CurrentPageIndex, 2147483647, null, null);
DataTable dataTable = new DataTable();
dataTable.Columns.Add("序号");
dataTable.Columns.Add("项目状态");
dataTable.Columns.Add("立项申请人");
dataTable.Columns.Add("项目编号");
dataTable.Columns.Add("项目名称");
dataTable.Columns.Add("建设单位");
dataTable.Columns.Add("项目类型");
dataTable.Columns.Add("工程造价");
dataTable.Columns.Add("工程工期");
dataTable.Columns.Add("立项申请日期");
dataTable.Columns.Add("流程状态");
if (all.Rows.Count > 0)
{
for (int i = 0; i < all.Rows.Count; i++)
{
DataRow dataRow = dataTable.NewRow();
dataRow["序号"] = (i + 1).ToString();
dataRow["项目状态"] = all.Rows[i]["StateText"].ToString();
dataRow["立项申请人"] = all.Rows[i]["Person"].ToString();
dataRow["项目编号"] = all.Rows[i]["PrjCode"].ToString();
dataRow["项目名称"] = all.Rows[i]["PrjName"].ToString();
dataRow["建设单位"] = all.Rows[i]["WorkUnitName"].ToString();
dataRow["项目类型"] = all.Rows[i]["PrjTypeName"].ToString();
dataRow["工程造价"] = all.Rows[i]["PrjCost"].ToString();
dataRow["工程工期"] = all.Rows[i]["Duration"].ToString();
dataRow["立项申请日期"] = all.Rows[i]["InputDate"].ToString();
dataRow["流程状态"] = this.GetStateStr(all.Rows[i]["ProjFlowSate"].ToString());
dataTable.Rows.Add(dataRow);
}
DataRow dataRow2 = dataTable.NewRow();
dataRow2["序号"] = "合计";
dataRow2["项目状态"] = "";
dataRow2["立项申请人"] = "";
dataRow2["项目编号"] = "";
dataRow2["项目名称"] = "";
dataRow2["建设单位"] = "";
dataRow2["项目类型"] = "";
dataRow2["工程造价"] = all.Compute("SUM(PrjCost)", string.Empty).ToString();
dataRow2["工程工期"] = "";
dataRow2["立项申请日期"] = "";
dataRow2["流程状态"] = "";
dataTable.Rows.Add(dataRow2);
}
return(dataTable);
}