private JobImportCont setJobImportCont(DataTable dt)
{
JobImportCont jct1 = new JobImportCont();
if (dt.Rows.Count > 0)
{
jct1.job_import_cont_id = dt.Rows[0][jct.job_import_cont_id].ToString();
jct1.job_import_id = dt.Rows[0][jct.job_import_id].ToString();
jct1.row_no = dt.Rows[0][jct.row_no].ToString();
jct1.container_no = dt.Rows[0][jct.container_no].ToString();
jct1.container_seal = dt.Rows[0][jct.container_seal].ToString();
jct1.date_cancel = dt.Rows[0][jct.date_cancel].ToString();
jct1.date_create = dt.Rows[0][jct.date_create].ToString();
jct1.date_modi = dt.Rows[0][jct.date_modi].ToString();
jct1.user_cancel = dt.Rows[0][jct.user_cancel].ToString();
jct1.user_create = dt.Rows[0][jct.user_create].ToString();
jct1.user_modi = dt.Rows[0][jct.user_modi].ToString();
jct1.container_type = dt.Rows[0][jct.container_type].ToString();
jct1.packages_per_con = dt.Rows[0][jct.packages_per_con].ToString();
jct1.unit_package_id = dt.Rows[0][jct.unit_package_id].ToString();
jct1.gw_per_con = dt.Rows[0][jct.gw_per_con].ToString();
jct1.unit_gw_id = dt.Rows[0][jct.unit_gw_id].ToString();
jct1.truck_id = dt.Rows[0][jct.truck_id].ToString();
jct1.remark = dt.Rows[0][jct.remark].ToString();
jct1.qty_container = dt.Rows[0][jct.qty_container].ToString();
jct1.active = dt.Rows[0][jct.active].ToString();
}
return(jct1);
}
private void initConfig()
{
jct = new JobImportCont();
jct.job_import_cont_id = "job_import_cont_id";
jct.job_import_id = "job_import_id";
jct.row_no = "row_no";
jct.container_no = "container_no";
jct.container_seal = "container_seal";
jct.container_type = "container_type";
jct.packages_per_con = "packages_per_con";
jct.unit_package_id = "unit_package_id";
jct.gw_per_con = "gw_per_con";
jct.unit_gw_id = "unit_gq_id";
jct.truck_id = "truck_id";
jct.qty_container = "qty_container";
jct.date_create = "date_create";
jct.date_modi = "date_modi";
jct.date_cancel = "date_cancel";
jct.user_create = "user_create";
jct.user_modi = "user_modi";
jct.user_cancel = "user_cancel";
jct.active = "active";
jct.remark = "remark";
jct.table = "t_job_import_cont";
jct.pkField = "job_import_cont_id";
}
public String update(JobImportCont p)
{
String re = "";
String sql = "";
int chk = 0;
Decimal chk1 = 0;
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.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
//p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
//p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
//p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
//p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
p.job_import_id = int.TryParse(p.job_import_id, out chk) ? chk.ToString() : "0";
p.unit_package_id = int.TryParse(p.unit_package_id, out chk) ? chk.ToString() : "0";
p.row_no = int.TryParse(p.row_no, out chk) ? chk.ToString() : "0";
p.unit_gw_id = int.TryParse(p.unit_gw_id, out chk) ? chk.ToString() : "0";
p.truck_id = int.TryParse(p.truck_id, out chk) ? chk.ToString() : "0";
sql = "Update " + jct.table + " Set " +
" " + jct.job_import_id + " = '" + p.job_import_id + "'" +
"," + jct.row_no + " = '" + p.row_no + "'" +
"," + jct.container_no + " = '" + p.container_no.Replace("'", "''") + "'" +
"," + jct.container_seal + " = '" + p.container_seal.Replace("'", "''") + "'" +
"," + jct.date_modi + " = now()" +
"," + jct.user_modi + " = '" + p.user_modi + "' " +
"," + jct.container_type + " = '" + p.container_type + "' " +
"," + jct.packages_per_con + " = '" + p.packages_per_con + "' " +
"," + jct.unit_package_id + " = '" + p.unit_package_id + "' " +
"," + jct.gw_per_con + " = '" + p.gw_per_con + "' " +
"," + jct.unit_gw_id + " = '" + p.unit_gw_id + "' " +
"," + jct.truck_id + " = '" + p.truck_id + "' " +
"," + jct.qty_container + " = '" + p.qty_container + "' " +
"," + jct.remark + " = '" + p.remark.Replace("'", "''") + "' " +
"Where " + jct.pkField + "='" + p.job_import_cont_id + "'"
;
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public String insertJobImportJct(JobImportCont p)
{
String re = "";
if (p.job_import_cont_id.Equals(""))
{
re = insert(p);
}
else
{
re = update(p);
}
return(re);
}
public String insert(JobImportCont p)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
Decimal chk1 = 0;
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.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
//p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
//p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
//p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
//p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
p.job_import_id = int.TryParse(p.job_import_id, out chk) ? chk.ToString() : "0";
p.unit_package_id = int.TryParse(p.unit_package_id, out chk) ? chk.ToString() : "0";
p.row_no = int.TryParse(p.row_no, out chk) ? chk.ToString() : "0";
p.unit_gw_id = int.TryParse(p.unit_gw_id, out chk) ? chk.ToString() : "0";
p.truck_id = int.TryParse(p.truck_id, out chk) ? chk.ToString() : "0";
//p.tax_amount = Decimal.TryParse(p.tax_amount, out chk1) ? chk1.ToString() : "0";
//p.amount = Decimal.TryParse(p.amount, out chk1) ? chk1.ToString() : "0";
//p.cost_amount = Decimal.TryParse(p.cost_amount, out chk1) ? chk1.ToString() : "0";
//p.cheque_amount = Decimal.TryParse(p.cheque_amount, out chk1) ? chk1.ToString() : "0";
//p.amount_pay = Decimal.TryParse(p.amount_pay, out chk1) ? chk1.ToString() : "0";
//p.cheque_pay_amount = Decimal.TryParse(p.cheque_pay_amount, out chk1) ? chk1.ToString() : "0";
//p.amount1 = Decimal.TryParse(p.amount1, out chk1) ? chk1.ToString() : "0";
//p.amount1 = Decimal.TryParse(p.amount1, out chk1) ? chk1.ToString() : "0";
//p.amount1 = Decimal.TryParse(p.amount1, out chk1) ? chk1.ToString() : "0";
//p.amount1 = Decimal.TryParse(p.amount1, out chk1) ? chk1.ToString() : "0";
sql = "Insert Into " + jct.table + "(" + jct.job_import_id + "," + jct.row_no + "," + jct.container_no + "," +
jct.container_seal + "," + jct.container_type + "," + jct.packages_per_con + "," +
jct.unit_package_id + "," + jct.gw_per_con + "," + jct.unit_gw_id + "," +
jct.truck_id + "," + jct.qty_container + ", " + jct.date_create + ", " +
jct.date_modi + "," + jct.date_cancel + ", " + jct.user_create + ", " +
jct.user_modi + "," + jct.user_cancel + ", " + jct.remark + ", " +
p.active + "' " +
") " +
"Values ('" + p.job_import_id + "','" + p.row_no + "','" + p.container_no + "'," +
"'" + p.container_seal + "','" + p.container_type + "','" + p.packages_per_con + "'," +
"'" + p.unit_package_id + "','" + p.gw_per_con + "','" + p.unit_gw_id + "'," +
"'" + p.truck_id + "','" + p.qty_container.Replace("'", "''") + "',now(), " +
"'" + p.date_modi + "','" + p.date_cancel + "','" + p.user_create + "', " +
"'" + p.user_modi + "','" + p.user_cancel + "','" + p.remark + "',' " +
p.active + "' " +
")";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
