private void initConfig()
{
Console.WriteLine("manDB start");
jclDB = new JobImportCheckListDB(conn);
jceDB = new JobImportCheckExamDB(conn);
jcsDB = new JobImportContainerListDB(conn);
jdvDB = new JobImportDeliveryDB(conn);
jcnDB = new JobImportContainerDB(conn);
jieDB = new JobImportExpnDB(conn);
jinDB = new JobImportInvDB(conn);
jimDB = new JobImportDB(conn);
jctDB = new JobImportContDB(conn);
jblDB = new JobImportBlDB(conn);
Console.WriteLine("manDB end");
}
public void setJobImport(String jobNo)
{
String year = DateTime.Now.Year.ToString();
String date = DateTime.Now.ToString("yyyy-MM-dd");
JobImport jim = new JobImport();
DataTable dtJob = new DataTable();
DataTable dtJob4 = new DataTable();
DataTable dtJob3 = new DataTable();
DataTable dtJobInv = new DataTable();
CustomerDB cusDB = new CustomerDB(conn);
String impId = "";
JobImportDB jimDB = new JobImportDB(conn);
JobImportBlDB jblDB = new JobImportBlDB(conn);
dtJob = selectJobNoImport(jobNo);
if (dtJob.Rows.Count > 0)
{
impId = cusDB.selectImpIdByCodeLike1(dtJob.Rows[0]["importer"].ToString());
jim.job_import_id = "";
jim.job_import_code = "";
jim.job_import_date = date;
jim.cust_id = "";
jim.imp_id = impId;
jim.transport_mode = dtJob.Rows[0]["transmode"].ToString().Trim();
jim.staff_id = conn.user.staff_id;
jim.entry_type_id = "";
jim.privi_id = "";
jim.ref_1 = "";
jim.ref_2 = "";
jim.ref_3 = "";
jim.ref_4 = "";
jim.ref_5 = "";
jim.ref_edi = "";
jim.imp_entry = "";
jim.edi_response = "";
jim.tax_method_id = "";
jim.check_exam_id = "";
jim.inv_date = "";
jim.tax_amt = "";
jim.insr_date = "";
jim.insr_id = "";
jim.policy_no = "";
jim.premium = "";
jim.policy_date = "";
jim.policy_clause = "";
jim.job_year = year;
jim.date_create = "";
jim.date_modi = "";
jim.date_cancel = "";
jim.user_create = "";
jim.user_modi = "";
jim.user_cancel = "";
jim.active = "1";
jim.remark3 = "";
jim.remark1 = "";
jim.remark2 = "";
jim.jobno = dtJob.Rows[0]["jobno"].ToString().Trim();
jim.job_date = conn.dateMiotoDB(dtJob.Rows[0]["jobdate"].ToString().Trim());
jim.imp_date = conn.dateMiotoDB(dtJob.Rows[0]["imdate"].ToString().Trim());
jim.bl = dtJob.Rows[0]["bl"].ToString().Trim();
String jimId = jimDB.insertJobImport(jim);
int chk = 0;
if (int.TryParse(jimId, out chk))
{
JobImportBl jbl = new JobImportBl();
jbl.job_import_bl_id = "";
jbl.job_import_id = jimId;
jbl.forwarder_id = "";
jbl.mbl_mawb = "";
jbl.hbl_hawb = dtJob.Rows[0]["housebl"].ToString().Trim();
jbl.m_vessel = dtJob.Rows[0]["vslname"].ToString().Trim();
jbl.f_vessel = "";
jbl.etd = "";
jbl.eta = "";
jbl.port_imp_id = "";
jbl.terminal_id = "";
jbl.marsk = "";
jbl.description = "";
jbl.gw = dtJob.Rows[0]["grsww"].ToString().Trim();
jbl.gw_unit_id = dtJob.Rows[0]["grswwunit"].ToString().Trim();
jbl.packages_total = dtJob.Rows[0]["nopkg"].ToString().Trim();
jbl.unit_package1_id = dtJob.Rows[0]["pkgunit"].ToString().Trim();
jbl.total_con20 = "";
jbl.total_con40 = "";
jbl.volume1 = "";
jbl.port_of_loading_id = "";
jbl.date_check_exam = "";
jbl.date_delivery = "";
jbl.date_tofac = "";
jbl.truck_id = "";
jbl.car_number = "";
jbl.tranfer_with_job_id = "";
jbl.truck_cop_id = "";
jbl.status_doc_forrow = "";
jbl.doc_forrow = "";
jbl.date_doc_forrow = "";
jbl.status_job_forrow = "";
jbl.job_forrow_description = "";
jbl.date_finish_job_forrow = "";
jbl.status_oth_job = "";
jbl.delivery_remark = "";
jbl.container_yard = "";
jbl.date_create = "";
jbl.date_modi = "";
jbl.date_cancel = "";
jbl.user_create = "";
jbl.user_modi = "";
jbl.user_cancel = "";
jbl.active = "1";
jbl.remark = "";
jbl.oth_job_no = "";
jbl.fwdCode = "";
jbl.fwdCode = "";
jbl.ugwCode = "";
jbl.ugwNameT = "";
jbl.utpCode = "";
jbl.utpNameT = "";
jbl.polCode = "";
jbl.polNameT = "";
jbl.tmnCode = "";
jbl.tmnNameT = "";
jblDB.insertJobImportBl(jbl);
}
}
}
