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));
}
