예제 #1
0
        public override SqlParameter[] GetParameters()
        {
            SqlParameter[] sp    = GetSP();
            M_Mis_AppProg  model = this;

            if (model.CreateTime <= DateTime.MinValue)
            {
                model.CreateTime = DateTime.Now;
            }
            sp[0].Value  = model.ID;
            sp[1].Value  = model.AppID;
            sp[2].Value  = model.ProID;
            sp[3].Value  = model.ProLevel;
            sp[4].Value  = model.ProLevelName;
            sp[5].Value  = model.ApproveID;
            sp[6].Value  = model.Result;
            sp[7].Value  = model.Remind;
            sp[8].Value  = model.CreateTime;
            sp[9].Value  = model.Remind2;
            sp[10].Value = model.HQUserID;
            sp[11].Value = model.Sign;
            sp[12].Value = model.SignID;
            sp[13].Value = model.Status;
            sp[14].Value = model.UserStepRole;
            return(sp);
        }
예제 #2
0
        public M_Mis_AppProg GetModelFromReader(DbDataReader rdr)
        {
            M_Mis_AppProg model = new M_Mis_AppProg();

            model.ID           = Convert.ToInt32(rdr["ID"]);
            model.AppID        = Convert.ToInt32(rdr["AppID"]);
            model.ProID        = Convert.ToInt32(rdr["ProID"]);
            model.ProLevel     = Convert.ToInt32(rdr["ProLevel"]);
            model.ProLevelName = ConverToStr(rdr["ProLevelName"]);
            model.ApproveID    = Convert.ToInt32(rdr["ApproveID"]);
            model.Result       = Convert.ToInt32(rdr["Result"]);
            model.Remind       = ConverToStr(rdr["Remind"]);
            model.CreateTime   = ConvertToDate(rdr["CreateTime"]);
            model.Remind2      = ConverToStr(rdr["Remind2"]);
            model.HQUserID     = ConverToStr(rdr["HQUserID"]);
            model.Sign         = ConverToStr(rdr["Sign"]);
            model.SignID       = ConverToStr(rdr["SignID"]);
            model.Status       = ConvertToInt(rdr["Status"]);
            model.UserStepRole = ConverToStr(rdr["UserStepRole"]);
            rdr.Dispose();
            return(model);
        }