public int GetStatus_Barcode(string barcode) { Class.clsDB db = new Class.clsDB(); string sql = "Select * From job_trailer WHERE job_id ='" + barcode + "'"; DataTable dt; dt = db.ExecuteDataTable(sql); db.Close(); if (dt.Rows.Count > 0) { if (dt.Rows[0].IsNull("timestamp1")) { return(1); } else if ((!dt.Rows[0].IsNull("timestamp1")) && (!dt.Rows[0].IsNull("timestamp2")) && (!dt.Rows[0].IsNull("timestamp3"))) { return(3); } else if ((!dt.Rows[0].IsNull("timestamp1")) && (!dt.Rows[0].IsNull("timestamp2"))) { return(2); } } return(0); }
public DataTable Update_Data(MODEL.Data criteria) { try { criteria.update_date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); criteria.out_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); Class.clsDB db = new Class.clsDB(); string sql; sql = "Update vm_visitor SET flag_out='1', "; sql += "out_time='" + criteria.out_time + "',"; sql += "update_date='" + criteria.update_date + "' Where vm_id='" + criteria.vm_id + "'"; int ret; ret = db.ExecuteNonQuery(sql); db.Close(); if (ret == 1) { DataTable dt; sql = "Select * From vm_visitor Where vm_id = '" + criteria.vm_id + "'"; dt = db.ExecuteDataTable(sql); return(dt); } return(null); } catch (Exception ex) { return(null); } }
public string getRuningNoDoc() { //Format yyyyMMdd-01 2018011501 Class.clsDB db = new Class.clsDB(); string sql = null; string curDate; curDate = DateTime.Now.ToString("yyyyMMdd"); sql = "Select vm_id From vm_visitor where vm_id like '" + curDate + "%'"; object MyScalar = null; DataTable dt; dt = db.ExecuteDataTable(sql); db.Close(); if (dt != null) { if (dt.Rows.Count > 0) { sql = "Select Max(vm_id) + 1 From vm_visitor"; MyScalar = db.ExecuteScalar(sql); return(MyScalar.ToString()); } else { return(curDate.ToString() + "01"); } } return(curDate); }
public DataTable getData_ReportJob(string job_id) { DataTable dt = null; string sql = "Select * From vw_JobTrailer where job_id='" + job_id + "' and show_=1"; Class.clsDB db = new Class.clsDB(); dt = db.ExecuteDataTable(sql); db.Close(); return(dt); }
public DataTable getData_ReportJobTimestamp(string job_id) { DataTable dt = null; string sql = "Select job_id,job_name,job_date,time(timestamp1) as timestamp1,"; sql += "time(timestamp2) as timestamp2,time(timestamp3) as timestamp3,time(timestamp4) as timestamp4"; sql += " From job_trailer where job_id='" + job_id + "' and show_=1"; Class.clsDB db = new Class.clsDB(); dt = db.ExecuteDataTable(sql); db.Close(); return(dt); }
public string Get_Paper_type(string doc_id) { Class.clsDB db = new Class.clsDB(); string sql; sql = " Select paper_type From document where doc_id=" + doc_id; DataTable dt; dt = db.ExecuteDataTable(sql); db.Close(); if (dt.Rows.Count > 0) { return(dt.Rows[0][0].ToString()); } else { return(""); } }
public string Get_Signature_By_Email(string email) { Class.clsDB db = new Class.clsDB(); string sql; sql = "select signature From account WHERE email='" + email + "'"; DataTable dt; dt = db.ExecuteDataTable(sql); db.Close(); if (dt.Rows.Count > 0) { return(dt.Rows[0][0].ToString()); } else { return("Error"); } }
public DataTable Test() { try { DataSet ds = new DataSet(); DataTable dt; String sql; sql = "Select * From provinces "; Class.clsDB db = new Class.clsDB(); dt = db.ExecuteDataTable(sql); db.Close(); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } finally { } }
public DataTable Select_Data(MODEL.Data criteria) { try { Class.clsDB db = new Class.clsDB(); string sql; DataTable dt; sql = "Select * From vm_visitor Where in_time >= '" + criteria.in_time + "' and out_time <= '" + criteria.out_time + "'"; dt = db.ExecuteDataTable(sql); return(dt); return(null); } catch (Exception ex) { return(null); } }