Esempio n. 1
0
        public static DataTable GenerateEmptyCostTargetDtl(string StartY, string EndY, EntityData entityTargetHis)
        {
            DataTable table2;

            try
            {
                EntityData costBudgetDtlByCode = CostBudgetDAO.GetCostBudgetDtlByCode("");
                DataTable  tbDtl = costBudgetDtlByCode.CurrentTable.Clone();
                AddColumnTargetHis(tbDtl, entityTargetHis);
                tbDtl.Columns.Add("BudgetMoneyHisHtml");
                tbDtl.Columns.Add("BudgetMoneyHtml");
                tbDtl.Columns.Add("BudgetValidMoney", typeof(decimal));
                tbDtl.Columns.Add("DescriptionHtml");
                tbDtl.Columns.Add("CostName");
                tbDtl.Columns.Add("SortID");
                tbDtl.Columns.Add("Deep", typeof(int));
                tbDtl.Columns.Add("ParentCode");
                tbDtl.Columns.Add("FullCode");
                tbDtl.Columns.Add("ChildCount", typeof(int));
                tbDtl.Columns.Add("IsLeafCBS", typeof(bool));
                tbDtl.Columns.Add("MeasurementUnit");
                AddMonthField(tbDtl, StartY, EndY, "BudgetMoney_");
                tbDtl.Columns.Add("PlanDataHtml");
                costBudgetDtlByCode.Dispose();
                table2 = tbDtl;
            }
            catch (Exception exception)
            {
                throw exception;
            }
            return(table2);
        }
Esempio n. 2
0
        public static DataTable CreateGroupAreaTable(string GroupCode, string ProjectCode, string CostBudgetBackupCode)
        {
            DataTable table2;

            try
            {
                EntityData data;
                string[]   arrColumnName = new string[] { "BuildingArea", "HouseCount", "HouseArea" };
                DataTable  table         = new DataTable("GroupArea");
                table.Columns.Add("GroupCode");
                foreach (string text in arrColumnName)
                {
                    table.Columns.Add(text, typeof(decimal));
                }
                DataRow row = table.NewRow();
                row["GroupCode"] = GroupCode;
                table.Rows.Add(row);
                if (CostBudgetBackupCode != "")
                {
                    data = CostBudgetDAO.GetCostBudgetBackupSetByGroupCode(CostBudgetBackupCode, GroupCode, true);
                }
                else
                {
                    data = CostBudgetDAO.GetV_CostBudgetSetByGroupCode(GroupCode, ProjectCode, CostBudgetRule.m_BaseSetType);
                }
                if (data.HasRecord())
                {
                    DataRow[] drs = data.CurrentTable.Select("PBSType = 'P'");
                    if (drs.Length > 0)
                    {
                        foreach (string text in arrColumnName)
                        {
                            row[text] = drs[0][text];
                        }
                    }
                    else
                    {
                        drs = data.CurrentTable.Select("PBSType = 'B'");
                        if (drs.Length > 0)
                        {
                            decimal[] numArray = MathRule.SumColumn(drs, arrColumnName);
                            int       index    = -1;
                            foreach (string text in arrColumnName)
                            {
                                index++;
                                row[text] = numArray[index];
                            }
                        }
                    }
                }
                data.Dispose();
                table2 = table;
            }
            catch (Exception exception)
            {
                throw exception;
            }
            return(table2);
        }
Esempio n. 3
0
 private void InitSetArray()
 {
     try
     {
         EntityData data = CostBudgetDAO.GetCostBudgetSetByGroupCode(this.GroupCode, this.ProjectCode, CostBudgetRule.m_BaseSetType);
         this.m_arrCostBudgetSetCode = new string[data.CurrentTable.Rows.Count];
         this.m_arrDyn = new CostBudgetDynamic[this.m_arrCostBudgetSetCode.Length];
         int index = -1;
         foreach (DataRow row in data.CurrentTable.Rows)
         {
             index++;
             this.m_arrCostBudgetSetCode[index] = row["CostBudgetSetCode"].ToString();
         }
         data.Dispose();
     }
     catch (Exception exception)
     {
         throw exception;
     }
 }
