public bool Add(ERM.MDL.T_Projects model_Projects, ERM.MDL.T_Item itemMDL)
{
this.Insert(model_Projects);
BLL.T_Item_BLL itemBLL = new ERM.BLL.T_Item_BLL();
itemBLL.Add(itemMDL);
return(true);
}
public bool Update(ERM.MDL.T_Projects model_Projects, ERM.MDL.T_Item itemMDL)
{
BLL.T_Item_BLL itemBLL = new ERM.BLL.T_Item_BLL();
itemMDL.ItemID = model_Projects.ItemID;
itemBLL.Update(itemMDL);
this.Update(model_Projects);
return(true);
}
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
if (tabControl1.SelectedIndex == 3)
{
if (itemMDL == null)
{
itemMDL = new ERM.BLL.T_Item_BLL().Find(projectMDL.ItemID);
}
if (itemMDL == null)
{
txtConStructionProjectName.Text = itemMDL.ConStructionProjectName;
txtRespective.Text = cboDistrict.Text;
return;
}
loadItemInfo();
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <ERM.MDL.T_Item> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
List <ERM.MDL.T_Item> modelList = new List <ERM.MDL.T_Item>();
int rowsCount = ds.Tables[0].Rows.Count;
if (rowsCount > 0)
{
ERM.MDL.T_Item model;
for (int n = 0; n < rowsCount; n++)
{
model = new ERM.MDL.T_Item();
model.ProjectNO = ds.Tables[0].Rows[n]["ProjectNO"].ToString();
model.AllCost = ds.Tables[0].Rows[n]["AllCost"].ToString();
model.Approvedate = ds.Tables[0].Rows[n]["Approvedate"].ToString();
model.BuildingDensity = ds.Tables[0].Rows[n]["BuildingDensity"].ToString();
model.CollectionType = ds.Tables[0].Rows[n]["CollectionType"].ToString();
model.ConstructionAreaSum = ds.Tables[0].Rows[n]["ConstructionAreaSum"].ToString();
model.ConstructionProjectAdd = ds.Tables[0].Rows[n]["ConstructionProjectAdd"].ToString();
model.ConStructionProjectName = ds.Tables[0].Rows[n]["ConStructionProjectName"].ToString();
model.ConstructionScale = ds.Tables[0].Rows[n]["ConstructionScale"].ToString();
model.CreateUnit = ds.Tables[0].Rows[n]["CreateUnit"].ToString();
model.FinishDate = ds.Tables[0].Rows[n]["FinishDate"].ToString();
model.GreenFar = ds.Tables[0].Rows[n]["GreenFar"].ToString();
model.ItemFzr = ds.Tables[0].Rows[n]["ItemFzr"].ToString();
model.OriginalSoiType = ds.Tables[0].Rows[n]["OriginalSoiType"].ToString();
model.ProjectCost = ds.Tables[0].Rows[n]["ProjectCost"].ToString();
model.ProjectSettlement = ds.Tables[0].Rows[n]["ProjectSettlement"].ToString();
model.ProjectType = ds.Tables[0].Rows[n]["ProjectType"].ToString();
model.Respective = ds.Tables[0].Rows[n]["Respective"].ToString();
model.StartDate = ds.Tables[0].Rows[n]["StartDate"].ToString();
model.UseSoiArea = ds.Tables[0].Rows[n]["UseSoiArea"].ToString();
model.UseSoiAreaSum = ds.Tables[0].Rows[n]["UseSoiAreaSum"].ToString();
model.UseSoiType = ds.Tables[0].Rows[n]["UseSoiType"].ToString();
model.VolumeFar = ds.Tables[0].Rows[n]["VolumeFar"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
private void Init()
{
ProjectBind();//页面绑定方法
ERM.BLL.T_Dict_BLL dicData = new ERM.BLL.T_Dict_BLL();
BLL.District bll1 = new ERM.BLL.District();
DataSet ds = bll1.GetAllList();
cboDistrict.DisplayMember = "DistrictName";
cboDistrict.ValueMember = "DistrictName";
cboDistrict.DataSource = ds.Tables[0];
if (cboDistrict.Items.Count > 0)
{
cboDistrict.SelectedIndex = 0;
}
ds3 = dicData.FindByKeyWord("ProjectCategory");
cboProjectType.DisplayMember = "displayname";
cboProjectType.ValueMember = "valuename";
cboProjectType.DataSource = ds3;
if (ProjectNo != "") //编辑模式
{
txtProjectNo.Enabled = false; //修改时，不允许修改项目编号，保证唯一性
this.cboProjectType.Enabled = false;
//修改 判断是否有权限修改工程编号与名称
if (!MyCommon.CheckProjectBind())
{
txtProjectNo.Enabled = false;
txtProjectName.Enabled = false;
}
projectMDL = (new BLL.T_Projects_BLL()).Find(ProjectNo);
if (projectMDL != null)
{
itemMDL = (new ERM.BLL.T_Item_BLL()).Find(projectMDL.ItemID);
loadItemInfo();
txtProjectNo.Text = projectMDL.ProjectNO; //工程代码
cboDistrict.Text = projectMDL.district == null ? "" : projectMDL.district; //区域
txtProjectName.Text = projectMDL.projectname; //工程名称
txtAddress.Text = projectMDL.address == null ? "" : projectMDL.address; //工程地址
cboProjectType.SelectedValue = projectMDL.ProjectCategory;
//txtYdpzcode.Text = projectMDL.ydpzcode == null ? "" : projectMDL.ydpzcode; //工程用地批准书号
txtYdghxkCode.Text = projectMDL.ydxkcode == null ? "" : projectMDL.ydxkcode; //用地规划许可证号
txtGhcode.Text = projectMDL.ghcode == null ? "" : projectMDL.ghcode; //规划许可证号
txtSgcode.Text = projectMDL.sgcode == null ? "" : projectMDL.sgcode; //工程施工许可证号
txtysbah.Text = projectMDL.ajdh == null?"":projectMDL.ajdh; //验收备案号
dtpBeginDate.TextEx = projectMDL.begindate == null ? "" : (projectMDL.begindate); //开工日期
dtpEndDate.TextEx = projectMDL.enddate == null ? "" : projectMDL.enddate;
//this.txtajdh.Text = projectMDL.ajdh.ToString();
this.cboProjectType.SelectedValue = projectMDL.ProjectCategory;//根据工程类型显示扩展信息
}
}
else
{
this.cboProjectType.SelectedIndex = 0;
projectMDL = new ERM.MDL.T_Projects();
itemMDL = new ERM.MDL.T_Item();
}
LoadDataFromView("");
BindUnit();
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ERM.MDL.T_Item model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ERM.MDL.T_Item model)
{
dal.Add(model);
}
public ProjectItemUnits(string openedProjectNo)
{
this._openedProjectNo = openedProjectNo;
ERM.MDL.T_Projects projectInfo = projectsData.Find(_openedProjectNo);
Hashtable projectDetail = new Hashtable();
//2010-03-29 因为导入数据存在NULL的情况 加个判断
projectDetail.Add("address", projectInfo.address == null ? "" : projectInfo.address);
projectDetail.Add("area1", projectInfo.area1 == null ? "" : projectInfo.area1);
projectDetail.Add("area2", projectInfo.area2 == null ? "" : projectInfo.area2);
projectDetail.Add("district", projectInfo.district == null ? "" : projectInfo.district);
projectDetail.Add("category", projectInfo.category == null ? "" : projectInfo.category);
projectDetail.Add("begindate", (projectInfo.begindate == null || projectInfo.begindate == "") ? "" : DateTime.Parse(projectInfo.begindate).ToString("yyyy-MM-dd"));
projectDetail.Add("bjdate", projectInfo.bjdate == null ? "" : projectInfo.bjdate);
projectDetail.Add("enddate", (projectInfo.enddate == null || projectInfo.enddate == "") ? "" : DateTime.Parse(projectInfo.enddate).ToString("yyyy-MM-dd"));
projectDetail.Add("floors1", projectInfo.floors1 == null ? "" : projectInfo.floors1);
projectDetail.Add("floors2", projectInfo.floors2 == null ? "" : projectInfo.floors2);
projectDetail.Add("ghcode", projectInfo.ghcode == null ? "" : projectInfo.ghcode);
projectDetail.Add("passwd", projectInfo.passwd == null ? "" : projectInfo.passwd);
projectDetail.Add("price1", projectInfo.price1 == null ? 0 : projectInfo.price1);
projectDetail.Add("price2", projectInfo.price2 == null ? 0 : projectInfo.price2);
projectDetail.Add("high", projectInfo.high == null ? "" : projectInfo.high);
projectDetail.Add("projectname", projectInfo.projectname == null ? "" : projectInfo.projectname);
projectDetail.Add("ProjectNO", projectInfo.ProjectNO == null ? "" : projectInfo.ProjectNO);
projectDetail.Add("projecttype", projectInfo.projecttype == null ? "" : projectInfo.projecttype);
projectDetail.Add("sgcode", projectInfo.sgcode == null ? "" : projectInfo.sgcode);
projectDetail.Add("ydpzcode", projectInfo.ydpzcode == null ? "" : projectInfo.ydpzcode);
projectDetail.Add("ydxkcode", projectInfo.ydxkcode == null ? "" : projectInfo.ydxkcode);
projectDetail.Add("stru", projectInfo.stru == null ? "" : projectInfo.stru);
projectDetail.Add("tempid", projectInfo.tempid == null ? 0 : projectInfo.tempid);
projectDetail.Add("hjqk", projectInfo.hjqk == null ? "" : projectInfo.hjqk);
projectDetail.Add("zzmj", projectInfo.zzmj == null ? "" : projectInfo.zzmj);
projectDetail.Add("bgyfmj", projectInfo.bgyfmj == null ? "" : projectInfo.bgyfmj);
projectDetail.Add("syyfmj", projectInfo.syyfmj == null ? "" : projectInfo.syyfmj);
projectDetail.Add("cfmj", projectInfo.cfmj == null ? "" : projectInfo.cfmj);
projectDetail.Add("dxsmj", projectInfo.dxsmj == null ? "" : projectInfo.dxsmj);
projectDetail.Add("qtyfmj", projectInfo.qtyfmj == null ? "" : projectInfo.qtyfmj);
projectDetail.Add("ts1", projectInfo.ts1 == null ? "" : projectInfo.ts1);
projectDetail.Add("ts2", projectInfo.ts2 == null ? "" : projectInfo.ts2);
projectDetail.Add("ts3", projectInfo.ts3 == null ? "" : projectInfo.ts3);
projectDetail.Add("ts4", projectInfo.ts4 == null ? "" : projectInfo.ts4);
projectDetail.Add("ts5", projectInfo.ts5 == null ? "" : projectInfo.ts5);
projectDetail.Add("tstotal", projectInfo.tstotal == null ? "" : projectInfo.tstotal);
projectDetail.Add("zygz", projectInfo.zygz == null ? "" : projectInfo.zygz);
projectDetail.Add("zjy", projectInfo.zjy == null ? "" : projectInfo.zjy);
projectDetail.Add("sgbzz", projectInfo.sgbzz == null ? "" : projectInfo.sgbzz);
projectDetail.Add("tbr", projectInfo.tbr == null ? "" : projectInfo.tbr);
projectDetail.Add("jsdwshr", projectInfo.jsdwshr == null ? "" : projectInfo.jsdwshr);
projectDetail.Add("jldwshr", projectInfo.jldwshr == null ? "" : projectInfo.jldwshr);
projectDetail.Add("createdate", projectInfo.createdate == null ? "" : projectInfo.createdate);
projectDetail.Add("ajdh", projectInfo.ajdh == null ? "" : projectInfo.ajdh);
projectDetail.Add("kzsfcd", projectInfo.kzsfcd == null ? "" : projectInfo.kzsfcd);
projectDetail.Add("ztcw", projectInfo.ztcw == null ? "" : projectInfo.ztcw);
projectDetail.Add("dstcw", projectInfo.dstcw == null ? "" : projectInfo.dstcw);
projectDetail.Add("dxtcw", projectInfo.dxtcw == null ? "" : projectInfo.dxtcw);
DataView dv;
MDL.T_Units mdl_unit = new ERM.MDL.T_Units();
mdl_unit.ProjectNO = this._openedProjectNo;
mdl_unit.unittype = "unit1";
//dv = unitData.GetList("ProjectNO='" + this._openedProjectNo + "' and unittype='unit1'").Tables[0].DefaultView;
dv = unitData.GetList(mdl_unit).Tables[0].DefaultView;
if (dv.Count <= 1)
{
if (dv.Count == 0)
{
projectDetail.Add("jsdw_mc", "");
projectDetail.Add("jsdw_xmfzr", "");
projectDetail.Add("jsdw_xmzyjsfzr", "");
}
else
{
projectDetail.Add("jsdw_mc", dv[0]["dwmc"].ToString());
projectDetail.Add("jsdw_xmfzr", dv[0]["fzr"].ToString());
projectDetail.Add("jsdw_xmzyjsfzr", dv[0]["zlfzr"].ToString());
}
}
else
{
string[] jsdwmc = new string[dv.Count]; //单位名称
string[] jsdwxmfzr = new string[dv.Count]; //项目负责人
for (int i = 0; i < dv.Count; i++)
{
jsdwmc[i] = dv[i]["dwmc"].ToString();
jsdwxmfzr[i] = dv[i]["fzr"].ToString();
}
projectDetail.Add("jsdw_mc", jsdwmc);
projectDetail.Add("jsdw_xmfzr", jsdwxmfzr);
}
//dv = unitData.GetList("ProjectNO='" + this._openedProjectNo + "' and unittype='unit2'").Tables[0].DefaultView;
mdl_unit.unittype = "unit2";
dv = unitData.GetList(mdl_unit).Tables[0].DefaultView;
if (dv.Count <= 1)
{
if (dv.Count == 0)
{
projectDetail.Add("kcdw_mc", "");
projectDetail.Add("kcdw_xmfzr", "");
projectDetail.Add("kcdw_jsfzr", "");
}
else
{
projectDetail.Add("kcdw_mc", dv[0]["dwmc"].ToString());
projectDetail.Add("kcdw_xmfzr", dv[0]["fzr"].ToString());
projectDetail.Add("kcdw_jsfzr", dv[0]["xmjl"].ToString());
}
}
else
{
string[] kcdwmc = new string[dv.Count]; //单位名称
string[] kcdwxmfzr = new string[dv.Count]; //项目负责人
string[] kcdwjsfzr = new string[dv.Count]; //技术负责人
for (int i = 0; i < dv.Count; i++)
{
kcdwmc[i] = dv[i]["dwmc"].ToString();
kcdwxmfzr[i] = dv[i]["fzr"].ToString();
kcdwjsfzr[i] = dv[i]["xmjl"].ToString();
}
projectDetail.Add("kcdw_mc", kcdwmc);
projectDetail.Add("kcdw_xmfzr", kcdwxmfzr);
projectDetail.Add("kcdw_jsfzr", kcdwjsfzr);
}
//dv = unitData.GetList("ProjectNO='" + this._openedProjectNo + "' and unittype='unit3'").Tables[0].DefaultView;
mdl_unit.unittype = "unit3";
dv = unitData.GetList(mdl_unit).Tables[0].DefaultView;
if (dv.Count <= 1)
{
if (dv.Count == 0)
{
projectDetail.Add("sjdw_mc", "");
projectDetail.Add("sjdw_xmfzr", "");
projectDetail.Add("sjdw_jsfzr", "");
}
else
{
projectDetail.Add("sjdw_mc", dv[0]["dwmc"].ToString());
projectDetail.Add("sjdw_xmfzr", dv[0]["fzr"].ToString());
projectDetail.Add("sjdw_jsfzr", dv[0]["xmjl"].ToString());
}
}
else
{
string[] sjdwmc = new string[dv.Count]; //单位名称
string[] sjdwxmfzr = new string[dv.Count]; //项目负责人
string[] sjdwjsfzr = new string[dv.Count]; //技术负责人
for (int i = 0; i < dv.Count; i++)
{
sjdwmc[i] = dv[i]["dwmc"].ToString();
sjdwxmfzr[i] = dv[i]["fzr"].ToString();
sjdwjsfzr[i] = dv[i]["xmjl"].ToString();
}
projectDetail.Add("sjdw_mc", sjdwmc);
projectDetail.Add("sjdw_xmfzr", sjdwxmfzr);
projectDetail.Add("sjdw_jsfzr", sjdwjsfzr);
}
//dv = unitData.GetList("ProjectNO='" + this._openedProjectNo + "' and unittype='unit4'").Tables[0].DefaultView;
mdl_unit.unittype = "unit4";
dv = unitData.GetList(mdl_unit).Tables[0].DefaultView;
if (dv.Count <= 1)
{
if (dv.Count == 0)
{
projectDetail.Add("sgdw_mc", "");
projectDetail.Add("sgdw_xmfzr", "");
projectDetail.Add("sgdw_jsfzr", "");
projectDetail.Add("sgdw_xmzyzljcy", "");
projectDetail.Add("sgdw_zlfzr", "");
projectDetail.Add("sgdw_jccsfzr", "");
projectDetail.Add("sgdw_syxfzr", "");
projectDetail.Add("sgdw_tsfzr", "");
}
else
{
projectDetail.Add("sgdw_mc", dv[0]["dwmc"].ToString());
projectDetail.Add("sgdw_xmfzr", dv[0]["xmjl"].ToString());
projectDetail.Add("sgdw_jsfzr", dv[0]["dwmc"].ToString());
projectDetail.Add("sgdw_xmzyzljcy", dv[0]["xmzyzljcy"].ToString());
projectDetail.Add("sgdw_zlfzr", dv[0]["zlfzr"].ToString());
projectDetail.Add("sgdw_jccsfzr", dv[0]["jccsfzr"].ToString());
projectDetail.Add("sgdw_syxfzr", dv[0]["syxfzr"].ToString());
projectDetail.Add("sgdw_tsfzr", dv[0]["tsfzr"].ToString());
}
}
else
{
string[] sgdwmc = new string[dv.Count]; //单位名称
string[] sgdwxmfzr = new string[dv.Count]; //项目经理
string[] sgdwjsfzr = new string[dv.Count]; //技术负责人
for (int i = 0; i < dv.Count; i++)
{
sgdwmc[i] = dv[i]["dwmc"].ToString();
sgdwxmfzr[i] = dv[i]["xmjl"].ToString();
sgdwjsfzr[i] = dv[i]["dwmc"].ToString();
}
projectDetail.Add("sgdw_mc", sgdwmc);
projectDetail.Add("sgdw_xmfzr", sgdwxmfzr);
projectDetail.Add("sgdw_jsfzr", sgdwjsfzr);
}
//dv = unitData.GetList("ProjectNO='" + this._openedProjectNo + "' and unittype='unit5'").Tables[0].DefaultView;
mdl_unit.unittype = "unit5";
dv = unitData.GetList(mdl_unit).Tables[0].DefaultView;
if (dv.Count <= 1)
{
if (dv.Count == 0)
{
projectDetail.Add("sgtdw_mc", "");
projectDetail.Add("sgtdw_xmfzr", "");
}
else
{
projectDetail.Add("sgtdw_mc", dv[0]["dwmc"].ToString());
projectDetail.Add("sgtdw_xmfzr", dv[0]["fzr"].ToString());
}
}
else
{
string[] sgtdwmc = new string[dv.Count]; //单位名称
string[] sgtdwxmfzr = new string[dv.Count]; //项目负责人
for (int i = 0; i < dv.Count; i++)
{
sgtdwmc[i] = dv[i]["dwmc"].ToString();
sgtdwxmfzr[i] = dv[i]["fzr"].ToString();
}
projectDetail.Add("sgtdw_mc", sgtdwmc);
projectDetail.Add("sgtdw_xmfzr", sgtdwxmfzr);
}
//dv = unitData.GetList("ProjectNO='" + this._openedProjectNo + "' and unittype='unit6'").Tables[0].DefaultView;
mdl_unit.unittype = "unit6";
dv = unitData.GetList(mdl_unit).Tables[0].DefaultView;
if (dv.Count <= 1)
{
if (dv.Count == 0)
{
projectDetail.Add("jldw_mc", "");
projectDetail.Add("jldw_jlgcs", "");
projectDetail.Add("jldw_zjlgcs", "");
}
else
{
projectDetail.Add("jldw_mc", dv[0]["dwmc"].ToString());
projectDetail.Add("jldw_xmfzr", dv[0]["fzr"].ToString());
projectDetail.Add("jldw_xmzj", dv[0]["xmjl"].ToString());
projectDetail.Add("jldw_xcjl", dv[0]["xcjl"].ToString());
}
}
else
{
string[] jldwmc = new string[dv.Count]; //单位名称
string[] jldwxmfzr = new string[dv.Count]; //项目负责人
string[] jldwxmzj = new string[dv.Count]; //项目总监
string[] jldwxcjl = new string[dv.Count]; //现场监理
for (int i = 0; i < dv.Count; i++)
{
jldwmc[i] = dv[i]["dwmc"].ToString();
jldwxmfzr[i] = dv[i]["fzr"].ToString();
jldwxmzj[i] = dv[i]["xmjl"].ToString();
jldwxcjl[i] = dv[i]["xcjl"].ToString();
}
projectDetail.Add("jldw_mc", jldwmc);
projectDetail.Add("jldw_xmfzr", jldwxmfzr);
projectDetail.Add("jldw_xmzj", jldwxmzj);
projectDetail.Add("jldw_xcjl", jldwxmzj);
}
//dv = unitData.GetList("ProjectNO='" + this._openedProjectNo + "' and unittype='unit7'").Tables[0].DefaultView;
mdl_unit.unittype = "unit7";
dv = unitData.GetList(mdl_unit).Tables[0].DefaultView;
if (dv.Count <= 1)
{
if (dv.Count == 0)
{
projectDetail.Add("jddw_mc", "");
projectDetail.Add("jddw_jdy", "");
}
else
{
projectDetail.Add("jddw_mc", dv[0]["dwmc"].ToString());
projectDetail.Add("jddw_jdy", dv[0]["fzr"].ToString());
}
}
else
{
string[] jddwmc = new string[dv.Count]; //单位名称
string[] jddwjdy = new string[dv.Count]; //监督员
for (int i = 0; i < dv.Count; i++)
{
jddwmc[i] = dv[i]["dwmc"].ToString();
jddwjdy[i] = dv[i]["fzr"].ToString();
}
projectDetail.Add("jddw_mc", jddwmc);
projectDetail.Add("jddw_jdy", jddwjdy);
}
//dv = unitData.GetList("ProjectNO='" + this._openedProjectNo + "' and unittype='unit8'").Tables[0].DefaultView;
mdl_unit.unittype = "unit8";
dv = unitData.GetList(mdl_unit).Tables[0].DefaultView;
if (dv.Count <= 1)
{
if (dv.Count == 0)
{
projectDetail.Add("fbdw_mc", "");
projectDetail.Add("fbdw_xmfzr", "");
projectDetail.Add("fbdw_jsfzr", "");
}
else
{
projectDetail.Add("fbdw_mc", dv[0]["dwmc"].ToString());
projectDetail.Add("fbdw_xmfzr", dv[0]["xmjl"].ToString());
projectDetail.Add("fbdw_jsfzr", dv[0]["fzr"].ToString());
}
}
else
{
string[] fbdwmc = new string[dv.Count]; //单位名称
string[] fbdwjsfzr = new string[dv.Count]; //技术负责人
string[] fbdwxmjl = new string[dv.Count]; //项目经理
for (int i = 0; i < dv.Count; i++)
{
fbdwmc[i] = dv[i]["dwmc"].ToString();
fbdwjsfzr[i] = dv[i]["fzr"].ToString();
fbdwxmjl[i] = dv[i]["xmjl"].ToString();
}
projectDetail.Add("fbdw_mc", fbdwmc);
projectDetail.Add("fbdw_xmfzr", fbdwxmjl);
projectDetail.Add("fbdw_jsfzr", fbdwjsfzr);
}
//dv = unitData.GetList("ProjectNO='" + this._openedProjectNo + "' and unittype='unit9'").Tables[0].DefaultView;
mdl_unit.unittype = "unit9";
dv = unitData.GetList(mdl_unit).Tables[0].DefaultView;
if (dv.Count <= 1)
{
if (dv.Count == 0)
{
projectDetail.Add("zcbdw_mc", "");
projectDetail.Add("zcbdw_xmfzr", "");
projectDetail.Add("zcbdw_fzr", "");
projectDetail.Add("zcbdw_xmzyzljcy", "");
projectDetail.Add("zcbdw_zlfzr", "");
}
else
{
projectDetail.Add("zcbdw_mc", dv[0]["dwmc"].ToString());
projectDetail.Add("zcbdw_xmfzr", dv[0]["xmjl"].ToString());
projectDetail.Add("zcbdw_fzr", dv[0]["fzr"].ToString());
projectDetail.Add("zcbdw_xmzyzljcy", dv[0]["xmzyzljcy"].ToString());
projectDetail.Add("zcbdw_zlfzr", dv[0]["zlfzr"].ToString());
}
}
else
{
string[] zcbdwmc = new string[dv.Count]; //单位名称
string[] zcbdwfzr = new string[dv.Count]; //总承包负责人
string[] zcbdwxmjl = new string[dv.Count]; //项目经理
for (int i = 0; i < dv.Count; i++)
{
zcbdwmc[i] = dv[i]["dwmc"].ToString();
zcbdwfzr[i] = dv[i]["fzr"].ToString();
zcbdwxmjl[i] = dv[i]["xmjl"].ToString();
}
projectDetail.Add("zcbdw_mc", zcbdwmc);
projectDetail.Add("zcbdw_xmfzr", zcbdwxmjl);
projectDetail.Add("zcbdw_fzr", zcbdwfzr);
}
//dv = unitData.GetList("ProjectNO='" + this._openedProjectNo + "' and unittype='unit10'").Tables[0].DefaultView;
mdl_unit.unittype = "unit10";
dv = unitData.GetList(mdl_unit).Tables[0].DefaultView;
if (dv.Count <= 1)
{
if (dv.Count == 0)
{
projectDetail.Add("azdw_mc", "");
projectDetail.Add("azdw_xmfzr", "");
projectDetail.Add("azdw_azfzr", "");
}
else
{
projectDetail.Add("azdw_mc", dv[0]["dwmc"].ToString());
projectDetail.Add("azdw_xmfzr", dv[0]["xmjl"].ToString());
projectDetail.Add("azdw_azfzr", dv[0]["fzr"].ToString());
}
}
else
{
string[] azdwmc = new string[dv.Count]; //单位名称
string[] azdwazfzr = new string[dv.Count]; //安装负责人
string[] azdwxmjl = new string[dv.Count]; //项目经理
for (int i = 0; i < dv.Count; i++)
{
azdwmc[i] = dv[i]["dwmc"].ToString();
azdwazfzr[i] = dv[i]["fzr"].ToString();
azdwxmjl[i] = dv[i]["xmjl"].ToString();
}
projectDetail.Add("azdw_mc", azdwmc);
projectDetail.Add("azdw_xmfzr", azdwxmjl);
projectDetail.Add("azdw_azfzr", azdwazfzr);
}
mdl_unit.unittype = "unit14";
dv = unitData.GetList(mdl_unit).Tables[0].DefaultView;
if (dv.Count <= 1)
{
if (dv.Count == 0)
{
projectDetail.Add("cldw_mc", "");
projectDetail.Add("cldw_xmfzr", "");
projectDetail.Add("cldw_azfzr", "");
}
else
{
projectDetail.Add("cldw_mc", dv[0]["dwmc"].ToString());
projectDetail.Add("cldw_xmfzr", dv[0]["xmjl"].ToString());
projectDetail.Add("cldw_azfzr", dv[0]["fzr"].ToString());
}
}
else
{
string[] cldwmc = new string[dv.Count]; //单位名称
string[] cldwazfzr = new string[dv.Count]; //安装负责人
string[] cldwxmjl = new string[dv.Count]; //项目经理
for (int i = 0; i < dv.Count; i++)
{
cldwmc[i] = dv[i]["dwmc"].ToString();
cldwazfzr[i] = dv[i]["fzr"].ToString();
cldwxmjl[i] = dv[i]["xmjl"].ToString();
}
projectDetail.Add("azdw_mc", cldwmc);
projectDetail.Add("azdw_xmfzr", cldwxmjl);
projectDetail.Add("azdw_azfzr", cldwazfzr);
}
///项目信息
ERM.MDL.T_Item ItemInfo = itemData.Find(projectInfo.ItemID);
projectDetail.Add("ItemID", ItemInfo.ItemID == null ? "" : ItemInfo.ItemID); //ID
projectDetail.Add("constructionprojectname",
ItemInfo.ConStructionProjectName == null ? "" : ItemInfo.ConStructionProjectName); //项目名称
projectDetail.Add("respective",
ItemInfo.Respective == null ? "" : ItemInfo.Respective); //区域
projectDetail.Add("constructionprojectadd",
ItemInfo.ConstructionProjectAdd == null ? "" : ItemInfo.ConstructionProjectAdd); //项目地址
projectDetail.Add("projecttype_item",
ItemInfo.ProjectType == null ? "" : ItemInfo.ProjectType); //建筑性质
projectDetail.Add("usesoiareasum",
ItemInfo.UseSoiAreaSum == null ? "" : ItemInfo.UseSoiAreaSum); //总用地面积
projectDetail.Add("constructionareasum",
ItemInfo.ConstructionAreaSum == null ? "" : ItemInfo.ConstructionAreaSum); //总建筑面积
projectDetail.Add("constructionscale",
ItemInfo.ConstructionScale == null ? "" : ItemInfo.ConstructionScale);
projectDetail.Add("projectcost",
ItemInfo.ProjectCost == null ? "" : ItemInfo.ProjectCost); //总结算
projectDetail.Add("projectsettlement",
ItemInfo.ProjectSettlement == null ? "" : ItemInfo.ProjectSettlement); //总预算
projectDetail.Add("usesoitype",
ItemInfo.UseSoiType == null ? "" : ItemInfo.UseSoiType);
projectDetail.Add("collectiontype",
ItemInfo.CollectionType == null ? "" : ItemInfo.CollectionType);
projectDetail.Add("originalsoitype",
ItemInfo.OriginalSoiType == null ? "" : ItemInfo.OriginalSoiType);
projectDetail.Add("usesoiarea", ItemInfo.UseSoiArea == null ? "" : ItemInfo.UseSoiArea);
projectDetail.Add("startdate", ItemInfo.StartDate == null ? "" : ItemInfo.StartDate);
projectDetail.Add("finishdate", ItemInfo.FinishDate == null ? "" : ItemInfo.FinishDate);
projectDetail.Add("approvedate", ItemInfo.Approvedate == null ? "" : ItemInfo.Approvedate);
projectDetail.Add("createunit", ItemInfo.CreateUnit == null ? "" : ItemInfo.CreateUnit); //建设单位
projectDetail.Add("itemfzr", ItemInfo.ItemFzr == null ? "" : ItemInfo.ItemFzr); //项目负责人
projectDetail.Add("allcost", ItemInfo.AllCost == null ? "" : ItemInfo.AllCost); //总地价
projectDetail.Add("volumefar", ItemInfo.VolumeFar == null ? "" : ItemInfo.VolumeFar); //容积率
projectDetail.Add("greenfar", ItemInfo.GreenFar == null ? "" : ItemInfo.GreenFar); //绿化率
projectDetail.Add("buildingdensity", ItemInfo.BuildingDensity == null ? "" : ItemInfo.BuildingDensity);
projectDetail.Add("ds", ItemInfo.ds == null ? "" : ItemInfo.ds);
projectDetail.Add("pzdw", ItemInfo.pzdw == null ? "" : ItemInfo.pzdw);
projectDetail.Add("pzh", ItemInfo.pzh == null ? "" : ItemInfo.pzh);
#region add
projectDetail.Add("zcd", ItemInfo.zcd == null ? "" : ItemInfo.zcd);
projectDetail.Add("start_x", projectInfo.Start_X == null ? "" : projectInfo.Start_X);
projectDetail.Add("start_y", projectInfo.Start_X == null ? "" : projectInfo.Start_X);
projectDetail.Add("end_x", projectInfo.End_X == null ? "" : projectInfo.End_X);
projectDetail.Add("end_y", projectInfo.End_Y == null ? "" : projectInfo.End_Y);
projectDetail.Add("shr", projectInfo.shr == null ? "" : projectInfo.shr);
projectDetail.Add("zlr", projectInfo.zlr == null ? "" : projectInfo.zlr);
projectDetail.Add("zlrq", projectInfo.zlrq == null ? "" : projectInfo.zlrq);
#region brige
if (projectInfo.ProjectCategory.ToLower() == "brige")
{
T_Project_Brige brige = brigeData.QueryBrige_ByProjID(this._openedProjectNo);
projectDetail.Add("acjgxs", brige.ACJGXS == null ? "" : brige.ACJGXS);
projectDetail.Add("dz", brige.DZ == null ? "" : brige.DZ);
projectDetail.Add("jcxs", brige.JCXS == null ? "" : brige.JCXS);
projectDetail.Add("jk", brige.JK == null ? "" : brige.JK);
projectDetail.Add("kj", brige.KJ == null ? "" : brige.KJ);
projectDetail.Add("level", brige.Level == null ? "" : brige.Level);
projectDetail.Add("longs", brige.Longs == null ? "" : brige.Longs);
projectDetail.Add("mcxs", brige.MCXS == null ? "" : brige.MCXS);
projectDetail.Add("projectid", brige.ProjectID == null ? "" : brige.ProjectID);
projectDetail.Add("remark", brige.Remark == null ? "" : brige.Remark);
projectDetail.Add("sbgz", brige.SBGZ == null ? "" : brige.SBGZ);
projectDetail.Add("ssf", brige.SSF == null ? "" : brige.SSF);
projectDetail.Add("sturucttype", brige.StuructType == null ? "" : brige.StuructType);
projectDetail.Add("width", brige.Width == null ? "" : brige.Width);
projectDetail.Add("xbgz", brige.XBGZ == null ? "" : brige.XBGZ);
projectDetail.Add("hz", brige.HZ == null ? "" : brige.HZ);
projectDetail.Add("gcys", brige.GCYS == null ? "" : brige.GCYS);
projectDetail.Add("gcjs", brige.GCJS == null ? "" : brige.GCJS);
}
#endregion
#region roadLamp
if (projectInfo.ProjectCategory.ToLower() == "roadlamp")
{
T_Project_RoadLamp roadLamp = roladLampData.QueryRoadLamp_ByProjID(this._openedProjectNo);
projectDetail.Add("dggd", roadLamp.DGGD == null ? "" : roadLamp.DGGD);
projectDetail.Add("dgjjl", roadLamp.DGJJL == null ? "" : roadLamp.DGJJL);
projectDetail.Add("dgzs", roadLamp.DGZS == null ? "" : roadLamp.DGZS);
projectDetail.Add("djbc", roadLamp.DJBC == null ? "" : roadLamp.DJBC);
projectDetail.Add("djzl", roadLamp.DJZL == null ? "" : roadLamp.DJZL);
projectDetail.Add("dlcd", roadLamp.DLCD == null ? "" : roadLamp.DLCD);
projectDetail.Add("dlgg", roadLamp.DLGG == null ? "" : roadLamp.DLGG);
projectDetail.Add("ggdgd", roadLamp.GGDGD == null ? "" : roadLamp.GGDGD);
projectDetail.Add("ggds", roadLamp.GGDS == null ? "" : roadLamp.GGDS);
projectDetail.Add("gl", roadLamp.GL == null ? "" : roadLamp.GL);
projectDetail.Add("gylx", roadLamp.GYLX == null ? "" : roadLamp.GYLX);
projectDetail.Add("jxj", roadLamp.JXJ == null ? "" : roadLamp.JXJ);
projectDetail.Add("ldxs_mt", roadLamp.LDXS_MT == null ? "" : roadLamp.LDXS_MT);
projectDetail.Add("ldxs_st", roadLamp.LDXS_ST == null ? "" : roadLamp.LDXS_ST);
projectDetail.Add("remark", roadLamp.Remark == null ? "" : roadLamp.Remark);
projectDetail.Add("xbxh", roadLamp.XBXH == null ? "" : roadLamp.XBXH);
projectDetail.Add("gcys", roadLamp.GCYS == null ? "" : roadLamp.GCYS);
}
#endregion
#region traffic
if (projectInfo.ProjectCategory.ToLower() == "traffic")
{
T_Traffic traffic = trafficData.QueryTraffic_ByProjID(this._openedProjectNo);
projectDetail.Add("hz", traffic.HZ == null ? "" : traffic.HZ);
projectDetail.Add("jcxs", traffic.JCXS == null ? "" : traffic.JCXS);
projectDetail.Add("kj", traffic.KJ == null ? "" : traffic.KJ);
projectDetail.Add("ks", traffic.KS == null ? "" : traffic.KS);
projectDetail.Add("longcount", traffic.LongCount == null ? "" : traffic.LongCount);
projectDetail.Add("mcxs", traffic.MCXS == null ? "" : traffic.MCXS);
projectDetail.Add("pwdj", traffic.PWDJ == null ? "" : traffic.PWDJ);
projectDetail.Add("remark", traffic.Remark == null ? "" : traffic.Remark);
projectDetail.Add("road_level", traffic.Road_Level == null ? "" : traffic.Road_Level);
projectDetail.Add("width", traffic.Width == null ? "" : traffic.Width);
projectDetail.Add("zpws", traffic.ZPWS == null ? "" : traffic.ZPWS);
projectDetail.Add("gcys", traffic.GCYS == null ? "" : traffic.GCYS);
projectDetail.Add("gcjs", traffic.GCJS == null ? "" : traffic.GCJS);
projectDetail.Add("startx", traffic.STARTX == null ? "" : traffic.STARTX);
projectDetail.Add("starty", traffic.STARTY == null ? "" : traffic.STARTY);
projectDetail.Add("endx", traffic.ENDX == null ? "" : traffic.ENDX);
projectDetail.Add("endy", traffic.ENDY == null ? "" : traffic.ENDY);
IList <T_Traffic_Detail> detailList = new BLL.T_Traffic_Detail_BLL().QueryTraffic_ByProjID(traffic.ID);
ERM.BLL.T_Dict_BLL dicData = new ERM.BLL.T_Dict_BLL();
IList <T_Dict> dictList = dicData.FindByKeyWord("TrafficType");
PropertyInfo[] properties = typeof(T_Traffic_Detail).GetProperties();
foreach (var item in detailList)
{
foreach (var dic in dictList)
{
if (dic.ValueName == item.Types)
{
for (int i = 0; i < properties.Length; i++)
{
string propertyID = properties[i].Name;
PropertyInfo pinfo = typeof(T_Traffic_Detail).GetProperty(propertyID);
string val = pinfo.GetValue(item, null) == null ? "" : pinfo.GetValue(item, null).ToString();
if (!string.IsNullOrEmpty(val))
{
string key = item.Types.ToLower() + "_" + propertyID.ToLower();
if (!projectDetail.ContainsKey(key))
{
projectDetail.Add(key, val);
}
}
}
}
}
}
}
#endregion
#endregion
this._projectDetail = projectDetail;
}//构造函数完成