예제 #1
0
        public M_OA_DocView GetModelFromReader(DbDataReader rdr)
        {
            M_OA_DocView model = new M_OA_DocView();

            model.ID          = ConvertToInt(rdr["ID"]);
            model.DocID       = ConvertToInt(rdr["DocID"]);
            model.ViewUserIDS = ConverToStr(rdr["ViewUserIDS"]);
            model.EditUserIDS = ConverToStr(rdr["EditUserIDS"]);
            model.ZStatus     = ConvertToInt(rdr["ZStatus"]);
            model.UserID      = ConvertToInt(rdr["UserID"]);
            model.CDate       = ConvertToDate(rdr["CDate"]);
            model.EndDate     = ConvertToDate(rdr["EndDate"]);
            rdr.Close();
            return(model);
        }
예제 #2
0
        public override SqlParameter[] GetParameters()
        {
            M_OA_DocView model = this;

            if (model.CDate <= DateTime.MinValue)
            {
                model.CDate = DateTime.Now;
            }
            if (model.EndDate <= DateTime.MinValue)
            {
                model.EndDate = DateTime.MaxValue;
            }
            SqlParameter[] sp = GetSP();
            sp[0].Value = model.ID;
            sp[1].Value = model.DocID;
            sp[2].Value = model.ViewUserIDS;
            sp[3].Value = model.EditUserIDS;
            sp[4].Value = model.ZStatus;
            sp[5].Value = model.UserID;
            sp[6].Value = model.CDate;
            sp[7].Value = model.EndDate;
            return(sp);
        }