Esempio n. 4
0
 private void InitCostBudgetSet()
 {
     try
     {
         this.tbCostBudgetSet.Rows.Clear();
         this.tbCostBudgetSet.AcceptChanges();
         EntityData costBudgetSetByProjectCode = CostBudgetDAO.GetCostBudgetSetByProjectCode(this.ProjectCode);
         foreach (DataRow row2 in costBudgetSetByProjectCode.CurrentTable.Rows)
         {
             DataRow row = this.tbCostBudgetSet.NewRow();
             row["CostBudgetSetCode"] = row2["CostBudgetSetCode"];
             row["CostBudgetSetName"] = row2["CostBudgetSetName"];
             this.tbCostBudgetSet.Rows.Add(row);
         }
         costBudgetSetByProjectCode.Dispose();
     }
     catch (Exception exception)
     {
         throw exception;
     }
 }
Esempio n. 5
0
        public DataTable GenerateCurrent()
        {
            DataTable table2;

            try
            {
                if (this.entityTargetHis != null)
                {
                    this.entityTargetHis.Dispose();
                }
                if (this.IsShowTargetMoneyHis)
                {
                    this.entityTargetHis = CostBudgetRule.GetRelationCostBudget(this.ProjectCode, this.FirstCostBudgetCode, "1,2", this.CostBudgetCode);
                }
                DataTable  table       = CostBudgetPageRule.GenerateEmptyCostTargetDtl(this.StartY, this.EndY, this.entityTargetHis);
                EntityData allCBSBySet = CostBudgetRule.GetAllCBSBySet(this.ProjectCode, this.CostBudgetSetCode);
                if (allCBSBySet == null)
                {
                    return(table);
                }
                if (this.ShowCostCode != "")
                {
                    string    cBSFullCode = CBSRule.GetCBSFullCode(this.ShowCostCode);
                    DataRow[] rowArray    = allCBSBySet.CurrentTable.Select(string.Format("FullCode not like '{0}%'", cBSFullCode));
                    foreach (DataRow row in rowArray)
                    {
                        allCBSBySet.CurrentTable.Rows.Remove(row);
                    }
                    CostBudgetRule.ResetCBSDeep(allCBSBySet.CurrentTable);
                }
                DataRow row2 = null;
                if (this.ShowCostCode == "")
                {
                    row2 = table.NewRow();
                    row2["CostBudgetDtlCode"] = "R_0";
                    row2["CostCode"]          = row2["CostBudgetDtlCode"];
                    row2["CostName"]          = "合计";
                    row2["Deep"]       = 1;
                    row2["ParentCode"] = "";
                    row2["ChildCount"] = 1;
                    row2["IsExpand"]   = 1;
                    table.Rows.Add(row2);
                }
                int num = 0;
                foreach (DataRow row3 in allCBSBySet.CurrentTable.Rows)
                {
                    num--;
                    DataRow drDtl = table.NewRow();
                    drDtl["CostBudgetDtlCode"] = num;
                    CostBudgetPageRule.FillCostBudgetDtlCBSData(drDtl, row3);
                    if (row2 != null)
                    {
                        if (ConvertRule.ToInt(drDtl["Deep"]) == 1)
                        {
                            drDtl["ParentCode"] = row2["CostBudgetDtlCode"];
                        }
                        drDtl["Deep"] = ConvertRule.ToInt(drDtl["Deep"]) + 1;
                    }
                    else if (ConvertRule.ToInt(drDtl["Deep"]) == 1)
                    {
                        drDtl["ParentCode"] = "";
                    }
                    table.Rows.Add(drDtl);
                }
                EntityData validCostBudget = CostBudgetRule.GetValidCostBudget(this.CostBudgetSetCode, 1);
                EntityData costBudgetDtlByCostBudgetCode = null;
                if (validCostBudget.HasRecord())
                {
                    costBudgetDtlByCostBudgetCode = CostBudgetDAO.GetCostBudgetDtlByCostBudgetCode(validCostBudget.GetString("CostBudgetCode"));
                }
                EntityData data4 = CostBudgetDAO.GetCostBudgetDtlByCostBudgetCode(this.CostBudgetCode);
                EntityData costBudgetMonthByCostBudgetCode = CostBudgetDAO.GetCostBudgetMonthByCostBudgetCode(this.CostBudgetCode);
                foreach (DataRow row5 in table.Rows)
                {
                    DataRow[] rowArray2 = data4.CurrentTable.Select("CostCode='" + ConvertRule.ToString(row5["CostCode"]) + "'");
                    if (rowArray2.Length > 0)
                    {
                        row5["CostBudgetDtlCode"] = rowArray2[0]["CostBudgetDtlCode"];
                        row5["Price"]             = rowArray2[0]["Price"];
                        row5["Qty"]             = rowArray2[0]["Qty"];
                        row5["BudgetMoney"]     = rowArray2[0]["BudgetMoney"];
                        row5["IsExpand"]        = rowArray2[0]["IsExpand"];
                        row5["Description"]     = rowArray2[0]["Description"];
                        row5["DescriptionHtml"] = rowArray2[0]["Description"];
                    }
                    if (costBudgetDtlByCostBudgetCode != null)
                    {
                        DataRow[] rowArray3 = costBudgetDtlByCostBudgetCode.CurrentTable.Select("CostCode='" + ConvertRule.ToString(row5["CostCode"]) + "'");
                        if (rowArray3.Length > 0)
                        {
                            row5["BudgetValidMoney"] = rowArray3[0]["BudgetMoney"];
                        }
                    }
                    foreach (DataColumn column in table.Columns)
                    {
                        if (column.ColumnName.StartsWith("BudgetMoney_"))
                        {
                            string    text2     = column.ColumnName.Replace("BudgetMoney_", "");
                            string    val       = text2.Substring(0, 4);
                            string    text4     = text2.Substring(4, 2);
                            int       num2      = ConvertRule.ToInt(val);
                            int       num3      = ConvertRule.ToInt(text4);
                            DataRow[] rowArray4 = costBudgetMonthByCostBudgetCode.CurrentTable.Select("CostBudgetDtlCode = '" + ConvertRule.ToString(row5["CostBudgetDtlCode"]) + "' and IYear = " + num2.ToString() + " and IMonth = " + num3.ToString());
                            if (rowArray4.Length > 0)
                            {
                                row5[column.ColumnName] = rowArray4[0]["BudgetMoney"];
                            }
                        }
                    }
                    if (!this.IsModify)
                    {
                        row5["PlanDataHtml"] = CostBudgetPageRule.GenerateCostBudgetPlanDataHtml(row5, this.iStartY, this.iEndY, "BudgetMoney_");
                    }
                }
                allCBSBySet.Dispose();
                data4.Dispose();
                costBudgetMonthByCostBudgetCode.Dispose();
                validCostBudget.Dispose();
                if (costBudgetDtlByCostBudgetCode != null)
                {
                    costBudgetDtlByCostBudgetCode.Dispose();
                }
                if (row2 != null)
                {
                    DataRow[] drs           = table.Select("ParentCode = '" + row2["CostBudgetDtlCode"].ToString() + "'");
                    string[]  textArray     = new string[] { "BudgetMoney", "BudgetValidMoney" };
                    string[]  textArray2    = CostBudgetPageRule.BuildArrayFieldByMonth(this.StartY, this.EndY, "BudgetMoney_");
                    string[]  arrColumnName = ConvertRule.ArrayConcat(textArray, textArray2);
                    decimal[] numArray      = MathRule.SumColumn(drs, arrColumnName);
                    int       index         = -1;
                    foreach (string text5 in arrColumnName)
                    {
                        index++;
                        row2[text5] = numArray[index];
                    }
                    if (!this.IsModify)
                    {
                        row2["PlanDataHtml"] = CostBudgetPageRule.GenerateCostBudgetPlanDataHtml(row2, this.iStartY, this.iEndY, "BudgetMoney_");
                    }
                }
                table2 = table;
            }
            catch (Exception exception)
            {
                throw exception;
            }
            return(table2);
        }
