private KeyValue <DataSet, string[], object[]> ExportToDoc3(object arg)
{
var result = arg as KeyValue <BidOpeningManagement, ProcurementPlan, BiddingManagement>;
var dateInfo = new ProcurementPlanManagement(result.Value.Mode, result.Item3.PlanDateEnd);
var value = new[]
{
"项目名称",
"主要内容",
"年度预算",
"招标控制价",
"招标复审控制价",
"招投标计划时间",
"招标公告时间起",
"招标公告时间止",
"标书发售时间起",
"标书发售时间止",
"执行周期起",
"执行周期止",
"开标时间",
"结果公告时间",
"结果公示时间起",
"结果公示时间止",
"中标通知书时间",
"合同签订时间起",
"合同签订时间止",
"采购方式"
};
string GetModel(string model)
{
switch (model)
{
case "Yqzb":
return("邀请招标");
break;
case "Jzxtp":
return("竞争性谈判");
break;
case "Xjcg":
return("询价采购");
break;
case "Bxcg":
return("比选采购");
break;
case "GkzbZhpff":
return("公开招标(综合评分法)");
break;
case "GkzbZdjf":
return("公开招标(最低价法)");
break;
case "Dylycg":
return("单一来源采购");
break;
default:
return(string.Empty);
}
}
var item3 = new[]
{
result.Value.Name,
result.Item3.Note,
result.Value.PlanWithBudgetOutlays.Sum(r => r.BudgetOutlay.Price * r.BudgetOutlay.Amount)
.ToString("N2"),
result.Item3.Total.ToString("N"),
result.Item3.Total.ToString("N"),
result.Value.Date.ToString("yyyy-M-d"),
dateInfo.Date11.ToString("M.d"),
dateInfo.Date12.ToString("M.d"),
dateInfo.Date41.ToString("M.d"),
dateInfo.Date42.ToString("M.d"),
dateInfo.Date51.ToString("M.d"),
dateInfo.Date52.ToString("M.d"),
result.Item3.PlanDateEnd.ToString("yyyy-M-d"),
dateInfo.Date2.ToString("M.d"),
dateInfo.Date31.ToString("M.d"),
dateInfo.Date32.ToString("M.d"),
dateInfo.Date6.ToString("M.d"),
dateInfo.Date71.ToString("M.d"),
dateInfo.Date72.ToString("M.d"),
GetModel(result.Value.Mode)
};
var ds = new DataSet();
var dt = new DataTable();
ds.Tables.Add(dt);
return(new KeyValue <DataSet, string[], object[]>(ds, value, item3));
}
private KeyValue <DataSet, string[], object[]> ExportToDoc(object arg)
{
var result = arg as KeyValue <BiddingManagement, ProcurementPlan, List <CostList> >;
var biddingAgency = this._sysDictionaryRepository.Get(result.Key.BiddingAgencyId);
var value = new[]
{
"采购项目编号",
"招标代理机构",
"项目名称",
"招标时间大写",
"招标时间",
"文件发售时间起",
"文件发售时间止",
"招标代理公司地址",
"开标截止时间",
"招标代理公司银行",
"招标代理公司账号",
"招标代理公司联系人2",
"招标代理公司电话",
"招标代理公司邮箱",
"最高限价",
"招标代理公司联系人",
"工期"
};
var year = StringExtensions.NumberToChinese(DateTime.Now.Year.ToString());
var mounth = StringExtensions.NumberToChinese(DateTime.Now.Month.ToString());
if (mounth.Length == 2)
{
mounth = mounth[0] + "十" + mounth[1];
}
var baseDateInfo = new ProcurementPlanManagement(result.Value.Mode, result.Key.PlanDateEnd);
var item3 = new[]
{
result.Value.Code,
biddingAgency.Value,
result.Value.Name,
$"{year}年{mounth}月",
DateTime.Now.ToString("yyyy年M月d日"),
baseDateInfo.Date41.ToString("yyyy年M月d日"),
baseDateInfo.Date42.ToString("yyyy年M月d日"),
biddingAgency.Value4,
result.Key.PlanDateEnd.ToString("yyyy年M月d日"),
biddingAgency.Value2,
biddingAgency.Value3,
$"{biddingAgency.Value8},{biddingAgency.Value9}",
$"{biddingAgency.Value11} {biddingAgency.Value15}",
biddingAgency.Value16,
result.Key.Total.ToString("N2"),
biddingAgency.Value11,
result.Key.Schedule.ToString()
};
var ds = new DataSet();
var dt = new DataTable("CostList");
dt.Columns.Add("Index");
dt.Columns.Add("Category");
dt.Columns.Add("Details");
dt.Columns.Add("Unit");
dt.Columns.Add("Amount");
for (var i = 0; i < result.Item3.Count; i++)
{
var row = dt.NewRow();
row["Index"] = i + 1;
row["Category"] = result.Item3[i].Category;
row["Details"] = result.Item3[i].Details;
row["Unit"] = result.Item3[i].Unit;
row["Amount"] = result.Item3[i].Amount;
dt.Rows.Add(row);
}
ds.Tables.Add(dt);
return(new KeyValue <DataSet, string[], object[]>(ds, value, item3));
}
