コード例 #1
0
        public void TestSetup()
        {
            busChnageInfo     = new BChangeOrganicInfo();
            person_testObject = new Person();
            infoProxy         = new OrganicInfoProxy();
            errorList         = new List <ChangeInfoErrorProxy>();

            workgrpTA.Insert("WorkGroupTest1", "0-0", 0);
            workgrpTA.Insert("WorkGroupTest2", "0-1", 0);

            DatabaseGateway.TA_WorkGroupDataTable             table = new DatabaseGateway.TA_WorkGroupDataTable();
            DatabaseGateway.TA_CalculationRangeGroupDataTable dateRangeGroupTable = new DatabaseGateway.TA_CalculationRangeGroupDataTable();
            DatabaseGateway.TA_RuleCategoryDataTable          ruleTable           = new DatabaseGateway.TA_RuleCategoryDataTable();

            workgrpTA.FillByName(table, "WorkGroupTest1");
            ADOWorkGroup1.ID         = Convert.ToInt32(table.Rows[0]["workgroup_ID"]);
            ADOWorkGroup1.Name       = Convert.ToString(table.Rows[0]["workgroup_Name"]);
            ADOWorkGroup1.CustomCode = Convert.ToString(table.Rows[0]["workgroup_CustomCode"]);

            workgrpTA.FillByName(table, "WorkGroupTest2");
            ADOWorkGroup2.ID         = Convert.ToInt32(table.Rows[0]["workgroup_ID"]);
            ADOWorkGroup2.Name       = Convert.ToString(table.Rows[0]["workgroup_Name"]);
            ADOWorkGroup2.CustomCode = Convert.ToString(table.Rows[0]["workgroup_CustomCode"]);

            assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson1.ID, new DateTime(2011, 01, 01));

            dateRangeGroupTA.Insert("RangeGroup1", "", 1);
            dateRangeGroupTA.Insert("RangeGroup2", "", 1);

            dateRangeGroupTA.FillByGroupName(dateRangeGroupTable, "RangeGroup1");
            ADOGroup1.ID          = Convert.ToDecimal(dateRangeGroupTable.Rows[0]["CalcRangeGroup_ID"]);
            ADOGroup1.Name        = Convert.ToString(dateRangeGroupTable.Rows[0]["CalcRangeGroup_Name"]);
            ADOGroup1.Description = Convert.ToString(dateRangeGroupTable.Rows[0]["CalcRangeGroup_Des"]);

            dateRangeGroupTA.FillByGroupName(dateRangeGroupTable, "RangeGroup2");

            ADOGroup2.ID          = Convert.ToDecimal(dateRangeGroupTable.Rows[0]["CalcRangeGroup_ID"]);
            ADOGroup2.Name        = Convert.ToString(dateRangeGroupTable.Rows[0]["CalcRangeGroup_Name"]);
            ADOGroup2.Description = Convert.ToString(dateRangeGroupTable.Rows[0]["CalcRangeGroup_Des"]);

            assinTA.Insert(ADOPerson1.ID, ADOGroup1.ID, new DateTime(2011, 01, 01));

            ruleCatTA.Insert("RuleGroupTest1", "0000", false, "00-00test1");
            ruleCatTA.Insert("RuleGroupTest2", "0000", false, "00-00test1");

            ruleTable        = ruleCatTA.GetDataByName("RuleGroupTest1");
            ADORuleCat1.ID   = (Decimal)ruleTable[0]["RuleCat_ID"];
            ADORuleCat1.Name = (String)ruleTable[0]["RuleCat_Name"];

            ruleTable        = ruleCatTA.GetDataByName("RuleGroupTest2");
            ADORuleCat2.ID   = (Decimal)ruleTable[0]["RuleCat_ID"];
            ADORuleCat2.Name = (String)ruleTable[0]["RuleCat_Name"];

            ruleTA.Insert(0001, "", "", "", null, false, ADORuleCat1.ID, Utility.ToInteger(ruleTypeTA.GetData().Rows[0][0]), 0);
            ruleTA.Insert(0001, "", "", "", null, false, ADORuleCat2.ID, Utility.ToInteger(ruleTypeTA.GetData().Rows[0][0]), 0);

            prsRleCatAsgTA.Insert(ADOPerson1.ID, ADORuleCat2.ID, "2011/01/01", "2011/06/01", null);
        }