Esempio n. 6
0
        public static DataSet GenerateEmptyCostBudgetDtl(string StartY, string EndY, EntityData entityTargetHis)
        {
            DataSet set2;

            try
            {
                DataSet    set = new DataSet();
                EntityData costBudgetDtlByCode = CostBudgetDAO.GetCostBudgetDtlByCode("");
                DataTable  tbDtl = costBudgetDtlByCode.CurrentTable.Clone();
                AddColumnTargetHis(tbDtl, entityTargetHis);
                tbDtl.Columns.Add("BudgetMoneyHisHtml");
                tbDtl.Columns.Add("BudgetMoneyHtml");
                tbDtl.Columns.Add("BudgetValidMoney", typeof(decimal));
                tbDtl.Columns.Add("DescriptionHtml");
                tbDtl.Columns.Add("CostName");
                tbDtl.Columns.Add("SortID");
                tbDtl.Columns.Add("Deep", typeof(int));
                tbDtl.Columns.Add("ParentCode");
                tbDtl.Columns.Add("FullCode");
                tbDtl.Columns.Add("ChildCount", typeof(int));
                tbDtl.Columns.Add("IsLeafCBS", typeof(bool));
                tbDtl.Columns.Add("MeasurementUnit");
                costBudgetDtlByCode.Dispose();
                set.Tables.Add(tbDtl);
                tbDtl.Columns.Add("BudgetChangeMoney", typeof(decimal));
                tbDtl.Columns.Add("BudgetChangeDescription");
                tbDtl.Columns.Add("BalanceContractMoney", typeof(decimal));
                tbDtl.Columns.Add("ContractCode");
                tbDtl.Columns.Add("ContractID");
                tbDtl.Columns.Add("ContractName");
                tbDtl.Columns.Add("SupplierCode");
                tbDtl.Columns.Add("SupplierName");
                tbDtl.Columns.Add("ContractTotalMoney", typeof(decimal));
                tbDtl.Columns.Add("ContractMoney", typeof(decimal));
                tbDtl.Columns.Add("ContractChangeMoney", typeof(decimal));
                tbDtl.Columns.Add("ContractApplyMoney", typeof(decimal));
                tbDtl.Columns.Add("ContractAccountMoney", typeof(decimal));
                tbDtl.Columns.Add("ContractBudgetBalance", typeof(decimal));
                tbDtl.Columns.Add("ContractPay", typeof(decimal));
                tbDtl.Columns.Add("ContractPayReal", typeof(decimal));
                tbDtl.Columns.Add("ContractPayBalance", typeof(decimal));
                tbDtl.Columns.Add("ContractPayRealBalance", typeof(decimal));
                tbDtl.Columns.Add("ContractPayPercent", typeof(decimal));
                tbDtl.Columns.Add("BuildingPrice", typeof(decimal));
                tbDtl.Columns.Add("HousePrice", typeof(decimal));
                tbDtl.Columns.Add("BudgetPrice", typeof(decimal));
                tbDtl.Columns.Add("ContractOriginalPrice", typeof(decimal));
                DataTable table = new DataTable("Month");
                set.Tables.Add(table);
                table.Columns.Add("CostCode");
                table.Columns.Add("FullCode");
                table.Columns.Add("RecordType");
                table.Columns.Add("IYear", typeof(int));
                table.Columns.Add("IMonth", typeof(int));
                table.Columns.Add("Money", typeof(decimal));
                DataTable table3 = new DataTable("Contract");
                set.Tables.Add(table3);
                table3.Columns.Add("ContractCode");
                table3.Columns.Add("AllContractCode");
                table3.Columns.Add("RecordType");
                table3.Columns.Add("ContractID");
                table3.Columns.Add("ContractName");
                table3.Columns.Add("SupplierCode");
                table3.Columns.Add("SupplierName");
                table3.Columns.Add("Description");
                table3.Columns.Add("DescriptionHtml");
                table3.Columns.Add("CostCode");
                table3.Columns.Add("FullCode");
                table3.Columns.Add("BudgetMoney", typeof(decimal));
                table3.Columns.Add("ContractTotalMoney", typeof(decimal));
                table3.Columns.Add("ContractMoney", typeof(decimal));
                table3.Columns.Add("ContractChangeMoney", typeof(decimal));
                table3.Columns.Add("ContractApplyMoney", typeof(decimal));
                table3.Columns.Add("ContractAccountMoney", typeof(decimal));
                table3.Columns.Add("ContractBudgetBalance", typeof(decimal));
                table3.Columns.Add("ContractPay", typeof(decimal));
                table3.Columns.Add("ContractPayReal", typeof(decimal));
                table3.Columns.Add("ContractPayBalance", typeof(decimal));
                table3.Columns.Add("ContractPayRealBalance", typeof(decimal));
                table3.Columns.Add("ContractPayPercent", typeof(decimal));
                table3.Columns.Add("BuildingPrice", typeof(decimal));
                table3.Columns.Add("HousePrice", typeof(decimal));
                table3.Columns.Add("BudgetPrice", typeof(decimal));
                table3.Columns.Add("ContractOriginalPrice", typeof(decimal));
                DataTable table4 = table3.Clone();
                table4.TableName = "NoContract";
                set.Tables.Add(table4);
                DataTable table5 = table3.Clone();
                table5.TableName = "Balance";
                set.Tables.Add(table5);
                DataTable table6 = new DataTable("ContractMonth");
                set.Tables.Add(table6);
                table6.Columns.Add("ContractCode");
                table6.Columns.Add("CostCode");
                table6.Columns.Add("FullCode");
                table6.Columns.Add("RecordType");
                table6.Columns.Add("IYear", typeof(int));
                table6.Columns.Add("IMonth", typeof(int));
                table6.Columns.Add("Money", typeof(decimal));
                DataTable table7 = CostBudgetDAO.GetCostBudgetContractByCode("").CurrentTable.Clone();
                set.Tables.Add(table7);
                set2 = set;
            }
            catch (Exception exception)
            {
                throw exception;
            }
            return(set2);
        }
