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