private void chkNull(JobImportDelivery p) { int chk = 0; Decimal chk1 = 0; p.row1 = p.row1 == null ? "" : p.row1; p.delivery_doc_no = p.delivery_doc_no == null ? "" : p.delivery_doc_no; p.date_create = p.date_create == null ? "" : p.date_create; p.date_modi = p.date_modi == null ? "" : p.date_modi; p.date_cancel = p.date_cancel == null ? "" : p.date_cancel; p.user_create = p.user_create == null ? "" : p.user_create; p.user_modi = p.user_modi == null ? "" : p.user_modi; p.user_cancel = p.user_cancel == null ? "" : p.user_cancel; p.packages = p.packages == null ? "" : p.packages; p.gw = p.gw == null ? "" : p.gw; p.volume1 = p.volume1 == null ? "" : p.volume1; p.container_no = p.container_no == null ? "" : p.container_no; p.doc_type_namet_container = p.doc_type_namet_container == null ? "" : p.doc_type_namet_container; p.seal = p.seal == null ? "" : p.seal; p.yard_container = p.yard_container == null ? "" : p.yard_container; p.remark = p.remark == null ? "" : p.remark; //p.packages1 = p.packages1 == null ? "" : p.packages1; //p.packages1 = p.packages1 == null ? "" : p.packages1; p.job_import_id = int.TryParse(p.job_import_id, out chk) ? chk.ToString() : "0"; p.car_type_id = int.TryParse(p.car_type_id, out chk) ? chk.ToString() : "0"; p.transporter_id = int.TryParse(p.transporter_id, out chk) ? chk.ToString() : "0"; p.place_id = int.TryParse(p.place_id, out chk) ? chk.ToString() : "0"; p.unit_package_id = int.TryParse(p.unit_package_id, out chk) ? chk.ToString() : "0"; p.unit_gw_id = int.TryParse(p.unit_gw_id, out chk) ? chk.ToString() : "0"; p.unit_volume1_id = int.TryParse(p.unit_volume1_id, out chk) ? chk.ToString() : "0"; p.job_import_delivery1_id = int.TryParse(p.job_import_delivery1_id, out chk) ? chk.ToString() : "0"; //p.job_import_id1 = int.TryParse(p.job_import_id1, out chk) ? chk.ToString() : "0"; }
public String insert(JobImportDelivery p) { String re = "", sql = ""; p.active = "1"; //p.ssdata_id = ""; chkNull(p); sql = "Insert Into " + jdv.table + "(" + jdv.job_import_id + "," + jdv.row1 + "," + jdv.delivery_doc_no + "," + jdv.active + "," + jdv.remark + "," + jdv.date_create + "," + jdv.date_modi + "," + jdv.date_cancel + "," + jdv.user_create + "," + jdv.transporter_id + "," + jdv.place_id + "," + jdv.packages + ", " + jdv.unit_package_id + "," + jdv.gw + "," + jdv.unit_gw_id + ", " + jdv.volume1 + "," + jdv.unit_volume1_id + "," + jdv.job_import_delivery1_id + ", " + jdv.container_no + "," + jdv.doc_type_namet_container + "," + jdv.seal + ", " + jdv.yard_container + " " + ") " + "Values ('" + p.job_import_id + "','" + p.row1 + "','" + p.delivery_doc_no + "'," + "'" + p.active + "','" + p.remark + "', now() " + "'" + p.date_modi + "','" + p.date_cancel + "','" + p.user_create + "'," + "'" + p.transporter_id + "','" + p.place_id + "','" + p.packages + "', " + "'" + p.unit_package_id + "','" + p.gw + "','" + p.unit_gw_id + "', " + "'" + p.volume1 + "','" + p.unit_volume1_id + "','" + p.job_import_delivery1_id + "', " + "'" + p.container_no + "','" + p.doc_type_namet_container + "','" + p.seal + "', " + "'" + p.yard_container + "' " + ")"; re = conn.ExecuteNonQuery(conn.conn, sql); return(re); }
private void initConfig() { jdv = new JobImportDelivery(); jdv.job_import_delivery_id = "job_import_delivery_id"; jdv.job_import_id = "job_import_id"; jdv.row1 = "row1"; jdv.delivery_doc_no = "delivery_doc_no"; jdv.car_type_id = "car_type_id"; jdv.transporter_id = "transporter_id"; jdv.place_id = "place_id"; jdv.packages = "packages"; jdv.unit_package_id = "unit_package_id"; jdv.gw = "gw"; jdv.unit_gw_id = "unit_gw_id"; jdv.volume1 = "volume1"; jdv.unit_volume1_id = "unit_volume1_id"; jdv.job_import_delivery1_id = "job_import_delivery1_id"; jdv.container_no = "container_no"; jdv.doc_type_namet_container = "doc_type_namet_container"; jdv.seal = "seal"; jdv.yard_container = "yard_container"; jdv.remark = "remark"; jdv.active = "active"; jdv.date_create = "date_create"; jdv.date_modi = "date_modi"; jdv.date_cancel = "date_cancel"; jdv.user_create = "user_create"; jdv.user_modi = "user_modi"; jdv.user_cancel = "user_cancel"; }
public String update(JobImportDelivery p) { String re = "", sql = ""; chkNull(p); sql = "Update " + jdv.table + " Set " + " " + jdv.job_import_id + "='" + p.job_import_id + "' " + "," + jdv.row1 + "='" + p.row1.Replace("'", "''") + "' " + "," + jdv.delivery_doc_no + "='" + p.delivery_doc_no.Replace("'", "''") + "' " + "," + jdv.remark + "='" + p.remark.Replace("'", "''") + "' " + "," + jdv.user_modi + "='" + p.user_modi.Replace("'", "''") + "' " + "," + jdv.date_modi + "=now() " + "," + jdv.transporter_id + "='" + p.transporter_id.Replace("'", "''") + "' " + "," + jdv.place_id + "='" + p.place_id.Replace("'", "''") + "' " + "," + jdv.packages + "='" + p.packages.Replace("'", "''") + "' " + "," + jdv.unit_package_id + "='" + p.unit_package_id.Replace("'", "''") + "' " + "," + jdv.gw + "='" + p.gw.Replace("'", "''") + "' " + "," + jdv.unit_gw_id + "='" + p.unit_gw_id.Replace("'", "''") + "' " + "," + jdv.volume1 + "='" + p.volume1.Replace("'", "''") + "' " + "," + jdv.unit_volume1_id + "='" + p.unit_volume1_id.Replace("'", "''") + "' " + "," + jdv.job_import_delivery1_id + "='" + p.job_import_delivery1_id.Replace("'", "''") + "' " + "," + jdv.container_no + "='" + p.container_no.Replace("'", "''") + "' " + "," + jdv.doc_type_namet_container + "='" + p.doc_type_namet_container.Replace("'", "''") + "' " + "," + jdv.seal + "='" + p.seal.Replace("'", "''") + "' " + "," + jdv.yard_container + "='" + p.yard_container.Replace("'", "''") + "' " + "Where " + jdv.pkField + "='" + p.job_import_delivery_id + "'" ; re = conn.ExecuteNonQuery(conn.conn, sql); return(re); }
public JobImportDelivery selectByPk1(String copId) { JobImportDelivery cop1 = new JobImportDelivery(); DataTable dt = new DataTable(); String sql = "select jdv.* " + "From " + jdv.table + " jdv " + //"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " + "Where jdv." + jdv.pkField + " ='" + copId + "' "; dt = conn.selectData(conn.conn, sql); cop1 = setImportContainer(dt); return(cop1); }
public String insertPrefix(JobImportDelivery p) { String re = ""; if (p.job_import_delivery_id.Equals("")) { re = insert(p); } else { re = update(p); } return(re); }
private JobImportDelivery setImportContainer(DataTable dt) { JobImportDelivery jii1 = new JobImportDelivery(); if (dt.Rows.Count > 0) { jii1.job_import_delivery_id = dt.Rows[0][jdv.job_import_delivery_id].ToString(); jii1.job_import_id = dt.Rows[0][jdv.job_import_id].ToString(); jii1.row1 = dt.Rows[0][jdv.row1].ToString(); jii1.active = dt.Rows[0][jdv.active].ToString(); jii1.remark = dt.Rows[0][jdv.remark].ToString(); jii1.delivery_doc_no = dt.Rows[0][jdv.delivery_doc_no].ToString(); jii1.date_create = dt.Rows[0][jdv.date_create].ToString(); jii1.date_modi = dt.Rows[0][jdv.date_modi].ToString(); jii1.date_cancel = dt.Rows[0][jdv.date_cancel].ToString(); jii1.user_cancel = dt.Rows[0][jdv.user_cancel].ToString(); jii1.user_create = dt.Rows[0][jdv.user_create].ToString(); jii1.user_modi = dt.Rows[0][jdv.user_modi].ToString(); //pti1.status_app = dt.Rows[0][tmn.status_app].ToString(); jii1.car_type_id = dt.Rows[0][jdv.car_type_id].ToString(); jii1.transporter_id = dt.Rows[0][jdv.transporter_id].ToString(); jii1.place_id = dt.Rows[0][jdv.place_id].ToString(); jii1.packages = dt.Rows[0][jdv.packages].ToString(); jii1.unit_package_id = dt.Rows[0][jdv.unit_package_id].ToString(); jii1.gw = dt.Rows[0][jdv.gw].ToString(); jii1.unit_gw_id = dt.Rows[0][jdv.unit_gw_id].ToString(); jii1.volume1 = dt.Rows[0][jdv.volume1].ToString(); jii1.unit_volume1_id = dt.Rows[0][jdv.unit_volume1_id].ToString(); jii1.job_import_delivery1_id = dt.Rows[0][jdv.job_import_delivery1_id].ToString(); jii1.container_no = dt.Rows[0][jdv.container_no].ToString(); jii1.doc_type_namet_container = dt.Rows[0][jdv.doc_type_namet_container].ToString(); jii1.seal = dt.Rows[0][jdv.seal].ToString(); jii1.yard_container = dt.Rows[0][jdv.yard_container].ToString(); } return(jii1); }