Esempio n. 7
0
 private void FillCostTargetHisHtml()
 {
     try
     {
         if (this.entityTargetHis != null)
         {
             string    text2;
             ArrayList list = new ArrayList();
             foreach (DataRowView view in this.dvTargetHis)
             {
                 DataRow row  = view.Row;
                 string  text = ConvertRule.ToString(row["VerID"]);
                 if (text != "")
                 {
                     list.Add(text);
                     text2 = "BudgetMoneyHis_" + text;
                     EntityData costBudgetDtlByCostBudgetCode = CostBudgetDAO.GetCostBudgetDtlByCostBudgetCode(row["CostBudgetCode"].ToString());
                     if (costBudgetDtlByCostBudgetCode.HasRecord())
                     {
                         foreach (DataRow row2 in this.tb.Rows)
                         {
                             DataRow[] rowArray = costBudgetDtlByCostBudgetCode.CurrentTable.Select("CostCode='" + ConvertRule.ToString(row2["CostCode"]) + "'");
                             if (rowArray.Length > 0)
                             {
                                 row2[text2] = rowArray[0]["BudgetMoney"];
                             }
                         }
                     }
                     costBudgetDtlByCostBudgetCode.Dispose();
                 }
             }
             if (this.tb.Rows.Count > 0)
             {
                 DataRow   row3          = this.tb.Rows[0];
                 DataRow[] drs           = this.tb.Select("ParentCode = '" + row3["CostBudgetDtlCode"].ToString() + "'");
                 string[]  arrColumnName = new string[list.Count];
                 int       index         = -1;
                 foreach (string text in list)
                 {
                     index++;
                     arrColumnName[index] = "BudgetMoneyHis_" + text;
                 }
                 decimal[] numArray = MathRule.SumColumn(drs, arrColumnName);
                 int       num2     = -1;
                 foreach (string text3 in arrColumnName)
                 {
                     num2++;
                     row3[text3] = numArray[num2];
                 }
             }
             foreach (DataRow row2 in this.tb.Rows)
             {
                 string text4 = "";
                 foreach (string text in list)
                 {
                     text2 = "BudgetMoneyHis_" + text;
                     text4 = text4 + string.Format("<td align=right nowrap title='{1}'>{0}</td>", CostBudgetPageRule.GetMoneyShowString(row2[text2], this.m_MoneyUnit), CostBudgetPageRule.GetWanDecimalShowHint(row2[text2]));
                 }
                 row2["BudgetMoneyHisHtml"] = text4;
             }
         }
         else
         {
             foreach (DataRow row2 in this.tb.Rows)
             {
                 row2["BudgetMoneyHisHtml"] = "";
             }
         }
     }
     catch (Exception exception)
     {
         throw exception;
     }
 }
