/// <summary> /// 项目调用 统计到单项工程-2 和 项目-3 /// </summary> public void Statistics() { DataView table = this.ModelProject.DefaultView; _VariableSource t1 = null; foreach (DataRowView row in table) { //单项工程统计 if (row["DEEP"].Equals(1)) { int EnID = ToolKit.ParseInt(row["ID"]); t1 = _VariableSource.CreateInstance(EnID, -2); foreach (DataRow dr in t1.Rows) { dr["Value"] = this.ModelProjVariable.Compute("sum(Value)", string.Format(" EnID = '{0}' and Key = '{1}' and Type = -1", EnID, dr["Key"])); dr["EnID"] = EnID; dr["ID"] = EnID; } this.ModelProjVariable.MergeData(t1, false); } } t1 = _VariableSource.CreateInstance(-1, -3); foreach (DataRow dr in t1.Rows) { dr["Value"] = this.ModelProjVariable.Compute("sum(Value)", string.Format(" Key = '{0}' and Type = -2", dr["Key"])); dr["EnID"] = -1; dr["ID"] = 0; } this.ModelProjVariable.MergeData(t1, false); }
/// <summary> /// 创建子目变量对象 /// </summary> public static _VariableSource CreateInstance(int p_EnID, int p_Type) { _VariableSource UNResultVarable = new _VariableSource(); #region -----------------------------分部分项最终参数------------------------ UNResultVarable.Set(p_EnID, p_Type, "FBFXHJ", 0, "[分部分项]分部分项合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXRGFHJ", 0, "[分部分项]分部分项人工费合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXCLFHJ", 0, "[分部分项]分部分项材料费合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXZCFHJ", 0, "[分部分项]分部分项主材费合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXSBFHJ", 0, "[分部分项]分部分项设备费合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXJXFHJ", 0, "[分部分项]分部分项机械费合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXGLFHJ", 0, "[分部分项]分部分项管理费合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXLRHJ", 0, "[分部分项]分部分项利润合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXFXHJ", 0, "[分部分项]分部分项风险合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXZGJEHJ", 0, "[分部分项]分部分项暂估金额合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXJGJEHJ", 0, "[分部分项]分部分项甲供金额合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXFBJEHJ", 0, "[分部分项]分部分项分包金额合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXJBHZHJ", 0, "[分部分项]分部分项局部汇总金额合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXDEHJ", 0, "[分部分项]分部分项定额价合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXDERGFHJ", 0, "[分部分项]分部分项定额人工费合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXDECLFHJ", 0, "[分部分项]分部分项定额材料费合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXDEZCFHJ", 0, "[分部分项]分部分项定额主材费合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXDESBFHJ", 0, "[分部分项]分部分项定额设备费合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXDEJXFHJ", 0, "[分部分项]分部分项定额机械费合计"); //UNResultVarable.Set(p_EnID, p_Type, "FBFXDEGLFHJ", 0, "[分部分项]分部分项定额管理费合计"); //UNResultVarable.Set(p_EnID, p_Type, "FBFXDELRHJ", 0, "[分部分项]分部分项定额利润合计"); //UNResultVarable.Set(p_EnID, p_Type, "FBFXDEFXHJ", 0, "[分部分项]分部分项定额风险合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXDEZGJEHJ", 0, "[分部分项]分部分项定额暂估金额合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXDEJGJEHJ", 0, "[分部分项]分部分项定额甲供金额合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXDEFBJEHJ", 0, "[分部分项]分部分项定额分包金额合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXDEJBHZHJ", 0, "[分部分项]分部分项定额局部汇总金额合计"); // this.UNResultVarable.Set(p_EnID,p_Type,"HHJXFHJ", 0, "[分部分项]混合机械人工费合价"); UNResultVarable.Set(p_EnID, p_Type, "FBFXJCHJ", 0, "[分部分项]分部分项价差合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXRGJCHJ", 0, "[分部分项]分部分项人工费价差合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXCLJCHJ", 0, "[分部分项]分部分项材料费价差合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXJXJCHJ", 0, "[分部分项]分部分项机械费价差合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXCJHJ", 0, "[分部分项]分部分项可能发生的差价合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXRGCJHJ", 0, "[分部分项]分部分项人工费调增差价合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXCLCJHJ", 0, "[分部分项]分部分项材料费调增差价合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXJXCJHJ", 0, "[分部分项]分部分项机械费调增差价合计"); UNResultVarable.Set(p_EnID, p_Type, "Z[人工].rgf", 0, "[分部分项]定额特项为“人工”的人工费"); UNResultVarable.Set(p_EnID, p_Type, "Q[ZS].jxf", 0, "[分部分项]清单特项为“ZS”的综合合价"); UNResultVarable.Set(p_EnID, p_Type, "Z[建筑].rgf", 0, "[分部分项]定额特项为“建筑”的人工费"); UNResultVarable.Set(p_EnID, p_Type, "Z[安装].rgf", 0, "[分部分项]定额特项为“安装”的人工费"); UNResultVarable.Set(p_EnID, p_Type, "Z[桩基].clf", 0, "[分部分项]定额特项为“桩基”的材料费"); UNResultVarable.Set(p_EnID, p_Type, "Z[建筑].jxf", 0, "[分部分项]定额特项为“建筑”的机械费"); UNResultVarable.Set(p_EnID, p_Type, "Z[机械].xmf", 0, "[分部分项]定额特项为“机械”的综合合价"); UNResultVarable.Set(p_EnID, p_Type, "Z[桩基].xmf", 0, "[分部分项]定额特项为“桩基”的综合合价"); UNResultVarable.Set(p_EnID, p_Type, "Z[建筑].xmf", 0, "[分部分项]定额特项为“建筑”的综合合价"); UNResultVarable.Set(p_EnID, p_Type, "Z[装饰].xmf", 0, "[分部分项]定额特项为“装饰”的综合合价"); UNResultVarable.Set(p_EnID, p_Type, "Q[JZ].xmf", 0, "[分部分项]清单特项为“JZ”的综合合价"); UNResultVarable.Set(p_EnID, p_Type, "Q[ZS].jxf", 0, "[分部分项]清单特项为“ZS”的综合合价"); UNResultVarable.Set(p_EnID, p_Type, "FBFXGFHJ", 0, "[分部分项]分部分项规费合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXSJHJ", 0, "[分部分项]分部分项税金合计"); UNResultVarable.Set(p_EnID, p_Type, "FBFXZJFHJ", 0, "[分部分项]分部分项直接费合价"); #endregion #region -------------------------------措施项目最终参数------------------------ UNResultVarable.Set(p_EnID, p_Type, "CSXMHJ", 0, "[措施项目]措施项目合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMRGFHJ", 0, "[措施项目]措施项目人工费合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMCLFHJ", 0, "[措施项目]措施项目材料费合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMZCFHJ", 0, "[措施项目]措施项目主材费合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMSBFHJ", 0, "[措施项目]措施项目设备费合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMJXFHJ", 0, "[措施项目]措施项目机械费合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMGLFHJ", 0, "[措施项目]措施项目管理费合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMLRHJ", 0, "[措施项目]措施项目利润合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMFXHJ", 0, "[措施项目]措施项目风险合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMZGJEHJ", 0, "[措施项目]措施项目暂估金额合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMJGJEHJ", 0, "[措施项目]措施项目甲供金额合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMFBJEHJ", 0, "[措施项目]措施项目分包金额合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMJBHZHJ", 0, "[措施项目]措施项目局部汇总金额合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMDEHJ", 0, "[措施项目]措施项目定额价合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMDERGFHJ", 0, "[措施项目]措施项目定额人工费合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMDECLFHJ", 0, "[措施项目]措施项目定额材料费合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMDEZCFHJ", 0, "[措施项目]措施项目定额主材费合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMDESBFHJ", 0, "[措施项目]措施项目定额设备费合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMDEJXFHJ", 0, "[措施项目]措施项目定额机械费合计"); //UNResultVarable.Set(p_EnID, p_Type, "CSXMDEGLFHJ", 0, "[措施项目]措施项目定额管理费合计"); //UNResultVarable.Set(p_EnID, p_Type, "CSXMDELRHJ", 0, "[措施项目]措施项目定额利润合计"); //UNResultVarable.Set(p_EnID, p_Type, "CSXMDEFXHJ", 0, "[措施项目]措施项目定额风险合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMDEZGJEHJ", 0, "[措施项目]措施项目定额暂估金额合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMDEJGJEHJ", 0, "[措施项目]措施项目定额甲供金额合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMDEFBJEHJ", 0, "[措施项目]措施项目定额分包金额合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMDEJBHZHJ", 0, "[措施项目]措施项目定额局部汇总金额合计"); //this.UNResultVarable.Set(p_EnID,p_Type,"CSXMJC" , 0, "[措施项目]措施项目价差"); //this.UNResultVarable.Set(p_EnID,p_Type,"CSXMCJ" , 0, "[措施项目]措施项目差价"); //this.UNResultVarable.Set(p_EnID,p_Type,"HHJXFHJ", 0, "[措施项目]混合机械人工费合价"); //this.UNResultVarable.Set(p_EnID,p_Type,"FBFXJCHJ", 0, "[措施项目]分部分项价差合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMJCHJ", 0, "[措施项目]措施项目价差合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMRGJCHJ", 0, "[措施项目]措施项目人工费价差合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMCLJCHJ", 0, "[措施项目]措施项目材料费价差合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMJXJCHJ", 0, "[措施项目]措施项目机械费价差合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMCJHJ", 0, "[措施项目]措施项目可能发生的差价合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMRGCJHJ", 0, "[措施项目]措施项目人工费调增差价合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMCLCJHJ", 0, "[措施项目]措施项目材料费调增差价合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMJXCJHJ", 0, "[措施项目]措施项目机械费调增差价合计"); UNResultVarable.Set(p_EnID, p_Type, "CSAQWM", 0, "[措施项目]安全文明施工措施费"); UNResultVarable.Set(p_EnID, p_Type, "CSWMSG", 0, "[措施项目]安全文明施工费"); UNResultVarable.Set(p_EnID, p_Type, "CSHJBH", 0, "[措施项目]环境保护费(含排污)"); UNResultVarable.Set(p_EnID, p_Type, "CSLSSS", 0, "[措施项目]临时设施费"); UNResultVarable.Set(p_EnID, p_Type, "CSXMGFHJ", 0, "[措施项目]措施项目规费合计"); UNResultVarable.Set(p_EnID, p_Type, "CSXMSJHJ", 0, "[措施项目]措施项目税金合计"); UNResultVarable.Set(p_EnID, p_Type, "KCAQWMCSF", 0, "[措施项目]扣除安全文明施工费"); UNResultVarable.Set(p_EnID, p_Type, "CSXMZJFHJ", 0, "[措施项目]措施项目直接费合价"); #endregion #region -------------------------------其他项目最终参数------------------------ UNResultVarable.Set(p_EnID, p_Type, "QTXMHJ", 0, "[其他项目]其他项目合计"); UNResultVarable.Set(p_EnID, p_Type, "QTXMCJHJ", 0, "[其他项目]其他项目差价合价"); UNResultVarable.Set(p_EnID, p_Type, "QTXMJSCJHJ", 0, "[其他项目]其他项目结算差价合计"); UNResultVarable.Set(p_EnID, p_Type, "QTXMRGCJHJ", 0, "[其他项目]其他项目人工费调增差价合计"); UNResultVarable.Set(p_EnID, p_Type, "ZLJE", 0, "[其他项目]暂列金额"); UNResultVarable.Set(p_EnID, p_Type, "SJBGCJ", 0, "[其他项目]设计变更及材料(主材)差价"); UNResultVarable.Set(p_EnID, p_Type, "ZYGCZGJ", 0, "[其他项目]专业工程暂估价"); UNResultVarable.Set(p_EnID, p_Type, "ZCSBZGJ", 0, "[其他项目]主材设备暂估价"); UNResultVarable.Set(p_EnID, p_Type, "LXFBGCE", 0, "[其他项目]另行分包的专业工程金额"); UNResultVarable.Set(p_EnID, p_Type, "JRG", 0, "[其他项目]计日工"); UNResultVarable.Set(p_EnID, p_Type, "JRGRG", 0, "[其他项目]人工"); UNResultVarable.Set(p_EnID, p_Type, "JRGCL", 0, "[其他项目]材料"); UNResultVarable.Set(p_EnID, p_Type, "JRGJX", 0, "[其他项目]机械"); UNResultVarable.Set(p_EnID, p_Type, "ZCBFWF", 0, "[其他项目]总承包服务费"); UNResultVarable.Set(p_EnID, p_Type, "FBGLFWF", 0, "[其他项目]发包人发包专业工程管理服务费"); UNResultVarable.Set(p_EnID, p_Type, "FBRBGF", 0, "[其他项目]发包人供应材料、设备保管费"); UNResultVarable.Set(p_EnID, p_Type, "FSPTJJJ", 0, "[其他项目]副食品调节基金"); #endregion #region -------------------------------汇总分析------------------------ UNResultVarable.Set(p_EnID, p_Type, "FGCF", 0, "[汇总分析]分部分项工程费"); UNResultVarable.Set(p_EnID, p_Type, "CSXMF", 0, "[汇总分析]措施项目费"); UNResultVarable.Set(p_EnID, p_Type, "QTXMF", 0, "[汇总分析]其他项目费"); UNResultVarable.Set(p_EnID, p_Type, "GF", 0, "[汇总分析]规费"); UNResultVarable.Set(p_EnID, p_Type, "BHSZJ", 0, "[汇总分析]不含税单位工程造价"); UNResultVarable.Set(p_EnID, p_Type, "SJ", 0, "[汇总分析]税金"); UNResultVarable.Set(p_EnID, p_Type, "GCZJ", 0, "[汇总分析]含税单位工程造价"); UNResultVarable.Set(p_EnID, p_Type, "ZZJ", 0, "[汇总分析]扣除养老保险后含税单位工程造价"); UNResultVarable.Set(p_EnID, p_Type, "AQWM", 0, "[汇总分析]安全文明施工费"); #endregion return(UNResultVarable); }