/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ERM.MDL.T_Units model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Units set ");
strSql.Append("addr='" + model.addr + "',");
strSql.Append("dwmc='" + model.dwmc + "',");
strSql.Append("fax='" + model.fax + "',");
strSql.Append("fzr='" + model.fzr + "',");
strSql.Append("fzrzs='" + model.fzrzs + "',");
strSql.Append("projectno='" + model.projectno + "',");
strSql.Append("remark='" + model.remark + "',");
strSql.Append("tel='" + model.tel + "',");
strSql.Append("unitid='" + model.unitid + "',");
strSql.Append("unittype='" + model.unittype + "',");
strSql.Append("xmjl='" + model.xmjl + "',");
strSql.Append("zrzbsm='" + model.zrzbsm + "',");
strSql.Append("zrzlb='" + model.zrzlb + "',");
strSql.Append("zrzmc='" + model.zrzmc + "',");
strSql.Append("zrzzzfw='" + model.zrzzzfw + "',");
strSql.Append("zzdj='" + model.zzdj + "',");
strSql.Append("zzzh='" + model.zzzh + "'");
strSql.Append(" where unitid='" + model.unitid + "' ");
DbHelperOleDb.ExecuteSql(strSql.ToString());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ERM.MDL.T_Units GetModel(string unitid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" addr,dwmc,fax,fzr,fzrzs,projectno,remark,tel,unitid,unittype,xmjl,zrzbsm,zrzlb,zrzmc,zrzzzfw,zzdj,zzzh ");
strSql.Append(" from Units ");
strSql.Append(" where unitid='" + unitid + "' ");
ERM.MDL.T_Units model = new ERM.MDL.T_Units();
DataSet ds = DbHelperOleDb.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
model.addr = ds.Tables[0].Rows[0]["addr"].ToString();
model.dwmc = ds.Tables[0].Rows[0]["dwmc"].ToString();
model.fax = ds.Tables[0].Rows[0]["fax"].ToString();
model.fzr = ds.Tables[0].Rows[0]["fzr"].ToString();
model.fzrzs = ds.Tables[0].Rows[0]["fzrzs"].ToString();
model.projectno = ds.Tables[0].Rows[0]["projectno"].ToString();
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
model.tel = ds.Tables[0].Rows[0]["tel"].ToString();
model.unitid = ds.Tables[0].Rows[0]["unitid"].ToString();
model.unittype = ds.Tables[0].Rows[0]["unittype"].ToString();
model.xmjl = ds.Tables[0].Rows[0]["xmjl"].ToString();
model.zrzbsm = ds.Tables[0].Rows[0]["zrzbsm"].ToString();
model.zrzlb = ds.Tables[0].Rows[0]["zrzlb"].ToString();
model.zrzmc = ds.Tables[0].Rows[0]["zrzmc"].ToString();
model.zrzzzfw = ds.Tables[0].Rows[0]["zrzzzfw"].ToString();
model.zzdj = ds.Tables[0].Rows[0]["zzdj"].ToString();
model.zzzh = ds.Tables[0].Rows[0]["zzzh"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ERM.MDL.T_Units model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.addr != null)
{
strSql1.Append("addr,");
strSql2.Append("'" + model.addr + "',");
}
if (model.dwmc != null)
{
strSql1.Append("dwmc,");
strSql2.Append("'" + model.dwmc + "',");
}
if (model.fax != null)
{
strSql1.Append("fax,");
strSql2.Append("'" + model.fax + "',");
}
if (model.fzr != null)
{
strSql1.Append("fzr,");
strSql2.Append("'" + model.fzr + "',");
}
if (model.fzrzs != null)
{
strSql1.Append("fzrzs,");
strSql2.Append("'" + model.fzrzs + "',");
}
if (model.projectno != null)
{
strSql1.Append("projectno,");
strSql2.Append("'" + model.projectno + "',");
}
if (model.remark != null)
{
strSql1.Append("remark,");
strSql2.Append("'" + model.remark + "',");
}
if (model.tel != null)
{
strSql1.Append("tel,");
strSql2.Append("'" + model.tel + "',");
}
if (model.unitid != null)
{
strSql1.Append("unitid,");
strSql2.Append("'" + model.unitid + "',");
}
if (model.unittype != null)
{
strSql1.Append("unittype,");
strSql2.Append("'" + model.unittype + "',");
}
if (model.xmjl != null)
{
strSql1.Append("xmjl,");
strSql2.Append("'" + model.xmjl + "',");
}
if (model.zrzbsm != null)
{
strSql1.Append("zrzbsm,");
strSql2.Append("'" + model.zrzbsm + "',");
}
if (model.zrzlb != null)
{
strSql1.Append("zrzlb,");
strSql2.Append("'" + model.zrzlb + "',");
}
if (model.zrzmc != null)
{
strSql1.Append("zrzmc,");
strSql2.Append("'" + model.zrzmc + "',");
}
if (model.zrzzzfw != null)
{
strSql1.Append("zrzzzfw,");
strSql2.Append("'" + model.zrzzzfw + "',");
}
if (model.zzdj != null)
{
strSql1.Append("zzdj,");
strSql2.Append("'" + model.zzdj + "',");
}
if (model.zzzh != null)
{
strSql1.Append("zzzh,");
strSql2.Append("'" + model.zzzh + "',");
}
strSql.Append("insert into Units(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
DbHelperOleDb.ExecuteSql(strSql.ToString());
}
public DataView UnitSetting(Hashtable projectDetail)
{
MDL.T_Units mdl_unit = new ERM.MDL.T_Units();
mdl_unit.ProjectNO = this._openedProjectNo;
DataView dv;
mdl_unit.unittype = "unit3";
dv = unitData.GetList(mdl_unit).Tables[0].DefaultView;
if (dv.Count <= 1)
{
if (dv.Count == 0)
{
projectDetail.Add("设计单位", "");
projectDetail.Add("设计单位项目负责人", "");
}
else
{
projectDetail.Add("设计单位", dv[0]["dwmc"].ToString());
projectDetail.Add("设计单位项目负责人", dv[0]["fzr"].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();
}
projectDetail.Add("设计单位", sjdwmc);
projectDetail.Add("设计单位项目负责人", sjdwxmfzr);
}
//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("勘察单位", "");
projectDetail.Add("勘察单位项目负责人", "");
}
else
{
projectDetail.Add("勘察单位", dv[0]["dwmc"].ToString());
projectDetail.Add("勘察单位项目负责人", dv[0]["fzr"].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();
}
projectDetail.Add("勘察单位", kcdwmc);
projectDetail.Add("勘察单位项目负责人", kcdwxmfzr);
}
//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("监理单位", "");
projectDetail.Add("监理单位项目负责人", "");
projectDetail.Add("项目总监", "");
projectDetail.Add("现场监理", "");
}
else
{
projectDetail.Add("监理单位", dv[0]["dwmc"].ToString());
projectDetail.Add("监理单位项目负责人", dv[0]["fzr"].ToString());
projectDetail.Add("项目总监", dv[0]["xmjl"].ToString());
projectDetail.Add("现场监理", dv[0]["fzr"].ToString());
}
}
else
{
string[] jldwmc = new string[dv.Count]; //单位名称
string[] jldwjlgcs = new string[dv.Count]; //监理工程师
string[] jldwzjlgcs = new string[dv.Count]; //总监理工程师
for (int i = 0; i < dv.Count; i++)
{
jldwmc[i] = dv[i]["dwmc"].ToString();
jldwjlgcs[i] = dv[i]["fzr"].ToString();
jldwzjlgcs[i] = dv[i]["xmjl"].ToString();
}
projectDetail.Add("监理单位", jldwmc);
projectDetail.Add("监理单位项目负责人", jldwjlgcs);
projectDetail.Add("项目总监", jldwzjlgcs);
projectDetail.Add("现场监理", jldwjlgcs);
}
//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("分包单位", "");
projectDetail.Add("分包单位项目经理", "");
}
else
{
projectDetail.Add("分包单位", dv[0]["dwmc"].ToString());
projectDetail.Add("分包单位项目经理", dv[0]["xmjl"].ToString());
}
}
else
{
string[] fbdwmc = new string[dv.Count]; //单位名称
string[] fbdwxmjl = new string[dv.Count]; //项目经理
for (int i = 0; i < dv.Count; i++)
{
fbdwmc[i] = dv[i]["dwmc"].ToString();
fbdwxmjl[i] = dv[i]["xmjl"].ToString();
}
projectDetail.Add("分包单位", fbdwmc);
projectDetail.Add("分包单位项目经理", fbdwxmjl);
}
//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("施工单位", "");
projectDetail.Add("施工单位项目经理", "");
}
else
{
projectDetail.Add("施工单位", dv[0]["dwmc"].ToString());
projectDetail.Add("施工单位项目经理", dv[0]["xmjl"].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();
}
projectDetail.Add("施工单位", sgdwmc);
projectDetail.Add("施工单位项目经理", sgdwxmfzr);
}
return(dv);
}
