예제 #1
0
        /// <summary>
        /// 获取项目概算
        /// </summary>
        /// <param name="ProjGuid"></param>
        /// <returns></returns>
        public static DataTable GetEstimateDetail(string ProjGuid)
        {
            DataSet DataEstimate = IMCBaseInfo.GetAllEstimateDetailByProjGuid(ProjGuid);

            DataTable dt = new DataTable();

            dt.Columns.Add("Guid");
            dt.Columns.Add("ProjOrCostName");
            dt.Columns.Add("Code");
            dt.Columns.Add("OrderNum");
            if (DataEstimate.Tables[0].Rows.Count > 0)
            {
                int i = 0;
                foreach (DataRow dr in DataEstimate.Tables[0].Select(" TopGuid is null  or TopGuid=''", "Code asc"))
                {
                    i++;
                    if (i < 3)//概算前两项
                    {
                        //判断主概算下面有没有子概算
                        if (DataEstimate.Tables[0].Select("topGuid = '" + dr["Guid"] + "'").Length > 0)
                        {
                            DataRow Newdr = dt.NewRow();
                            Newdr[0] = dr["Guid"];
                            Newdr[1] = dr["ProjOrCostName"];
                            Newdr[2] = dr["Code"];
                            Newdr[3] = dr["OrderNum"];
                            dt.Rows.Add(Newdr);

                            setData(dr, DataEstimate, dt);
                        }
                    }
                }
            }
            return(dt);
        }