public String insert(JobImportCheckList p)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
sql = "Insert Into " + jcl.table + "(" + jcl.job_import_id + "," + jcl.status_original + "," + jcl.check_list_date + "," +
jcl.type_of_bl + "," + jcl.email_do + "," + jcl.privi1_id + "," +
jcl.privi2_id + "," + jcl.privi1_date + "," + jcl.privi2_date + "," +
jcl.privi1_desc + "," + jcl.privi2_desc + "," + jcl.doc_authen1_id + "," +
jcl.doc_authen2_id + "," + jcl.doc_authen3_id + "," + jcl.doc_authen1_date + "," +
jcl.doc_authen2_date + "," + jcl.doc_authen3_date + "," + jcl.enter_bl + "," +
jcl.insurance_atten + "," + jcl.email_do1 + "," + jcl.email_do1_date + "," +
jcl.do_date_send + "," + jcl.do_date_receive + ", " + jcl.tax_date_send + ", " +
jcl.tax_date_receive + "," + jcl.exp1_date_send + ", " + jcl.exp1_date_receive + ", " +
jcl.date_create + "," + jcl.date_modi + ", " + jcl.date_cancel + ", " +
jcl.user_create + "," + jcl.user_modi + ", " + jcl.user_cancel + ", " +
jcl.active + "," + jcl.exp2_date_send + ", " + jcl.exp2_date_receive + ", " +
jcl.receipt_date + ", " + jcl.receipt_copy_date + ", " + jcl.accept_tender + ", " +
jcl.advance_billing + ", " + jcl.approve_date + "," + jcl.parent1 + ", " +
jcl.remark + " " +
") " +
"Values ('" + p.job_import_id + "','" + p.status_original + "','" + p.check_list_date + "'," +
"'" + p.type_of_bl + "','" + p.email_do.Replace("'", "''") + "','" + p.privi1_id + "'," +
"'" + p.privi2_id + "','" + p.privi1_date + "','" + p.privi2_date.Replace("'", "''") + "'," +
"'" + p.privi1_desc.Replace("'", "''") + "','" + p.privi2_desc.Replace("'", "''") + "','" + p.doc_authen1_id.Replace("'", "''") + "'," +
"'" + p.doc_authen2_id.Replace("'", "''") + "','" + p.doc_authen3_id.Replace("'", "''") + "','" + p.doc_authen1_date.Replace("'", "''") + "'," +
"'" + p.doc_authen2_date.Replace("'", "''") + "','" + p.doc_authen3_date + "','" + p.enter_bl + "'," +
"'" + p.insurance_atten + "','" + p.email_do1 + "','" + p.email_do1_date + "', " +
"'" + p.do_date_send + "','" + p.do_date_receive.Replace("'", "''") + "','" + p.tax_date_send + "', " +
"'" + p.tax_date_receive + "','" + p.exp1_date_send.Replace("'", "''") + "','" + p.exp1_date_receive + "', " +
"now(),'" + p.date_modi + "','" + p.date_cancel + "', " +
"'" + conn.user.staff_id + "','" + p.user_modi + "','" + p.user_cancel + "', " +
"'" + p.active + "','" + p.exp2_date_send.Replace("'", "''") + "','" + p.exp2_date_receive.Replace("'", "''") + "', " +
"'" + p.receipt_date.Replace("'", "''") + "','" + p.receipt_copy_date.Replace("'", "''") + "','" + p.accept_tender.Replace("'", "''") + "'," +
"'" + p.advance_billing.Replace("'", "''") + "','" + p.approve_date.Replace("'", "''") + "','" + p.parent1.Replace("'", "''") + "'," +
"'" + p.remark.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);
}
private void chkNull(JobImportCheckList p)
{
int chk = 0;
Decimal chk1 = 0;
p.status_original = p.status_original == null ? "" : p.status_original;
p.check_list_date = p.check_list_date == null ? "" : p.check_list_date;
p.email_do = p.email_do == null ? "" : p.email_do;
p.privi1_date = p.privi1_date == null ? "" : p.privi1_date;
p.privi2_date = p.privi2_date == null ? "" : p.privi2_date;
p.privi1_desc = p.privi1_desc == null ? "" : p.privi1_desc;
p.privi2_desc = p.privi2_desc == null ? "" : p.privi2_desc;
p.doc_authen1_date = p.doc_authen1_date == null ? "" : p.doc_authen1_date;
p.doc_authen2_date = p.doc_authen2_date == null ? "" : p.doc_authen2_date;
p.doc_authen3_date = p.doc_authen3_date == null ? "" : p.doc_authen3_date;
p.enter_bl = p.enter_bl == null ? "" : p.enter_bl;
p.insurance_atten = p.insurance_atten == null ? "" : p.insurance_atten;
p.email_do1 = p.email_do1 == null ? "" : p.email_do1;
p.email_do1_date = p.email_do1_date == null ? "" : p.email_do1_date;
p.do_date_send = p.do_date_send == null ? "" : p.do_date_send;
p.do_date_receive = p.do_date_receive == null ? "" : p.do_date_receive;
p.tax_date_send = p.tax_date_send == null ? "" : p.tax_date_send;
p.tax_date_receive = p.tax_date_receive == null ? "" : p.tax_date_receive;
p.exp1_date_send = p.exp1_date_send == null ? "" : p.exp1_date_send;
p.exp1_date_receive = p.exp1_date_receive == null ? "" : p.exp1_date_receive;
p.exp2_date_send = p.exp2_date_send == null ? "" : p.exp2_date_send;
p.exp2_date_receive = p.exp2_date_receive == null ? "" : p.exp2_date_receive;
p.receipt_date = p.receipt_date == null ? "" : p.receipt_date;
p.receipt_copy_date = p.receipt_copy_date == null ? "" : p.receipt_copy_date;
p.accept_tender = p.accept_tender == null ? "" : p.accept_tender;
p.advance_billing = p.advance_billing == null ? "" : p.advance_billing;
p.approve_date = p.approve_date == null ? "" : p.approve_date;
p.parent1 = p.parent1 == null ? "" : p.parent1;
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.remark = p.remark == null ? "" : p.remark;
p.job_import_id = int.TryParse(p.job_import_id, out chk) ? chk.ToString() : "0";
p.type_of_bl = int.TryParse(p.type_of_bl, out chk) ? chk.ToString() : "0";
p.privi1_id = int.TryParse(p.privi1_id, out chk) ? chk.ToString() : "0";
p.privi2_id = int.TryParse(p.privi2_id, out chk) ? chk.ToString() : "0";
p.doc_authen1_id = int.TryParse(p.doc_authen1_id, out chk) ? chk.ToString() : "0";
p.doc_authen2_id = int.TryParse(p.doc_authen2_id, out chk) ? chk.ToString() : "0";
p.doc_authen3_id = int.TryParse(p.doc_authen3_id, out chk) ? chk.ToString() : "0";
//p.cust_id = int.TryParse(p.cust_id, out chk) ? chk.ToString() : "0";
//p.cust_id = int.TryParse(p.cust_id, out chk) ? chk.ToString() : "0";
//p.cust_id = int.TryParse(p.cust_id, out chk) ? chk.ToString() : "0";
//p.amphur_id = int.TryParse(p.amphur_id, out chk) ? chk.ToString() : "0";
}
public JobImportCheckList selectByJobId(String copId)
{
JobImportCheckList cont1 = new JobImportCheckList();
DataTable dt = new DataTable();
String sql = "select jcl.* " +
"From " + jcl.table + " jcl " +
"Where jcl." + jcl.job_import_id + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cont1 = setJobImportCheckList(dt);
return(cont1);
}
private void initConfig()
{
jcl = new JobImportCheckList();
jcl.import_check_list_id = "import_check_list_id";
jcl.job_import_id = "job_import_id";
jcl.status_original = "status_original";
jcl.check_list_date = "check_list_date";
jcl.type_of_bl = "type_of_bl";
jcl.email_do = "email_do";
jcl.privi1_id = "privi1_id";
jcl.privi2_id = "privi2_id";
jcl.privi1_date = "privi1_date";
jcl.privi2_date = "privi2_date";
jcl.privi1_desc = "privi1_desc";
jcl.privi2_desc = "privi2_desc";
jcl.doc_authen1_id = "doc_authen1_id";
jcl.doc_authen2_id = "doc_authen2_id";
jcl.doc_authen3_id = "doc_authen3_id";
jcl.doc_authen1_date = "doc_authen1_date";
jcl.doc_authen2_date = "doc_authen2_date";
jcl.doc_authen3_date = "doc_authen3_date";
jcl.enter_bl = "enter_bl";
jcl.insurance_atten = "insurance_atten";
jcl.email_do1 = "email_do1";
jcl.email_do1_date = "email_do1_date";
jcl.do_date_send = "do_date_send";
jcl.do_date_receive = "do_date_receive";
jcl.tax_date_send = "tax_date_send";
jcl.tax_date_receive = "tax_date_receive";
jcl.exp1_date_send = "exp1_date_send";
jcl.exp1_date_receive = "exp1_date_receive";
jcl.exp2_date_send = "exp2_date_send";
jcl.exp2_date_receive = "exp2_date_receive";
jcl.receipt_date = "receipt_date";
jcl.receipt_copy_date = "receipt_copy_date";
jcl.accept_tender = "accept_tender";
jcl.advance_billing = "advance_billing";
jcl.approve_date = "approve_date";
jcl.parent1 = "parent1";
jcl.date_create = "date_create";
jcl.date_modi = "date_modi";
jcl.date_cancel = "date_cancel";
jcl.user_create = "user_create";
jcl.user_modi = "user_modi";
jcl.user_cancel = "user_cancel";
jcl.remark = "remark";
jcl.active = "active";
jcl.table = "t_job_import_check_list";
jcl.pkField = "import_check_list_id";
}
public String insertJobImportCheckList(JobImportCheckList p)
{
String re = "";
if (p.import_check_list_id.Equals(""))
{
re = insert(p);
}
else
{
re = update(p);
}
return(re);
}
private JobImportCheckList setJobImportCheckList(DataTable dt)
{
JobImportCheckList jcl1 = new JobImportCheckList();
if (dt.Rows.Count > 0)
{
jcl1.import_check_list_id = dt.Rows[0][jcl.import_check_list_id].ToString();
jcl1.job_import_id = dt.Rows[0][jcl.job_import_id].ToString();
jcl1.status_original = dt.Rows[0][jcl.status_original] != null ? dt.Rows[0][jcl.status_original].ToString() : "";
jcl1.check_list_date = dt.Rows[0][jcl.check_list_date] != null ? dt.Rows[0][jcl.check_list_date].ToString() : "";
jcl1.type_of_bl = dt.Rows[0][jcl.type_of_bl] != null ? dt.Rows[0][jcl.type_of_bl].ToString() : "";
jcl1.email_do = dt.Rows[0][jcl.email_do] != null ? dt.Rows[0][jcl.email_do].ToString() : "";
jcl1.privi1_id = dt.Rows[0][jcl.privi1_id] != null ? dt.Rows[0][jcl.privi1_id].ToString() : "";
jcl1.privi2_id = dt.Rows[0][jcl.privi2_id] != null ? dt.Rows[0][jcl.privi2_id].ToString() : "";
jcl1.privi1_date = dt.Rows[0][jcl.privi1_date] != null ? dt.Rows[0][jcl.privi1_date].ToString() : "";
jcl1.privi2_date = dt.Rows[0][jcl.privi2_date] != null ? dt.Rows[0][jcl.privi2_date].ToString() : "";
jcl1.privi1_desc = dt.Rows[0][jcl.privi1_desc] != null ? dt.Rows[0][jcl.privi1_desc].ToString() : "";
jcl1.privi2_desc = dt.Rows[0][jcl.privi2_desc] != null ? dt.Rows[0][jcl.privi2_desc].ToString() : "";
jcl1.doc_authen1_id = dt.Rows[0][jcl.doc_authen1_id] != null ? dt.Rows[0][jcl.doc_authen1_id].ToString() : "";
jcl1.doc_authen2_id = dt.Rows[0][jcl.doc_authen2_id] != null ? dt.Rows[0][jcl.doc_authen2_id].ToString() : "";
jcl1.doc_authen3_id = dt.Rows[0][jcl.doc_authen3_id] != null ? dt.Rows[0][jcl.doc_authen3_id].ToString() : "";
jcl1.doc_authen1_date = dt.Rows[0][jcl.doc_authen1_date] != null ? dt.Rows[0][jcl.doc_authen1_date].ToString() : "";
jcl1.doc_authen2_date = dt.Rows[0][jcl.doc_authen2_date] != null ? dt.Rows[0][jcl.doc_authen2_date].ToString() : "";
jcl1.doc_authen3_date = dt.Rows[0][jcl.doc_authen3_date] != null ? dt.Rows[0][jcl.doc_authen3_date].ToString() : "";
jcl1.enter_bl = dt.Rows[0][jcl.enter_bl] != null ? dt.Rows[0][jcl.enter_bl].ToString() : "";
jcl1.insurance_atten = dt.Rows[0][jcl.insurance_atten] != null ? dt.Rows[0][jcl.insurance_atten].ToString() : "";
jcl1.email_do1 = dt.Rows[0][jcl.email_do1] != null ? dt.Rows[0][jcl.email_do1].ToString() : "";
jcl1.email_do1_date = dt.Rows[0][jcl.email_do1_date] != null ? dt.Rows[0][jcl.email_do1_date].ToString() : "";
jcl1.do_date_send = dt.Rows[0][jcl.do_date_send] != null ? dt.Rows[0][jcl.do_date_send].ToString() : "";
jcl1.do_date_receive = dt.Rows[0][jcl.do_date_receive] != null ? dt.Rows[0][jcl.do_date_receive].ToString() : "";
jcl1.tax_date_send = dt.Rows[0][jcl.tax_date_send] != null ? dt.Rows[0][jcl.tax_date_send].ToString() : "";
jcl1.tax_date_receive = dt.Rows[0][jcl.tax_date_receive] != null ? dt.Rows[0][jcl.tax_date_receive].ToString() : "";
jcl1.exp1_date_send = dt.Rows[0][jcl.exp1_date_send] != null ? dt.Rows[0][jcl.exp1_date_send].ToString() : "";
jcl1.exp1_date_receive = dt.Rows[0][jcl.exp1_date_receive] != null ? dt.Rows[0][jcl.exp1_date_receive].ToString() : "";
jcl1.exp2_date_send = dt.Rows[0][jcl.exp2_date_send] != null ? dt.Rows[0][jcl.exp2_date_send].ToString() : "";
jcl1.exp2_date_receive = dt.Rows[0][jcl.exp2_date_receive] != null ? dt.Rows[0][jcl.exp2_date_receive].ToString() : "";
jcl1.receipt_date = dt.Rows[0][jcl.receipt_date] != null ? dt.Rows[0][jcl.receipt_date].ToString() : "";
jcl1.receipt_copy_date = dt.Rows[0][jcl.receipt_copy_date] != null ? dt.Rows[0][jcl.receipt_copy_date].ToString() : "";
jcl1.accept_tender = dt.Rows[0][jcl.accept_tender] != null ? dt.Rows[0][jcl.accept_tender].ToString() : "";
jcl1.advance_billing = dt.Rows[0][jcl.advance_billing] != null ? dt.Rows[0][jcl.advance_billing].ToString() : "";
jcl1.approve_date = dt.Rows[0][jcl.approve_date] != null ? dt.Rows[0][jcl.approve_date].ToString() : "";
jcl1.parent1 = dt.Rows[0][jcl.parent1] != null ? dt.Rows[0][jcl.parent1].ToString() : "";
jcl1.date_create = dt.Rows[0][jcl.date_create] != null ? dt.Rows[0][jcl.date_create].ToString() : "";
jcl1.date_modi = dt.Rows[0][jcl.date_modi] != null ? dt.Rows[0][jcl.date_modi].ToString() : "";
jcl1.date_cancel = dt.Rows[0][jcl.date_cancel] != null ? dt.Rows[0][jcl.date_cancel].ToString() : "";
jcl1.user_create = dt.Rows[0][jcl.user_create] != null ? dt.Rows[0][jcl.user_create].ToString() : "";
jcl1.user_modi = dt.Rows[0][jcl.user_modi] != null ? dt.Rows[0][jcl.user_modi].ToString() : "";
jcl1.user_cancel = dt.Rows[0][jcl.user_cancel] != null ? dt.Rows[0][jcl.user_cancel].ToString() : "";
jcl1.remark = dt.Rows[0][jcl.remark] != null ? dt.Rows[0][jcl.remark].ToString() : "";
jcl1.active = dt.Rows[0][jcl.active] != null ? dt.Rows[0][jcl.active].ToString() : "";
}
else
{
jcl1.import_check_list_id = "";
jcl1.job_import_id = "";
jcl1.status_original = "";
jcl1.check_list_date = "";
jcl1.type_of_bl = "";
jcl1.email_do = "";
jcl1.privi1_id = "";
jcl1.privi2_id = "";
jcl1.privi1_date = "";
jcl1.privi2_date = "";
jcl1.privi1_desc = "";
jcl1.privi2_desc = "";
jcl1.doc_authen1_id = "";
jcl1.doc_authen2_id = "";
jcl1.doc_authen3_id = "";
jcl1.doc_authen1_date = "";
jcl1.doc_authen2_date = "";
jcl1.doc_authen3_date = "";
jcl1.enter_bl = "";
jcl1.insurance_atten = "";
jcl1.email_do1 = "";
jcl1.email_do1_date = "";
jcl1.do_date_send = "";
jcl1.do_date_receive = "";
jcl1.tax_date_send = "";
jcl1.tax_date_receive = "";
jcl1.exp1_date_send = "";
jcl1.exp1_date_receive = "";
jcl1.exp2_date_send = "";
jcl1.exp2_date_receive = "";
jcl1.receipt_date = "";
jcl1.receipt_copy_date = "";
jcl1.accept_tender = "";
jcl1.advance_billing = "";
jcl1.approve_date = "";
jcl1.parent1 = "";
jcl1.date_create = "";
jcl1.date_modi = "";
jcl1.date_cancel = "";
jcl1.user_create = "";
jcl1.user_modi = "";
jcl1.user_cancel = "";
jcl1.remark = "";
jcl1.active = "";
}
return(jcl1);
}
public String update(JobImportCheckList p)
{
String re = "";
String sql = "";
int chk = 0;
chkNull(p);
sql = "Update " + jcl.table + " Set " +
" " + jcl.job_import_id + " = '" + p.job_import_id + "'" +
"," + jcl.status_original + " = '" + p.status_original.Replace("'", "''") + "'" +
"," + jcl.check_list_date + " = '" + p.check_list_date + "'" +
"," + jcl.type_of_bl + " = '" + p.type_of_bl.Replace("'", "''") + "'" +
"," + jcl.email_do + " = '" + p.email_do.Replace("'", "''") + "'" +
"," + jcl.privi1_id + " = '" + p.privi1_id.Replace("'", "''") + "'" +
"," + jcl.privi2_id + " = '" + p.privi2_id.Replace("'", "''") + "'" +
"," + jcl.privi1_date + " = '" + p.privi1_date.Replace("'", "''") + "'" +
"," + jcl.privi2_date + " = '" + p.privi2_date.Replace("'", "''") + "'" +
"," + jcl.privi1_desc + " = '" + p.privi1_desc + "'" +
"," + jcl.privi2_desc + " = '" + p.privi2_desc + "'" +
"," + jcl.doc_authen1_id + " = '" + p.doc_authen1_id + "'" +
"," + jcl.doc_authen2_id + " = '" + p.doc_authen2_id + "'" +
"," + jcl.doc_authen3_id + " = '" + p.doc_authen3_id + "'" +
"," + jcl.doc_authen1_date + " = '" + p.doc_authen1_date + "'" +
"," + jcl.doc_authen2_date + " = '" + p.doc_authen2_date.Replace("'", "''") + "'" +
"," + jcl.doc_authen3_date + " = '" + p.doc_authen3_date.Replace("'", "''") + "'" +
"," + jcl.enter_bl + " = '" + p.enter_bl + "'" +
"," + jcl.insurance_atten + " = '" + p.insurance_atten + "' " +
"," + jcl.email_do1 + " = '" + p.email_do1 + "' " +
"," + jcl.email_do1_date + " = '" + p.email_do1_date + "' " +
"," + jcl.do_date_send + " = '" + p.do_date_send + "' " +
"," + jcl.do_date_receive + " = '" + p.do_date_receive + "' " +
"," + jcl.tax_date_send + " = '" + p.tax_date_send + "' " +
"," + jcl.tax_date_receive + " = '" + p.tax_date_receive + "' " +
"," + jcl.exp1_date_send + " = '" + p.exp1_date_send + "' " +
"," + jcl.exp1_date_receive + " = '" + p.exp1_date_receive + "' " +
"," + jcl.date_modi + " = now() " +
"," + jcl.user_modi + " = '" + conn.user.staff_id + "' " +
"," + jcl.exp2_date_send + " = '" + p.exp2_date_send.Replace("'", "''") + "' " +
"," + jcl.exp2_date_receive + " = '" + p.exp2_date_receive.Replace("'", "''") + "' " +
"," + jcl.receipt_date + " = '" + p.receipt_date.Replace("'", "''") + "' " +
"," + jcl.receipt_copy_date + " = '" + p.receipt_copy_date.Replace("'", "''") + "' " +
"," + jcl.accept_tender + " = '" + p.accept_tender.Replace("'", "''") + "' " +
"," + jcl.advance_billing + " = '" + p.advance_billing.Replace("'", "''") + "' " +
"," + jcl.approve_date + " = '" + p.approve_date.Replace("'", "''") + "' " +
"," + jcl.parent1 + " = '" + p.parent1.Replace("'", "''") + "' " +
"," + jcl.remark + " = '" + p.remark.Replace("'", "''") + "' " +
"Where " + jcl.pkField + "='" + p.import_check_list_id + "'"
;
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}