private JobImportImage setImportImage(DataTable dt)
{
JobImportImage jii1 = new JobImportImage();
if (dt.Rows.Count > 0)
{
jii1.job_import_image_id = dt.Rows[0][jii.job_import_image_id].ToString();
jii1.job_import_id = dt.Rows[0][jii.job_import_id].ToString();
jii1.path_pic = dt.Rows[0][jii.path_pic].ToString();
jii1.active = dt.Rows[0][jii.active].ToString();
jii1.remark = dt.Rows[0][jii.remark].ToString();
jii1.status_pic = dt.Rows[0][jii.status_pic].ToString();
jii1.date_create = dt.Rows[0][jii.date_create].ToString();
jii1.date_modi = dt.Rows[0][jii.date_modi].ToString();
jii1.user_cancel = dt.Rows[0][jii.user_cancel].ToString();
jii1.user_create = dt.Rows[0][jii.user_create].ToString();
jii1.user_modi = dt.Rows[0][jii.user_modi].ToString();
//pti1.status_app = dt.Rows[0][tmn.status_app].ToString();
jii1.remark = dt.Rows[0][jii.remark].ToString();
jii1.sort1 = dt.Rows[0][jii.sort1].ToString();
jii1.status_module = dt.Rows[0][jii.status_module].ToString();
}
return(jii1);
}
public JobImportImage selectByPk1(String copId)
{
JobImportImage cop1 = new JobImportImage();
DataTable dt = new DataTable();
String sql = "select jii.* " +
"From " + jii.table + " jii " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where jii." + jii.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setImportImage(dt);
return(cop1);
}
public String insertPrefix(JobImportImage p)
{
String re = "";
if (p.job_import_image_id.Equals(""))
{
re = insert(p);
}
else
{
re = update(p);
}
return(re);
}
public String update(JobImportImage p)
{
String re = "", sql = "";
sql = "Update " + jii.table + " Set " +
" " + jii.job_import_id + "='" + p.job_import_id + "' " +
"," + jii.path_pic + "='" + p.path_pic.Replace("'", "''") + "' " +
"," + jii.status_pic + "='" + p.status_pic.Replace("'", "''") + "' " +
"," + jii.remark + "='" + p.remark.Replace("'", "''") + "' " +
"," + jii.user_modi + "='" + p.user_modi.Replace("'", "''") + "' " +
"," + jii.date_modi + "=now() " +
"," + jii.status_module + "='" + p.status_module.Replace("'", "''") + "' " +
"Where " + jii.pkField + "='" + p.job_import_image_id + "'"
;
re = conn.ExecuteNonQuery(conn.conn, sql);
return(re);
}
private void initConfig()
{
jii = new JobImportImage();
jii.job_import_image_id = "job_import_image_id";
jii.job_import_id = "job_import_id";
jii.path_pic = "path_pic";
jii.active = "active";
jii.remark = "remark";
jii.status_pic = "status_pic";
jii.date_create = "date_create";
jii.date_modi = "date_modi";
jii.date_cancel = "date_cancel";
jii.user_create = "user_create";
jii.user_modi = "user_modi";
jii.user_cancel = "user_cancel";
jii.sort1 = "sort1";
jii.status_module = "status_module";
jii.table = "t_job_import_image";
jii.pkField = "job_import_image_id";
}
public String insert(JobImportImage p)
{
String re = "", sql = "";
p.active = "1";
//p.ssdata_id = "";
sql = "Insert Into " + jii.table + "(" + jii.job_import_id + "," + jii.path_pic + "," + jii.status_pic + "," +
jii.active + "," + jii.remark + "," + jii.date_create + "," +
jii.date_modi + "," + jii.date_cancel + "," + jii.user_create + "," +
jii.user_modi + "," + jii.user_cancel + "," + jii.sort1 + "," +
jii.status_module + "," +
") " +
"Values ('" + p.job_import_id + "','" + p.path_pic + "','" + p.status_pic + "'," +
"'" + p.active + "','" + p.remark + "', now() " +
"'" + p.date_modi + "','" + p.date_cancel + "','" + p.user_create + "'," +
"'" + p.user_modi + "','" + p.user_cancel + "','" + p.sort1 + "'," +
"'" + p.status_module + "' " +
")";
re = conn.ExecuteNonQuery(conn.conn, sql);
return(re);
}