コード例 #2
0
        public void TestSetup()
        {
            try
            {
                assignRuleParameter_testObject = new AssignRuleParameter();
                int ruleTypeID = Convert.ToInt32(new TA_RuleTypeTableAdapter().GetData().Rows[0]["RuleType_ID"]);
                catTA.Insert("TestCategory", "", false, "00-00test1");
                DatabaseGateway.TA_RuleCategoryDataTable cat = new DatabaseGateway.TA_RuleCategoryDataTable();
                cat             = catTA.GetDataByName("TestCategory");
                ADORuleCat.ID   = Convert.ToInt32(cat.Rows[0]["ruleCat_ID"]);
                ADORuleCat.Name = Convert.ToString(cat.Rows[0]["ruleCat_Name"]);

                ruleTA.Insert(1033, "a", "a", "a", 67, false, ADORuleCat.ID, ruleTypeID, 0);
                DatabaseGateway.TA_RuleDataTable ruleTable = new DatabaseGateway.TA_RuleDataTable();
                ruleTable              = ruleTA.GetByIdentifierCode(1033);
                ADORule.ID             = Convert.ToInt32(ruleTable.Rows[0]["rule_ID"]);
                ADORule.IdentifierCode = Convert.ToInt32(ruleTable.Rows[0]["rule_IdentifierCode"]);
                ADORule.TemplateId     = Convert.ToInt32(ruleTable.Rows[0]["rule_RuleTmpId"]);
                ADORule.CategoryId     = Convert.ToInt32(ruleTable.Rows[0]["rule_RuleCategoryId"]);

                assignRuleTA.Insert(new DateTime(2000, 1, 1), new DateTime(2001, 1, 1), ADORule.ID);
                assignRuleTA.Insert(new DateTime(2002, 1, 1), new DateTime(2003, 1, 1), ADORule.ID);
                DatabaseGateway.TA_AssignRuleParameterDataTable assignTable = new DatabaseGateway.TA_AssignRuleParameterDataTable();
                assignTable = assignRuleTA.GetDataByRuleID(ADORule.ID);

                ADOAssignRuleParam1.ID       = Convert.ToInt32(assignTable.Rows[0]["AsgRuleParam_ID"]);
                ADOAssignRuleParam1.FromDate = Convert.ToDateTime(assignTable.Rows[0]["AsgRuleParam_FromDate"]);
                ADOAssignRuleParam1.ToDate   = Convert.ToDateTime(assignTable.Rows[0]["AsgRuleParam_ToDate"]);

                ADOAssignRuleParam2.ID       = Convert.ToInt32(assignTable.Rows[1]["AsgRuleParam_ID"]);
                ADOAssignRuleParam2.FromDate = Convert.ToDateTime(assignTable.Rows[1]["AsgRuleParam_FromDate"]);
                ADOAssignRuleParam2.ToDate   = Convert.ToDateTime(assignTable.Rows[1]["AsgRuleParam_ToDate"]);

                parameterTA.Insert(ADOAssignRuleParam1.ID, "Param1", "0", 0, "");
                parameterTA.Insert(ADOAssignRuleParam1.ID, "Param2", "0", 0, "");

                DatabaseGateway.TA_RuleParameterDataTable paramTable = new DatabaseGateway.TA_RuleParameterDataTable();
                parameterTA.FillByAssignID(paramTable, ADOAssignRuleParam1.ID);

                ADOParameter1.ID    = Convert.ToInt32(paramTable.Rows[0]["RuleParam_ID"]);
                ADOParameter1.Value = Convert.ToString(paramTable.Rows[0]["RuleParam_Value"]);
                ADOParameter1.Name  = Convert.ToString(paramTable.Rows[0]["RuleParam_Name"]);
                ADOParameter1.Title = Convert.ToString(paramTable.Rows[0]["RuleParam_Title"]);
                ADOParameter1.Type  = (RuleParamType)Convert.ToInt32(paramTable.Rows[0]["RuleParam_Type"]);

                ADOParameter2.ID    = Convert.ToInt32(paramTable.Rows[1]["RuleParam_ID"]);
                ADOParameter2.Value = Convert.ToString(paramTable.Rows[1]["RuleParam_Value"]);
                ADOParameter2.Name  = Convert.ToString(paramTable.Rows[1]["RuleParam_Name"]);
                ADOParameter2.Title = Convert.ToString(paramTable.Rows[1]["RuleParam_Title"]);
                ADOParameter2.Type  = (RuleParamType)Convert.ToInt32(paramTable.Rows[1]["RuleParam_Type"]);

                businessAssignRule = new BRuleParameter(ADORule.TemplateId, ADORule.CategoryId);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #3
0
        public void TestSetup()
        {
            busLeave          = new BLeaveBudget();
            budget_testObject = new Budget();

            ruleCatTA.Insert("RuleCategory000", "0000", false, "00-00test1");
            table           = ruleCatTA.GetDataByName("RuleCategory000");
            AdoRuleCat.ID   = (Decimal)table[0]["RuleCat_ID"];
            AdoRuleCat.Name = (String)table[0]["RuleCat_Name"];

            budgetTA.Insert(Utility.ToMildiDate("1390/01/01"), 10, 10, AdoRuleCat.ID, (int)BudgetType.Usual, "");
            DatabaseGateway.TA_BudgetDataTable budgetTable = budgetTA.GetDataByRuleCategoryId(AdoRuleCat.ID);

            ADOBudget1.ID     = ((DatabaseGateway.TA_BudgetRow)budgetTable.Rows[0]).Budget_ID;
            ADOBudget1.Day    = ((DatabaseGateway.TA_BudgetRow)budgetTable.Rows[0]).Budget_Day;
            ADOBudget1.Minute = ((DatabaseGateway.TA_BudgetRow)budgetTable.Rows[0]).Budget_Minute;
            ADOBudget1.Date   = ((DatabaseGateway.TA_BudgetRow)budgetTable.Rows[0]).Budget_Date;
        }
コード例 #4
0
        public void TestSetup()
        {
            assign_testObject = new PersonRuleCatAssignment();
            bussAssign        = new BAssignRule(SysLanguageResource.Parsi);

            groupTA.Insert("RuleGroup", "", false, "00-00test1");
            DatabaseGateway.TA_RuleCategoryDataTable groupTable = new DatabaseGateway.TA_RuleCategoryDataTable();
            groupTable = groupTA.GetDataByName("RuleGroup");

            ADORuleCategory.ID   = Convert.ToDecimal(groupTable.Rows[0]["RuleCat_ID"]);
            ADORuleCategory.Name = Convert.ToString(groupTable.Rows[0]["RuleCat_Name"]);

            //assingTA.Insert(ADOPerson1.ID, ADORuleCategory.ID, new DateTime(2010, 2, 14).ToShortDateString(), new DateTime(2012, 9, 14).ToShortDateString(), null);
            //assingTA.Insert(ADOPerson1.ID, ADORuleCategory.ID, new DateTime(2005, 5, 14).ToShortDateString(), new DateTime(2007, 11, 5).ToShortDateString(), null);
            //assingTA.Insert(ADOPerson1.ID, ADORuleCategory.ID, new DateTime(2008, 3, 1).ToShortDateString(), new DateTime(2012, 9, 14).ToShortDateString(), null);

            assingTA.Insert(ADOPerson1.ID, ADORuleCategory.ID, Utility.ToString(new DateTime(2005, 2, 14)), Utility.ToString(new DateTime(2007, 9, 14)), null);
            assingTA.Insert(ADOPerson1.ID, ADORuleCategory.ID, Utility.ToString(new DateTime(2008, 5, 14)), Utility.ToString(new DateTime(2010, 11, 5)), null);
            assingTA.Insert(ADOPerson1.ID, ADORuleCategory.ID, Utility.ToString(new DateTime(2010, 11, 6)), Utility.ToString(new DateTime(2012, 9, 14)), null);


            assingTA.Insert(ADOPerson2.ID, ADORuleCategory.ID, Utility.ToString(new DateTime(2007, 1, 1)), Utility.ToString(new DateTime(2008, 1, 1)), null);
            assingTA.Insert(ADOPerson2.ID, ADORuleCategory.ID, Utility.ToString(new DateTime(2008, 1, 2)), Utility.ToString(new DateTime(2009, 1, 1)), null);

            DatabaseGateway.TA_PersonRuleCategoryAssignmentDataTable table = new DatabaseGateway.TA_PersonRuleCategoryAssignmentDataTable();
            assingTA.FillByFilter(table, ADOPerson1.ID, ADORuleCategory.ID);

            ADOAssign1.ID       = (decimal)table.Rows[0]["PrsRulCatAsg_ID"];
            ADOAssign1.FromDate = (string)table.Rows[0]["PrsRulCatAsg_FromDate"];
            ADOAssign1.ToDate   = (string)table.Rows[0]["PrsRulCatAsg_ToDate"];

            table = new DatabaseGateway.TA_PersonRuleCategoryAssignmentDataTable();
            assingTA.FillByFilter(table, ADOPerson2.ID, ADORuleCategory.ID);

            ADOAssign2.ID       = (decimal)table.Rows[0]["PrsRulCatAsg_ID"];
            ADOAssign2.FromDate = (string)table.Rows[0]["PrsRulCatAsg_FromDate"];
            ADOAssign2.ToDate   = (string)table.Rows[0]["PrsRulCatAsg_ToDate"];

            ADOAssign3.ID       = (decimal)table.Rows[1]["PrsRulCatAsg_ID"];
            ADOAssign3.FromDate = (string)table.Rows[1]["PrsRulCatAsg_FromDate"];
            ADOAssign3.ToDate   = (string)table.Rows[1]["PrsRulCatAsg_ToDate"];
        }
コード例 #5
0
        public void TestSetup()
        {
            businessCategory   = new BRuleCategory();
            ruleCat_testObject = new RuleCategory();

            Convert.ToInt32(personTA.InsertQuery("0000", "Ali", true, null));
            int personId = Convert.ToInt32(personTA.GetDataByBarcode("0000").Rows[0]["prs_ID"]);


            ruleCatTA.Insert("دسته قانون000", "0000", false, "00-00test1");
            table           = ruleCatTA.GetDataByName("دسته قانون000");
            AdoRuleCat.ID   = (Decimal)table[0]["RuleCat_ID"];
            AdoRuleCat.Name = (String)table[0]["RuleCat_Name"];

            prsRleCatAsgTA.Insert(personId, AdoRuleCat.ID, DateTime.Now.ToShortDateString(), DateTime.Now.ToShortDateString(), DateTime.Now);

            ruleCAtPartTA.Insert(businessCategory.GetRoot().ID, AdoRuleCat.ID, true);

            ClearSession();
        }
コード例 #6
0
        public void TestSetup()
        {
            return;

            busPerson         = new BPerson(SysLanguageResource.English, LocalLanguageResource.English);
            searchTool        = new BPerson();
            person_testObject = new Person();

            workgrpTA.Insert("WorkGroupTest1", "0-0", 0);
            workgrpTA.Insert("WorkGroupTest2", "0-1", 0);
            DatabaseGateway.TA_WorkGroupDataTable table = new DatabaseGateway.TA_WorkGroupDataTable();
            workgrpTA.FillByName(table, "WorkGroupTest1");
            ADOWorkGroup1.ID         = Convert.ToInt32(table.Rows[0]["workgroup_ID"]);
            ADOWorkGroup1.Name       = Convert.ToString(table.Rows[0]["workgroup_Name"]);
            ADOWorkGroup1.CustomCode = Convert.ToString(table.Rows[0]["workgroup_CustomCode"]);

            workgrpTA.FillByName(table, "WorkGroupTest2");
            ADOWorkGroup2.ID         = Convert.ToInt32(table.Rows[0]["workgroup_ID"]);
            ADOWorkGroup2.Name       = Convert.ToString(table.Rows[0]["workgroup_Name"]);
            ADOWorkGroup2.CustomCode = Convert.ToString(table.Rows[0]["workgroup_CustomCode"]);

            assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2007, 4, 5));
            assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2012, 5, 5));
            assignWorkGroupTA.Insert(ADOWorkGroup2.ID, ADOPerson2.ID, new DateTime(2010, 11, 6));
            assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2009, 6, 15));
            assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2010, 8, 5));

            groupTA.Insert("RangeGroup1", "", 1);
            groupTA.Insert("RangeGroup2", "", 1);
            DatabaseGateway.TA_CalculationRangeGroupDataTable groupTable = new DatabaseGateway.TA_CalculationRangeGroupDataTable();
            groupTA.FillByGroupName(groupTable, "RangeGroup1");

            ADOGroup1.ID          = Convert.ToDecimal(groupTable.Rows[0]["CalcRangeGroup_ID"]);
            ADOGroup1.Name        = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Name"]);
            ADOGroup1.Description = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Des"]);

            groupTA.FillByGroupName(groupTable, "RangeGroup2");

            ADOGroup2.ID          = Convert.ToDecimal(groupTable.Rows[0]["CalcRangeGroup_ID"]);
            ADOGroup2.Name        = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Name"]);
            ADOGroup2.Description = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Des"]);

            assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2010, 2, 14));
            assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2005, 5, 14));
            assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2007, 11, 5));
            assinTA.Insert(ADOPerson2.ID, ADOGroup2.ID, new DateTime(2010, 9, 14));
            assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2012, 9, 14));
            assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2008, 3, 1));

            ruleCatTA.Insert("RuleGroupTest1", "0000", false, "00-00test1");
            ruleCatTA.Insert("RuleGroupTest2", "0000", false, "00-00test1");

            DatabaseGateway.TA_RuleCategoryDataTable ruleTable = ruleCatTA.GetDataByName("RuleGroupTest1");
            ADORuleCat1.ID   = (Decimal)ruleTable[0]["RuleCat_ID"];
            ADORuleCat1.Name = (String)ruleTable[0]["RuleCat_Name"];

            ruleTable        = ruleCatTA.GetDataByName("RuleGroupTest2");
            ADORuleCat2.ID   = (Decimal)ruleTable[0]["RuleCat_ID"];
            ADORuleCat2.Name = (String)ruleTable[0]["RuleCat_Name"];

            prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2005/05/15", "2007/05/08", null);
            prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2008/01/01", "2010/01/01", null);
            prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2010/01/02", "2010/12/01", null);
            prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2010/12/02", "2011/03/01", null);
            prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat2.ID, "2011/03/02", "2015/03/01", null);

            validationGroupTA.InsertQuery("TestGroup00");
            DatabaseGateway.TA_UIValidationGroupDataTable uiValGroupTable = validationGroupTA.GetDataByName("TestGroup00");
            ADOUIValidationGroup1.ID = (uiValGroupTable.Rows[0] as DatabaseGateway.TA_UIValidationGroupRow).UIValGrp_ID;
        }
