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