private void LoadOsnSostav(string file)
{
(new OracleCommand("delete from sepo_osn_sostav", obj_lib.Module.Connection)).ExecuteNonQuery();
CsvColumn[] columns =
{
new CsvColumn("prjlink_id"),
new CsvColumn("proj_aid"),
new CsvColumn("part_aid"),
new CsvColumn("count_pc"),
new CsvColumn("mu_id"),
new CsvColumn("razdel"),
new CsvColumn("position"),
new CsvColumn("note"),
new CsvColumn("variants"),
new CsvColumn("link_type"),
new CsvColumn("format"),
new CsvColumn("pr_id"),
new CsvColumn("f_start_dt"),
new CsvColumn("f_finish_dt"),
new CsvColumn("order_id"),
new CsvColumn("ctx_id"),
new CsvColumn("ctx_fl"),
new CsvColumn("opt_link"),
new CsvColumn("author"),
new CsvColumn("proj_ver_id")
};
CsvFile csv = new CsvFile(file, '\t', columns);
csv.Load("sepo_osn_sostav", obj_lib.Module.Connection);
csv.Close();
}
private void LoadOsnDet(string file)
{
(new OracleCommand("delete from sepo_osn_det", obj_lib.Module.Connection)).ExecuteNonQuery();
CsvColumn[] columns =
{
new CsvColumn("art_id"),
new CsvColumn("s_material"),
new CsvColumn("dce"),
new CsvColumn("izd")
};
CsvFile csv = new CsvFile(file, '\t', columns);
csv.Load("sepo_osn_det", obj_lib.Module.Connection);
csv.Close();
}
private void LoadOsnAll(string file)
{
(new OracleCommand("delete from sepo_osn_all", obj_lib.Module.Connection)).ExecuteNonQuery();
CsvColumn[] columns =
{
new CsvColumn("art_id"),
new CsvColumn("doc_id"),
new CsvColumn("isp_code"),
new CsvColumn("designation"),
new CsvColumn("name"),
new CsvColumn("okp_code"),
new CsvColumn("imbase_key"),
new CsvColumn("purchased"),
new CsvColumn("massa"),
new CsvColumn("mu_id"),
new CsvColumn("section_id"),
new CsvColumn("note"),
new CsvColumn("expanding"),
new CsvColumn("litera"),
new CsvColumn("mmr"),
new CsvColumn("art_ver_id"),
new CsvColumn("author"),
new CsvColumn("chkindate"),
new CsvColumn("pr_id"),
new CsvColumn("need_svo"),
new CsvColumn("modifdate"),
new CsvColumn("modifuser_id"),
new CsvColumn("baseart_id"),
new CsvColumn("art_class"),
new CsvColumn("serial_no"),
new CsvColumn("set_no")
};
CsvFile csv = new CsvFile(file, '\t', columns);
csv.Load("sepo_osn_all", obj_lib.Module.Connection);
csv.Close();
}
private void LoadOsnDocs(string file)
{
(new OracleCommand("delete from sepo_osn_docs", obj_lib.Module.Connection)).ExecuteNonQuery();
CsvColumn[] columns =
{
new CsvColumn("doc_id"),
new CsvColumn("archive_id"),
new CsvColumn("filename"),
new CsvColumn("arc_dir_id"),
new CsvColumn("wrk_dir_id"),
new CsvColumn("designatio"),
new CsvColumn("name"),
new CsvColumn("format"),
new CsvColumn("designerid"),
new CsvColumn("doc_type"),
new CsvColumn("doc_status"),
new CsvColumn("revision"),
new CsvColumn("note"),
new CsvColumn("version_id"),
new CsvColumn("createdate"),
new CsvColumn("modifydate"),
new CsvColumn("modifyuser_id"),
new CsvColumn("otd_status"),
new CsvColumn("otd_reg"),
new CsvColumn("otd_annul"),
new CsvColumn("otd_reg_user"),
new CsvColumn("otd_annul_user"),
new CsvColumn("canc_status"),
new CsvColumn("invisible")
};
CsvFile csv = new CsvFile(file, '\t', columns);
csv.Load("sepo_osn_docs", obj_lib.Module.Connection);
csv.Close();
}