C# (CSharp) DAL DBhelper.GetTable Examples

Example #1

        public DataTable ShowLeave(string id)
        {
            string sql = "select * from AllLeave join QjType on AllLeave.lTypeid=QjType.qjTypeid where 1=1";

            if (id != "")
            {
                sql += "and id=" + id;;
            }
            return(DBhelper.GetTable(sql));
        }

Example #2

        public DataTable ShowType()
        {
            string sql = "select * from QjType";

            return(DBhelper.GetTable(sql));
        }