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