/** ********************************************************************* */
public ArrayList<Image_tms> Img_GetImageByDoc_item(String vWorkHid, String vDoc_item) {
ArrayList<Image_tms> Images = new ArrayList<Image_tms>();
Cursor c = db_main.GetImageByDoc_item(vWorkHid, vDoc_item);
if (c.getCount() > 0) {
if (c.moveToFirst()) {
do {
Image_tms m = new Image_tms();
m.WorkHid = db_main.GetString(c, db_main.Im_WorkHid, "");
m.Group_Type = db_main.GetString(c, db_main.Im_Group_Type, "");
m.Type_img = db_main.GetString(c, db_main.Im_Type_img, "");
m.Filename = db_main.GetString(c, db_main.Im_Filename, "");
m.Doc_item = db_main.GetString(c, db_main.Im_Doc_item, "");
m.Lat_img = db_main.GetString(c, db_main.Im_Lat_img, "");
m.Lng_img = db_main.GetString(c, db_main.Im_Lng_img, "");
m.Date_img = db_main.GetString(c, db_main.Im_Date_img, "");
m.Stat_Upd = db_main.GetString(c, db_main.Im_Status_Update, "");
m.Comment = db_main.GetString(c, db_main.Im_Comment, "");
Images.add(m);
} while (c.moveToNext());
}
}
c.close();
return Images;
}
/** ********************************************************************* */
public void SaveImg(
String vWorkHid,
String vGroup_Type,
String vType_img,
String vFilename,
String vDoc_item,
String vLat_img,
String vLng_img,
String vComment) {
/* Create new img data */
db_main.InsertImage(
vWorkHid,
vGroup_Type,
vType_img,
vFilename,
vDoc_item,
vLat_img,
vLng_img,
this.INACTIVE,
vComment);
}
public IMG_OILANDGAS(Context context) {
db_main = new DB_MAIN(context);
db_main.getWritableDatabase();
}
public void close() {
db_main.close();
}
/** ********************************************************************* */
public void UpdateByFilename(String vFilename) {
/* Create new img data */
db_main.Update_status_Ct_Upload_req(vFilename);
}
public void deleteFilename(String vFilename) {
db_main.deleteFilename(vFilename);
}