Esempio n. 8
0
        public DataTable Generate()
        {
            DataTable tb;

            try
            {
                if (this.ShowTargetHis)
                {
                    this.LoadTargetHis();
                }
                this.tb = CostBudgetPageRule.GenerateEmptyCostTargetDtl(this.StartY, this.EndY, this.entityTargetHis);
                EntityData costBudgetDtlByCostBudgetCode   = CostBudgetDAO.GetCostBudgetDtlByCostBudgetCode(this.CostBudgetCode);
                EntityData costBudgetMonthByCostBudgetCode = CostBudgetDAO.GetCostBudgetMonthByCostBudgetCode(this.CostBudgetCode);
                EntityData allCBSBySet = CostBudgetRule.GetAllCBSBySet(this.ProjectCode, this.CostBudgetSetCode);
                DataRow    row         = this.tb.NewRow();
                row["CostBudgetDtlCode"] = "R_0";
                row["CostCode"]          = row["CostBudgetDtlCode"];
                row["CostName"]          = "合计";
                row["Deep"]       = 1;
                row["ParentCode"] = "";
                row["ChildCount"] = 1;
                row["IsExpand"]   = 1;
                this.tb.Rows.Add(row);
                foreach (DataRow row2 in costBudgetDtlByCostBudgetCode.CurrentTable.Rows)
                {
                    string  text  = ConvertRule.ToString(row2["CostBudgetDtlCode"]);
                    DataRow drDst = this.tb.NewRow();
                    ConvertRule.DataRowCopy(row2, drDst, costBudgetDtlByCostBudgetCode.CurrentTable, this.tb);
                    DataRow[] rowArray = allCBSBySet.CurrentTable.Select("CostCode='" + ConvertRule.ToString(drDst["CostCode"]) + "'");
                    if (rowArray.Length > 0)
                    {
                        CostBudgetPageRule.FillCostBudgetDtlCBSData(drDst, rowArray[0]);
                    }
                    drDst["Deep"] = ConvertRule.ToInt(drDst["Deep"]) + 1;
                    if (ConvertRule.ToInt(drDst["Deep"]) == (ConvertRule.ToInt(row["Deep"]) + 1))
                    {
                        drDst["ParentCode"] = row["CostBudgetDtlCode"];
                    }
                    foreach (DataColumn column in this.tb.Columns)
                    {
                        if (column.ColumnName.StartsWith("BudgetMoney_"))
                        {
                            string    text2     = column.ColumnName.Replace("BudgetMoney_", "");
                            string    val       = text2.Substring(0, 4);
                            string    text4     = text2.Substring(4, 2);
                            int       num       = ConvertRule.ToInt(val);
                            int       num2      = ConvertRule.ToInt(text4);
                            DataRow[] rowArray2 = costBudgetMonthByCostBudgetCode.CurrentTable.Select("CostBudgetDtlCode = '" + text + "' and IYear = " + num.ToString() + " and IMonth = " + num2.ToString());
                            if (rowArray2.Length > 0)
                            {
                                drDst[column.ColumnName] = rowArray2[0]["BudgetMoney"];
                            }
                        }
                    }
                    drDst["PlanDataHtml"] = CostBudgetPageRule.GenerateCostBudgetPlanDataHtml(drDst, this.iStartY, this.iEndY, "BudgetMoney_");
                    this.tb.Rows.Add(drDst);
                }
                costBudgetDtlByCostBudgetCode.Dispose();
                costBudgetMonthByCostBudgetCode.Dispose();
                allCBSBySet.Dispose();
                DataRow[] drs           = this.tb.Select("ParentCode = '" + row["CostBudgetDtlCode"].ToString() + "'");
                string[]  textArray     = new string[] { "BudgetMoney" };
                string[]  textArray2    = CostBudgetPageRule.BuildArrayFieldByMonth(this.StartY, this.EndY, "BudgetMoney_");
                string[]  arrColumnName = ConvertRule.ArrayConcat(textArray, textArray2);
                decimal[] numArray      = MathRule.SumColumn(drs, arrColumnName);
                int       index         = -1;
                foreach (string text5 in arrColumnName)
                {
                    index++;
                    row[text5] = numArray[index];
                }
                row["PlanDataHtml"] = CostBudgetPageRule.GenerateCostBudgetPlanDataHtml(row, this.iStartY, this.iEndY, "BudgetMoney_");
                CostBudgetPageRule.SetColumnTargetHis(this.tb, this.entityTargetHis);
                this.FillCostTargetHisHtml();
                this.GenerateTargetHisHead();
                tb = this.tb;
            }
            catch (Exception exception)
            {
                throw exception;
            }
            return(tb);
        }