예제 #1
0
        public static PJReportViewModels RetrieveBookReportRecord(string name)
        {
            var sql = "select username,projects,reporttypes,reporttime,lastupdatetime from BookReportRecord where username = '******'";

            sql = sql.Replace("<username>", name);
            var dbret = DBUtility.ExeLocalSqlWithRes(sql, null);

            if (dbret.Count > 0)
            {
                var ret = new PJReportViewModels();
                ret.username       = Convert.ToString(dbret[0][0]);
                ret.projects       = Convert.ToString(dbret[0][1]);
                ret.reporttypes    = Convert.ToString(dbret[0][2]);
                ret.reporttime     = Convert.ToString(dbret[0][3]);
                ret.lastupdatetime = DateTime.Parse(Convert.ToString(dbret[0][4]));
                return(ret);
            }
            return(null);
        }
예제 #2
0
        public static List <PJReportViewModels> RetrieveBookReportRecord()
        {
            var ret = new List <PJReportViewModels>();

            var sql   = "select username,projects,reporttypes,reporttime,lastupdatetime from BookReportRecord";
            var dbret = DBUtility.ExeLocalSqlWithRes(sql, null);

            foreach (var line in dbret)
            {
                var temp = new PJReportViewModels();
                temp.username       = Convert.ToString(line[0]);
                temp.projects       = Convert.ToString(line[1]);
                temp.reporttypes    = Convert.ToString(line[2]);
                temp.reporttime     = Convert.ToString(line[3]);
                temp.lastupdatetime = DateTime.Parse(Convert.ToString(line[4]));
                ret.Add(temp);
            }

            return(ret);
        }