public static string GetLatestNoteTime(string companyID, string CaseID) { string sql = "select max(createon) from notetable where companyid={0} and caseID={1}"; return(DataHelper.ExecuteScalar(string.Format(sql, companyID, CaseID)).ToString()); }
public static string GetIfHasBalanceTable(string where) { return(DataHelper.ExecuteScalar("select HasBalanceTable from CompanyTable " + where).ToString()); }