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); }
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; } }
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; }
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"]; }
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(); }
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; }
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 }