public string loadMouthArkStoreStatus(string eboxNo) { var sql = @"select count(ark.ID) as Data from ebox_mouth_ark ark where ark.TF_BUZSTATUS =1 and ark.TF_DELETEFLAG=0 and ark.MO_PBNO={0}"; var d = db.ExecuteQuery <SingleData>(sql, eboxNo).FirstOrDefault(); if (null != d) { return(d.Data.ToString()); } return("0"); }