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);
}
}