コード例 #7
0
        public void TestSetup()
        {
            searchTool        = new BPerson();
            bPerson           = new BPerson();
            person_testObject = new Person();

            #region Workgroup
            workgrpTA.Insert("WorkGroupTest1", "0-0", 0);
            workgrpTA.Insert("WorkGroupTest2", "0-1", 0);
            DatabaseGateway.TA_WorkGroupDataTable table = new DatabaseGateway.TA_WorkGroupDataTable();
            workgrpTA.FillByName(table, "WorkGroupTest1");
            ADOWorkGroup1.ID         = Convert.ToInt32(table.Rows[0]["workgroup_ID"]);
            ADOWorkGroup1.Name       = Convert.ToString(table.Rows[0]["workgroup_Name"]);
            ADOWorkGroup1.CustomCode = Convert.ToString(table.Rows[0]["workgroup_CustomCode"]);

            workgrpTA.FillByName(table, "WorkGroupTest2");
            ADOWorkGroup2.ID         = Convert.ToInt32(table.Rows[0]["workgroup_ID"]);
            ADOWorkGroup2.Name       = Convert.ToString(table.Rows[0]["workgroup_Name"]);
            ADOWorkGroup2.CustomCode = Convert.ToString(table.Rows[0]["workgroup_CustomCode"]);


            assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson1.ID, new DateTime(2007, 4, 5));
            assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2007, 4, 5));
            assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2012, 5, 5));
            assignWorkGroupTA.Insert(ADOWorkGroup2.ID, ADOPerson2.ID, new DateTime(2010, 11, 6));
            assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2009, 6, 15));
            assignWorkGroupTA.Insert(ADOWorkGroup1.ID, ADOPerson2.ID, new DateTime(2010, 8, 5));
            #endregion

            #region Calculation DateRange
            groupTA.Insert("RangeGroup1", "", 1);
            groupTA.Insert("RangeGroup2", "", 1);
            DatabaseGateway.TA_CalculationRangeGroupDataTable groupTable = new DatabaseGateway.TA_CalculationRangeGroupDataTable();
            groupTA.FillByGroupName(groupTable, "RangeGroup1");

            ADOGroup1.ID          = Convert.ToDecimal(groupTable.Rows[0]["CalcRangeGroup_ID"]);
            ADOGroup1.Name        = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Name"]);
            ADOGroup1.Description = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Des"]);

            groupTA.FillByGroupName(groupTable, "RangeGroup2");

            ADOGroup2.ID          = Convert.ToDecimal(groupTable.Rows[0]["CalcRangeGroup_ID"]);
            ADOGroup2.Name        = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Name"]);
            ADOGroup2.Description = Convert.ToString(groupTable.Rows[0]["CalcRangeGroup_Des"]);

            assinTA.Insert(ADOPerson1.ID, ADOGroup1.ID, new DateTime(2010, 2, 14));
            assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2010, 2, 14));
            assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2005, 5, 14));
            assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2007, 11, 5));
            assinTA.Insert(ADOPerson2.ID, ADOGroup2.ID, new DateTime(2010, 9, 14));
            assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2012, 9, 14));
            assinTA.Insert(ADOPerson2.ID, ADOGroup1.ID, new DateTime(2008, 3, 1));
            #endregion

            #region RuleGroup

            ruleCatTA.Insert("RuleGroupTest1", "0000", false, "00-00test1");
            ruleCatTA.Insert("RuleGroupTest2", "0000", false, "00-00test1");

            DatabaseGateway.TA_RuleCategoryDataTable ruleTable = ruleCatTA.GetDataByName("RuleGroupTest1");
            ADORuleCat1.ID   = (Decimal)ruleTable[0]["RuleCat_ID"];
            ADORuleCat1.Name = (String)ruleTable[0]["RuleCat_Name"];

            ruleTable        = ruleCatTA.GetDataByName("RuleGroupTest2");
            ADORuleCat2.ID   = (Decimal)ruleTable[0]["RuleCat_ID"];
            ADORuleCat2.Name = (String)ruleTable[0]["RuleCat_Name"];

            prsRleCatAsgTA.Insert(ADOPerson1.ID, ADORuleCat1.ID, "2005/05/15", "2007/05/08", null);
            prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2005/05/15", "2007/05/08", null);
            prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2008/01/01", "2010/01/01", null);
            prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2010/01/01", "2010/12/01", null);
            prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat1.ID, "2010/12/01", "2011/03/01", null);
            prsRleCatAsgTA.Insert(ADOPerson2.ID, ADORuleCat2.ID, "2011/03/02", "2015/03/01", null);

            #endregion

            #region OrganizationUnit
            DatabaseGateway.TA_OrganizationUnitDataTable organtable = organTA.GetDataByParent();
            ADOOrganParent.ID         = Convert.ToInt32(organtable.Rows[0]["organ_ID"]);
            ADOOrganParent.CustomCode = Convert.ToString(organtable.Rows[0]["organ_CustomCode"]);

            organTA.Insert("TestLevel2_1", "0-1", ADOPerson2.ID, ADOOrganParent.ID, String.Format(",{0},", ADOOrganParent.ID));
            organtable          = organTA.GetDataByCustomCode("0-1");
            ADOOrgan.ID         = Convert.ToInt32(organtable.Rows[0]["organ_ID"]);
            ADOOrgan.ParentID   = Convert.ToInt32(organtable.Rows[0]["organ_ParentID"]);
            ADOOrgan.Name       = Convert.ToString(organtable.Rows[0]["organ_Name"]);
            ADOOrgan.CustomCode = Convert.ToString(organtable.Rows[0]["organ_CustomCode"]);
            ADOOrgan.PersonID   = Convert.ToInt32(organtable.Rows[0]["organ_PersonID"]);
            #endregion

            #region Manager
            managerTA.Insert(ADOPerson1.ID, null);
            managerTA.Insert(null, ADOOrgan.ID);

            DatasetGatewayWorkFlow.TA_ManagerDataTable managetTable = new DatasetGatewayWorkFlow.TA_ManagerDataTable();
            managerTA.FillByPersonID(managetTable, ADOPerson1.ID);
            ADOManager1.ID     = Convert.ToInt32(managetTable.Rows[0]["MasterMng_ID"]);
            ADOManager1.Person = ADOPerson1;

            managerTA.FillByOrganID(managetTable, ADOOrgan.ID);
            ADOManager2.ID = Convert.ToInt32(managetTable.Rows[0]["MasterMng_ID"]);
            ADOManager2.OrganizationUnit = ADOOrgan;
            #endregion
        }