public void Test_DeleteVagonsToNaturList() { RC_VagonsOperations vo = new RC_VagonsOperations(); int nat = -777; DateTime dt_amkr = DateTime.Now; VAGON_OPERATIONS vo1 = new VAGON_OPERATIONS() { id_oper = 0, dt_amkr = dt_amkr, n_natur = nat, id_vagon = 889213, id_stat = 4, dt_from_stat = null, dt_on_stat = DateTime.Now, id_way = 51, dt_from_way = null, dt_on_way = DateTime.Now, num_vag_on_way = 0, is_present = 0, id_locom = null, id_locom2 = null, id_cond2 = null, id_gruz = null, id_gruz_amkr = null, id_shop_gruz_for = null, weight_gruz = null, id_tupik = null, id_nazn_country = null, id_gdstait = null, id_cond = null, note = null, is_hist = 0, id_oracle = null, lock_id_way = null, lock_order = null, lock_side = null, lock_id_locom = null, st_lock_id_stat = null, st_lock_order = null, st_lock_train = null, st_lock_side = null, st_gruz_front = null, st_shop = null, oracle_k_st = null, st_lock_locom1 = null, st_lock_locom2 = null, id_oper_parent = null, grvu_SAP = null, ngru_SAP = null, id_ora_23_temp = null, edit_user = null, edit_dt = null, IDSostav = 0, }; int res_ov1 = vo.SaveVagonsOperations(vo1); Test_RC_VagonsOperations(res_ov1); Console.WriteLine("Удалено : {0}", vo.DeleteVagonsToNaturList(nat, dt_amkr)); }
public void Test_RC_VagonsOperations() { RC_VagonsOperations vo = new RC_VagonsOperations(); foreach (VAGON_OPERATIONS t in vo.GetVagonsOperations()) { WL(t); } }
public void Test_RC_VagonsOperationsToInsertMT(int id_sostav) { RC_VagonsOperations vo = new RC_VagonsOperations(); int count = 0; foreach (VAGON_OPERATIONS t in vo.GetVagonsOperationsToInsertMT(id_sostav)) { WL(t); count++; } Console.WriteLine("Количество строк: {0}", count); }
public void Test_RC_VagonsOperationsToNatur(int natur, DateTime dt_amkr) { RC_VagonsOperations vo = new RC_VagonsOperations(); int count = 0; foreach (VAGON_OPERATIONS t in vo.GetVagonsOperationsToNatur(natur, dt_amkr)) { WL(t); count++; } Console.WriteLine("Количество строк: {0}", count); }
public void Test_RC_VagonsOperations_UpdateVagon() { RC_VagonsOperations vo = new RC_VagonsOperations(); int res = vo.UpdateVagon(6822, 24589244, new int[] { 1, 4 }, DateTime.Now, 1, 7777); }
public void Test_SUD_RC_VagonsOperations() { RC_VagonsOperations vo = new RC_VagonsOperations(); VAGON_OPERATIONS vo1 = new VAGON_OPERATIONS() { id_oper = 0, dt_amkr = DateTime.Now, n_natur = -777, id_vagon = 889213, id_stat = 4, dt_from_stat = null, dt_on_stat = DateTime.Now, id_way = 51, dt_from_way = null, dt_on_way = DateTime.Now, num_vag_on_way = 0, is_present = 0, id_locom = null, id_locom2 = null, id_cond2 = null, id_gruz = null, id_gruz_amkr = null, id_shop_gruz_for = null, weight_gruz = null, id_tupik = null, id_nazn_country = null, id_gdstait = null, id_cond = null, note = null, is_hist = 0, id_oracle = null, lock_id_way = null, lock_order = null, lock_side = null, lock_id_locom = null, st_lock_id_stat = null, st_lock_order = null, st_lock_train = null, st_lock_side = null, st_gruz_front = null, st_shop = null, oracle_k_st = null, st_lock_locom1 = null, st_lock_locom2 = null, id_oper_parent = null, grvu_SAP = null, ngru_SAP = null, id_ora_23_temp = null, edit_user = null, edit_dt = null, IDSostav = 0, }; int res_ov1 = vo.SaveVagonsOperations(vo1); Test_RC_VagonsOperations(res_ov1); VAGON_OPERATIONS vo2 = new VAGON_OPERATIONS() { id_oper = res_ov1, dt_amkr = DateTime.Now, n_natur = -888, id_vagon = 889213, id_stat = 4, dt_from_stat = null, dt_on_stat = DateTime.Now, id_way = 51, dt_from_way = null, dt_on_way = DateTime.Now, num_vag_on_way = 0, is_present = 0, id_locom = null, id_locom2 = null, id_cond2 = null, id_gruz = null, id_gruz_amkr = null, id_shop_gruz_for = null, weight_gruz = null, id_tupik = null, id_nazn_country = null, id_gdstait = null, id_cond = null, note = null, is_hist = 0, id_oracle = null, lock_id_way = null, lock_order = null, lock_side = null, lock_id_locom = null, st_lock_id_stat = null, st_lock_order = null, st_lock_train = null, st_lock_side = null, st_gruz_front = null, st_shop = null, oracle_k_st = null, st_lock_locom1 = null, st_lock_locom2 = null, id_oper_parent = null, grvu_SAP = null, ngru_SAP = null, id_ora_23_temp = null, edit_user = null, edit_dt = null, IDSostav = 0, }; int res_ov2 = vo.SaveVagonsOperations(vo2); Test_RC_VagonsOperations(res_ov2); VAGON_OPERATIONS del = vo.DeleteVagonsOperations(res_ov2); WL(del); }
public void Test_RC_MaxPositionWay(int id_way) { RC_VagonsOperations vo = new RC_VagonsOperations(); Console.WriteLine("id_way : {0}", vo.MaxPositionWay(id_way)); }
public void Test_RC_IsVagonOperation(int natur, DateTime dt_amkr, int id_vagon) { RC_VagonsOperations vo = new RC_VagonsOperations(); Console.WriteLine("IsVagonOperation : {0}", vo.IsVagonOperationKIS(natur, dt_amkr, id_vagon)); }
public void Test_RC_VagonsOperationsToNatur(int natur, DateTime dt_amkr, int id_vagon) { RC_VagonsOperations vo = new RC_VagonsOperations(); WL(vo.GetVagonsOperationsToNatur(natur, dt_amkr, id_vagon)); }
public void Test_RC_VagonsOperations(int id_oper) { RC_VagonsOperations vo = new RC_VagonsOperations(); WL(vo.GetVagonsOperations(id_oper)); }
public void Test_RC_VagonsOperations_DelseteIDSostav() { RC_VagonsOperations vo = new RC_VagonsOperations(); Console.WriteLine("Количество строк: {0}", vo.DeleteVagonsToInsertMT(4231)); }