Exemplo n.º 1
0
        /// <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);
        }
Exemplo n.º 2
0
        /// <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);
        }