コード例 #1
0
        public override SqlParameter[] GetParameters()
        {
            M_Plat_Task model = this;

            SqlParameter[] sp = GetSP();
            if (model.CreateTime <= DateTime.MinValue)
            {
                model.CreateTime = DateTime.Now;
            }
            if (model.BeginTime <= DateTime.MinValue)
            {
                model.BeginTime = DateTime.Now;
            }
            sp[0].Value  = model.ID;
            sp[1].Value  = model.TaskName;
            sp[2].Value  = model.TaskContent;
            sp[3].Value  = model.TaskType;
            sp[4].Value  = model.BeginTime;
            sp[5].Value  = model.EndTime;
            sp[6].Value  = model.LeaderIDS;
            sp[7].Value  = model.PartTakeIDS;
            sp[8].Value  = model.Color;
            sp[9].Value  = model.Status;
            sp[10].Value = model.Remind;
            sp[11].Value = model.CreateUser;
            sp[12].Value = model.CreateUName;
            sp[13].Value = model.CreateTime;
            sp[14].Value = model.Attach;
            sp[15].Value = model.CompID;
            return(sp);
        }
コード例 #2
0
        public M_Plat_Task GetModelFromReader(DbDataReader rdr)
        {
            M_Plat_Task model = new M_Plat_Task();

            model.ID          = Convert.ToInt32(rdr["ID"]);
            model.TaskName    = ConverToStr(rdr["TaskName"]);
            model.TaskContent = ConverToStr(rdr["TaskContent"]);
            model.TaskType    = ConvertToInt(rdr["TaskType"]);
            model.BeginTime   = ConvertToDate(rdr["BeginTime"]);
            model.EndTime     = ConvertToDate(rdr["EndTime"]);
            model.LeaderIDS   = ConverToStr(rdr["LeaderIDS"]);
            model.PartTakeIDS = ConverToStr(rdr["PartTakeIDS"]);
            model.Color       = ConverToStr(rdr["Color"]);
            model.Status      = ConvertToInt(rdr["Status"]);
            model.Remind      = ConverToStr(rdr["Remind"]);
            model.CreateUser  = ConvertToInt(rdr["CreateUser"]);
            model.CreateUName = ConverToStr(rdr["CreateUName"]);
            model.CreateTime  = ConvertToDate(rdr["CreateTime"]);
            model.Attach      = ConverToStr(rdr["Attach"]);
            model.CompID      = ConvertToInt(rdr["CompID"]);
            rdr.Close();
            return(model);
        }