public String insert(JobImportContainerList p) { String re = ""; String sql = ""; p.active = "1"; //p.ssdata_id = ""; int chk = 0; chkNull(p); sql = "Insert Into " + jcs.table + "(" + jcs.job_import_id + "," + jcs.container_no + "," + jcs.seal + "," + jcs.row1 + "," + jcs.remark + "," + jcs.date_create + "," + jcs.date_modi + "," + jcs.date_cancel + "," + jcs.user_create + "," + jcs.user_modi + "," + jcs.user_cancel + "," + jcs.doc_type_id_container + "," + jcs.active + " " + ") " + "Values ('" + p.job_import_id + "','" + p.container_no + "','" + p.seal + "'," + "'" + p.row1 + "','" + p.remark.Replace("'", "''") + "','" + p.date_create + "'," + "'" + p.date_modi + "','" + p.date_cancel + "','" + p.user_create.Replace("'", "''") + "'," + "'" + p.user_modi.Replace("'", "''") + "','" + p.user_cancel.Replace("'", "''") + "','" + p.doc_type_id_container.Replace("'", "''") + "'," + "'" + p.active.Replace("'", "''") + "' " + ")"; try { re = conn.ExecuteNonQuery(conn.conn, sql); String code = re.Substring(re.Length - 6); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
public String update(JobImportContainerList p) { String re = ""; String sql = ""; int chk = 0; chkNull(p); sql = "Update " + jcs.table + " Set " + " " + jcs.job_import_id + " = '" + p.job_import_id + "'" + "," + jcs.container_no + " = '" + p.container_no.Replace("'", "''") + "'" + "," + jcs.seal + " = '" + p.seal + "'" + "," + jcs.row1 + " = '" + p.row1.Replace("'", "''") + "'" + "," + jcs.doc_type_id_container + " = '" + p.doc_type_id_container.Replace("'", "''") + "'" + "," + jcs.date_modi + " = now() " + "," + jcs.user_modi + " = '" + conn.user.staff_id + "' " + "," + jcs.remark + " = '" + p.remark.Replace("'", "''") + "' " + "Where " + jcs.pkField + "='" + p.job_import_container_id + "'" ; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
public JobImportContainerList selectByJobId(String copId) { JobImportContainerList cont1 = new JobImportContainerList(); DataTable dt = new DataTable(); String sql = "select jcs.* " + "From " + jcs.table + " jcs " + "Where jcs." + jcs.job_import_id + " ='" + copId + "' "; dt = conn.selectData(conn.conn, sql); cont1 = setJobImportCheckList(dt); return(cont1); }
public String insertJobImportContainerList(JobImportContainerList p) { String re = ""; if (p.job_import_container_id.Equals("")) { re = insert(p); } else { re = update(p); } return(re); }
private void chkNull(JobImportContainerList p) { int chk = 0; Decimal chk1 = 0; p.job_import_id = p.job_import_id == null ? "" : p.job_import_id; p.container_no = p.container_no == null ? "" : p.container_no; p.seal = p.seal == null ? "" : p.seal; p.row1 = p.row1 == null ? "" : p.row1; p.remark = p.remark == null ? "" : p.remark; 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.doc_type_id_container = int.TryParse(p.doc_type_id_container, out chk) ? chk.ToString() : "0"; }
private JobImportContainerList setJobImportCheckList(DataTable dt) { JobImportContainerList jcl1 = new JobImportContainerList(); if (dt.Rows.Count > 0) { jcl1.job_import_container_id = dt.Rows[0][jcs.job_import_container_id].ToString(); jcl1.job_import_id = dt.Rows[0][jcs.job_import_id].ToString(); jcl1.container_no = dt.Rows[0][jcs.container_no] != null ? dt.Rows[0][jcs.container_no].ToString() : ""; jcl1.doc_type_id_container = dt.Rows[0][jcs.doc_type_id_container] != null ? dt.Rows[0][jcs.doc_type_id_container].ToString() : ""; jcl1.seal = dt.Rows[0][jcs.seal] != null ? dt.Rows[0][jcs.seal].ToString() : ""; jcl1.row1 = dt.Rows[0][jcs.row1] != null ? dt.Rows[0][jcs.row1].ToString() : ""; jcl1.remark = dt.Rows[0][jcs.remark] != null ? dt.Rows[0][jcs.remark].ToString() : ""; jcl1.active = dt.Rows[0][jcs.active] != null ? dt.Rows[0][jcs.active].ToString() : ""; jcl1.date_create = dt.Rows[0][jcs.date_create] != null ? dt.Rows[0][jcs.date_create].ToString() : ""; jcl1.date_modi = dt.Rows[0][jcs.date_modi] != null ? dt.Rows[0][jcs.date_modi].ToString() : ""; jcl1.date_cancel = dt.Rows[0][jcs.date_cancel] != null ? dt.Rows[0][jcs.date_cancel].ToString() : ""; jcl1.user_create = dt.Rows[0][jcs.user_create] != null ? dt.Rows[0][jcs.user_create].ToString() : ""; jcl1.user_modi = dt.Rows[0][jcs.user_modi] != null ? dt.Rows[0][jcs.user_modi].ToString() : ""; jcl1.user_cancel = dt.Rows[0][jcs.user_cancel] != null ? dt.Rows[0][jcs.user_cancel].ToString() : ""; } else { jcl1.job_import_container_id = ""; jcl1.job_import_id = ""; jcl1.container_no = ""; jcl1.doc_type_id_container = ""; jcl1.seal = ""; jcl1.row1 = ""; jcl1.remark = ""; jcl1.date_create = ""; jcl1.date_modi = ""; jcl1.date_cancel = ""; jcl1.user_create = ""; jcl1.user_modi = ""; jcl1.user_cancel = ""; jcl1.remark = ""; jcl1.active = ""; } return(jcl1); }
private void initConfig() { jcs = new JobImportContainerList(); jcs.job_import_container_id = "job_import_container_id"; jcs.job_import_id = "job_import_id"; jcs.container_no = "container_no"; jcs.doc_type_id_container = "doc_type_id_container"; jcs.seal = "seal"; jcs.row1 = "row1"; jcs.remark = "remark"; jcs.active = "active"; jcs.date_create = "date_create"; jcs.date_modi = "date_modi"; jcs.date_cancel = "date_cancel"; jcs.user_create = "user_create"; jcs.user_modi = "user_modi"; jcs.user_cancel = "user_cancel"; jcs.table = "t_job_import_container_list"; jcs.pkField = "job_import_container_id"; }