/// <summary>
/// 当前实体集合中追加单个实体
/// </summary>
/// <param name="entity">要追加的实体对象</param>
/// <returns>追加的行的索引(当前)</returns>
public int AppendEntityInfo(CEntityQuantityUnitSummary entity)
{
if (this == null || this.Columns.Count == 0)
{
this.buliderTable();
}
if (entity != null)
{
DataRow row = this.NewRow();
row[CEntityQuantityUnitSummary.FILED_XID] = entity.XID;
row[CEntityQuantityUnitSummary.FILED_DXID] = entity.DXID;
row[CEntityQuantityUnitSummary.FILED_DWID] = entity.DWID;
row[CEntityQuantityUnitSummary.FILED_QID] = entity.QID;
row[CEntityQuantityUnitSummary.FILED_ZID] = entity.ZID;
row[CEntityQuantityUnitSummary.FILED_ZCID] = entity.ZCID;
row[CEntityQuantityUnitSummary.FILED_ZCLB] = entity.ZCLB;
row[CEntityQuantityUnitSummary.FILED_CJXXID] = entity.CJXXID;
row[CEntityQuantityUnitSummary.FILED_YSBH] = entity.YSBH;
row[CEntityQuantityUnitSummary.FILED_YSMC] = entity.YSMC;
row[CEntityQuantityUnitSummary.FILED_YSDW] = entity.YSDW;
row[CEntityQuantityUnitSummary.FILED_YSXHL] = entity.YSXHL;
row[CEntityQuantityUnitSummary.FILED_DEDJ] = entity.DEDJ;
row[CEntityQuantityUnitSummary.FILED_DEHJ] = entity.DEHJ;
row[CEntityQuantityUnitSummary.FILED_BH] = entity.BH;
row[CEntityQuantityUnitSummary.FILED_LB] = entity.LB;
row[CEntityQuantityUnitSummary.FILED_SDCLB] = entity.SDCLB;
row[CEntityQuantityUnitSummary.FILED_SDCXS] = entity.SDCXS;
row[CEntityQuantityUnitSummary.FILED_SDCHJ] = entity.SDCHJ;
row[CEntityQuantityUnitSummary.FILED_MC] = entity.MC;
row[CEntityQuantityUnitSummary.FILED_GGXH] = entity.GGXH;
row[CEntityQuantityUnitSummary.FILED_DW] = entity.DW;
row[CEntityQuantityUnitSummary.FILED_SCDJ] = entity.SCDJ;
row[CEntityQuantityUnitSummary.FILED_SCHJ] = entity.SCHJ;
row[CEntityQuantityUnitSummary.FILED_XHL] = entity.XHL;
row[CEntityQuantityUnitSummary.FILED_SL] = entity.SL;
row[CEntityQuantityUnitSummary.FILED_SLH] = entity.SLH;
row[CEntityQuantityUnitSummary.FILED_DJC] = entity.DJC;
row[CEntityQuantityUnitSummary.FILED_HJC] = entity.HJC;
row[CEntityQuantityUnitSummary.FILED_IFPB] = entity.IFPB;
row[CEntityQuantityUnitSummary.FILED_IFZG] = entity.IFZG;
row[CEntityQuantityUnitSummary.FILED_IFJG] = entity.IFJG;
row[CEntityQuantityUnitSummary.FILED_IFYG] = entity.IFYG;
row[CEntityQuantityUnitSummary.FILED_IFFX] = entity.IFFX;
row[CEntityQuantityUnitSummary.FILED_IFSDSL] = entity.IFSDSL;
row[CEntityQuantityUnitSummary.FILED_IFSDSCDJ] = entity.IFSDSCDJ;
row[CEntityQuantityUnitSummary.FILED_IFSDGLJ] = entity.IFSDGLJ;
row[CEntityQuantityUnitSummary.FILED_SSKLB] = entity.SSKLB;
row[CEntityQuantityUnitSummary.FILED_SSXMLB] = entity.SSXMLB;
row[CEntityQuantityUnitSummary.FILED_SSXM] = entity.SSXM;
row[CEntityQuantityUnitSummary.FILED_GLJBZ] = entity.GLJBZ;
row[CEntityQuantityUnitSummary.FILED_GLJID] = entity.GLJID;
this.Rows.Add(row);
return(this.Rows.Count);
}
else
{
return(-1);
}
}
private void getSumary(DataRow[] rows)
{
foreach (DataRow row in rows)
{
string caijbh = row.Field <String>("BH");
DataRow row0 = null;
//若同工料编号的没有汇总则添加
bool flag = IsExist(caijbh, out row0);
if (flag)
{
CEntityQuantityUnitSummary info = new CEntityQuantityUnitSummary();
info.ID = row.Field <Int32>("ID");
info.ZCID = row.Field <Int32>("ZCID"); //组成编号
//info.ZCLB = row.Field<String>("ZCLB");//组成类别
info.CJXXID = row.Field <Int32>("CJXXID"); //厂家信息编号
info.DEDJ = row.Field <Decimal>("DEDJ"); //定额单价
info.DEHJ = row.Field <Decimal>("DEHJ"); //定额合价
info.BH = caijbh; //工料机编号
info.LB = row.Field <String>("LB"); //类别
info.SDCLB = row.Field <String>("SDCLB"); //三大材类别
info.SDCXS = row.Field <String>("SDCXS"); //三大材系数
info.SDCHJ = row.Field <Decimal>("SDCHJ"); //三大材和价
info.MC = row.Field <String>("MC"); //名称
info.GGXH = row.Field <String>("GGXH"); //规格及型号
info.DW = row.Field <String>("DW"); //单位
info.SCHJ = row.Field <Decimal>("SCHJ"); //市场合价
info.SCDJ = row.Field <Decimal>("SCDJ"); //市场单价
info.XHL = row.Field <Decimal>("XHL"); //消耗量
info.SLH = row.Field <Decimal>("SLH"); //数量和
info.DJC = row.Field <String>("DJC"); //单价差
info.HJC = row.Field <Decimal>("HJC"); //和价差
info.IFPB = row.Field <Boolean>("IFPB"); //是否评标
info.IFZG = row.Field <Boolean>("IFZG"); //是否暂定
info.IFJG = row.Field <Boolean>("IFJG"); //是否甲供
info.IFYG = row.Field <Boolean>("IFYG"); //是否乙供
info.IFFX = row.Field <Boolean>("IFFX"); //是否风险
info.IFSDSCDJ = row.Field <Boolean>("IFSDSCDJ"); //是否锁定市场价
info.SSXM = row.Field <String>("SSXM"); //所属项目
info.SSXMLB = row.Field <String>("SSXMLB"); //所属项目类别
info.GLJBZ = row.Field <String>("GLJBZ"); //工料机备注
info.GLJID = row.Field <String>("ZJCS"); //增加次数
// info.MC = row.Field<String>("Caijysmc");
//info赋值并添加到结果集中
this.m_Source.AppendEntityInfo(info);
}
else
{
row0["SLH"] = Convert.ToDecimal(row0["SLH"]) + Convert.ToDecimal(row["Caijxhlh"]);
row0["SCDJ"] = Convert.ToDecimal(row0["SCDJ"]) + Convert.ToDecimal(row["SCDJ"]) * Convert.ToDecimal(row["XHL"]);
//其他需要累加的
}
}
}
private void getSumary(DataRow[] rows)
{
foreach (DataRow row in rows)
{
string caijbh = row.Field <String>("BH");
DataRow row0 = null;
//若同工料编号的没有汇总则添加
bool flag = IsExist(caijbh, out row0);
if (flag)
{
CEntityQuantityUnitSummary info = new CEntityQuantityUnitSummary();
info.BH = caijbh;
info.MC = row.Field <String>("YSMC");
//info赋值并添加到结果集中
this.m_Source.AppendEntityInfo(info);
}
else
{
row0["SLH"] = Convert.ToDecimal(row0["SLH"]) + Convert.ToDecimal(row["YSXHL"]);
//其他需要累加的
}
}
}
/// <summary>
/// 获取当前集合指定行的实体对象
/// </summary>
/// <param name="index">集合中行的索引</param>
/// <returns>相关的实体对象(没有记录则返回空)</returns>
public CEntityQuantityUnitSummary this[int index]
{
get
{
//如果前一次执行已经转换过当前索引则直接返回
if (index == this.m_index)
{
return(this.m_CEntityQuantityUnitSummary);
}
if (this.Rows.Count > 0)
{
m_CEntityQuantityUnitSummary = new CEntityQuantityUnitSummary();
m_CEntityQuantityUnitSummary.ID = ToolKit.ParseInt(this.Rows[index][CEntityQuantityUnitSummary.FILED_ID]);
m_CEntityQuantityUnitSummary.XID = ToolKit.ParseInt(this.Rows[index][CEntityQuantityUnitSummary.FILED_XID]);
m_CEntityQuantityUnitSummary.DXID = ToolKit.ParseInt(this.Rows[index][CEntityQuantityUnitSummary.FILED_DXID]);
m_CEntityQuantityUnitSummary.DWID = ToolKit.ParseInt(this.Rows[index][CEntityQuantityUnitSummary.FILED_DWID]);
m_CEntityQuantityUnitSummary.QID = ToolKit.ParseInt(this.Rows[index][CEntityQuantityUnitSummary.FILED_QID]);
m_CEntityQuantityUnitSummary.ZID = ToolKit.ParseInt(this.Rows[index][CEntityQuantityUnitSummary.FILED_ZID]);
m_CEntityQuantityUnitSummary.ZCID = ToolKit.ParseInt(this.Rows[index][CEntityQuantityUnitSummary.FILED_ZCID]);
m_CEntityQuantityUnitSummary.ZCLB = ToolKit.ParseInt(this.Rows[index][CEntityQuantityUnitSummary.FILED_ZCLB]);
m_CEntityQuantityUnitSummary.CJXXID = ToolKit.ParseInt(this.Rows[index][CEntityQuantityUnitSummary.FILED_CJXXID]);
m_CEntityQuantityUnitSummary.YSBH = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_YSBH]);
m_CEntityQuantityUnitSummary.YSMC = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_YSMC]);
m_CEntityQuantityUnitSummary.YSDW = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_YSDW]);
m_CEntityQuantityUnitSummary.YSXHL = CDataConvert.ConToValue <System.Decimal>(this.Rows[index][CEntityQuantityUnitSummary.FILED_YSXHL]);
m_CEntityQuantityUnitSummary.DEDJ = CDataConvert.ConToValue <System.Decimal>(this.Rows[index][CEntityQuantityUnitSummary.FILED_DEDJ]);
m_CEntityQuantityUnitSummary.DEHJ = CDataConvert.ConToValue <System.Decimal>(this.Rows[index][CEntityQuantityUnitSummary.FILED_DEHJ]);
m_CEntityQuantityUnitSummary.BH = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_BH]);
m_CEntityQuantityUnitSummary.LB = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_LB]);
m_CEntityQuantityUnitSummary.SDCLB = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_SDCLB]);
m_CEntityQuantityUnitSummary.SDCXS = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_SDCXS]);
m_CEntityQuantityUnitSummary.SDCHJ = CDataConvert.ConToValue <System.Decimal>(this.Rows[index][CEntityQuantityUnitSummary.FILED_SDCHJ]);
m_CEntityQuantityUnitSummary.MC = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_MC]);
m_CEntityQuantityUnitSummary.GGXH = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_GGXH]);
m_CEntityQuantityUnitSummary.DW = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_DW]);
m_CEntityQuantityUnitSummary.SCDJ = CDataConvert.ConToValue <System.Decimal>(this.Rows[index][CEntityQuantityUnitSummary.FILED_SCDJ]);
m_CEntityQuantityUnitSummary.SCHJ = CDataConvert.ConToValue <System.Decimal>(this.Rows[index][CEntityQuantityUnitSummary.FILED_SCHJ]);
m_CEntityQuantityUnitSummary.XHL = CDataConvert.ConToValue <System.Decimal>(this.Rows[index][CEntityQuantityUnitSummary.FILED_XHL]);
m_CEntityQuantityUnitSummary.SL = CDataConvert.ConToValue <System.Decimal>(this.Rows[index][CEntityQuantityUnitSummary.FILED_SL]);
m_CEntityQuantityUnitSummary.SLH = CDataConvert.ConToValue <System.Decimal>(this.Rows[index][CEntityQuantityUnitSummary.FILED_SLH]);
m_CEntityQuantityUnitSummary.DJC = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_DJC]);
m_CEntityQuantityUnitSummary.HJC = CDataConvert.ConToValue <System.Decimal>(this.Rows[index][CEntityQuantityUnitSummary.FILED_HJC]);
m_CEntityQuantityUnitSummary.IFPB = ToolKit.ParseBoolen(this.Rows[index][CEntityQuantityUnitSummary.FILED_IFPB]);
m_CEntityQuantityUnitSummary.IFZG = ToolKit.ParseBoolen(this.Rows[index][CEntityQuantityUnitSummary.FILED_IFZG]);
m_CEntityQuantityUnitSummary.IFJG = ToolKit.ParseBoolen(this.Rows[index][CEntityQuantityUnitSummary.FILED_IFJG]);
m_CEntityQuantityUnitSummary.IFYG = ToolKit.ParseBoolen(this.Rows[index][CEntityQuantityUnitSummary.FILED_IFYG]);
m_CEntityQuantityUnitSummary.IFFX = ToolKit.ParseBoolen(this.Rows[index][CEntityQuantityUnitSummary.FILED_IFFX]);
m_CEntityQuantityUnitSummary.IFSDSL = ToolKit.ParseBoolen(this.Rows[index][CEntityQuantityUnitSummary.FILED_IFSDSL]);
m_CEntityQuantityUnitSummary.IFSDSCDJ = ToolKit.ParseBoolen(this.Rows[index][CEntityQuantityUnitSummary.FILED_IFSDSCDJ]);
m_CEntityQuantityUnitSummary.IFSDGLJ = ToolKit.ParseBoolen(this.Rows[index][CEntityQuantityUnitSummary.FILED_IFSDGLJ]);
m_CEntityQuantityUnitSummary.SSKLB = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_SSKLB]);
m_CEntityQuantityUnitSummary.SSXMLB = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_SSXMLB]);
m_CEntityQuantityUnitSummary.SSXM = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_SSXM]);
m_CEntityQuantityUnitSummary.GLJBZ = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_GLJBZ]);
m_CEntityQuantityUnitSummary.GLJID = CDataConvert.ConToValue <System.String>(this.Rows[index][CEntityQuantityUnitSummary.FILED_GLJID]);
this.m_index = index;
return(m_CEntityQuantityUnitSummary);
}
return(null);
}
set
{
this.Rows[index][CEntityQuantityUnitSummary.FILED_ID] = value.ID;
this.Rows[index][CEntityQuantityUnitSummary.FILED_XID] = value.XID;
this.Rows[index][CEntityQuantityUnitSummary.FILED_DXID] = value.DXID;
this.Rows[index][CEntityQuantityUnitSummary.FILED_DWID] = value.DWID;
this.Rows[index][CEntityQuantityUnitSummary.FILED_QID] = value.QID;
this.Rows[index][CEntityQuantityUnitSummary.FILED_ZID] = value.ZID;
this.Rows[index][CEntityQuantityUnitSummary.FILED_ZCID] = value.ZCID;
this.Rows[index][CEntityQuantityUnitSummary.FILED_ZCLB] = value.ZCLB;
this.Rows[index][CEntityQuantityUnitSummary.FILED_CJXXID] = value.CJXXID;
this.Rows[index][CEntityQuantityUnitSummary.FILED_YSBH] = value.YSBH;
this.Rows[index][CEntityQuantityUnitSummary.FILED_YSMC] = value.YSMC;
this.Rows[index][CEntityQuantityUnitSummary.FILED_YSDW] = value.YSDW;
this.Rows[index][CEntityQuantityUnitSummary.FILED_YSXHL] = value.YSXHL;
this.Rows[index][CEntityQuantityUnitSummary.FILED_DEDJ] = value.DEDJ;
this.Rows[index][CEntityQuantityUnitSummary.FILED_DEHJ] = value.DEHJ;
this.Rows[index][CEntityQuantityUnitSummary.FILED_BH] = value.BH;
this.Rows[index][CEntityQuantityUnitSummary.FILED_LB] = value.LB;
this.Rows[index][CEntityQuantityUnitSummary.FILED_SDCLB] = value.SDCLB;
this.Rows[index][CEntityQuantityUnitSummary.FILED_SDCXS] = value.SDCXS;
this.Rows[index][CEntityQuantityUnitSummary.FILED_SDCHJ] = value.SDCHJ;
this.Rows[index][CEntityQuantityUnitSummary.FILED_MC] = value.MC;
this.Rows[index][CEntityQuantityUnitSummary.FILED_GGXH] = value.GGXH;
this.Rows[index][CEntityQuantityUnitSummary.FILED_DW] = value.DW;
this.Rows[index][CEntityQuantityUnitSummary.FILED_SCDJ] = value.SCDJ;
this.Rows[index][CEntityQuantityUnitSummary.FILED_SCHJ] = value.SCHJ;
this.Rows[index][CEntityQuantityUnitSummary.FILED_XHL] = value.XHL;
this.Rows[index][CEntityQuantityUnitSummary.FILED_SL] = value.SL;
this.Rows[index][CEntityQuantityUnitSummary.FILED_SLH] = value.SLH;
this.Rows[index][CEntityQuantityUnitSummary.FILED_DJC] = value.DJC;
this.Rows[index][CEntityQuantityUnitSummary.FILED_HJC] = value.HJC;
this.Rows[index][CEntityQuantityUnitSummary.FILED_IFPB] = value.IFPB;
this.Rows[index][CEntityQuantityUnitSummary.FILED_IFZG] = value.IFZG;
this.Rows[index][CEntityQuantityUnitSummary.FILED_IFJG] = value.IFJG;
this.Rows[index][CEntityQuantityUnitSummary.FILED_IFYG] = value.IFYG;
this.Rows[index][CEntityQuantityUnitSummary.FILED_IFFX] = value.IFFX;
this.Rows[index][CEntityQuantityUnitSummary.FILED_IFSDSL] = value.IFSDSL;
this.Rows[index][CEntityQuantityUnitSummary.FILED_IFSDSCDJ] = value.IFSDSCDJ;
this.Rows[index][CEntityQuantityUnitSummary.FILED_IFSDGLJ] = value.IFSDGLJ;
this.Rows[index][CEntityQuantityUnitSummary.FILED_SSKLB] = value.SSKLB;
this.Rows[index][CEntityQuantityUnitSummary.FILED_SSXMLB] = value.SSXMLB;
this.Rows[index][CEntityQuantityUnitSummary.FILED_SSXM] = value.SSXM;
this.Rows[index][CEntityQuantityUnitSummary.FILED_GLJBZ] = value.GLJBZ;
this.Rows[index][CEntityQuantityUnitSummary.FILED_GLJID] = value.GLJID;
}
}
