public override SqlParameter[] GetParameters()//用于插入数据,将模型作为参数传入 { M_DocPermission model = this; SqlParameter[] sp = GetSP(); sp[0].Value = model.ID; sp[1].Value = model.UserID; sp[2].Value = model.UserName; sp[3].Value = model.GroupName; sp[4].Value = model.Status; sp[5].Value = model.OnlyMe; sp[6].Value = model.AllowNodes; sp[7].Value = model.CreateAble; sp[8].Value = model.RetrieveAble; sp[9].Value = model.UpdateAble; sp[10].Value = model.DeleteAble; sp[11].Value = model.Remind; sp[12].Value = model.OwnGroupID; return(sp); }
public M_DocPermission GetModelFromReader(DbDataReader rdr) { M_DocPermission model = new M_DocPermission(); model.ID = Convert.ToInt32(rdr["ID"]); model.UserID = ConverToStr(rdr["UserID"]); model.UserName = ConverToStr(rdr["UserName"]); model.GroupName = ConverToStr(rdr["GroupName"]); model.Status = ConverToStr(rdr["Status"]); model.OnlyMe = ConverToStr(rdr["OnlyMe"]); model.AllowNodes = ConverToStr(rdr["AllowNodes"]); model.CreateAble = ConverToStr(rdr["CreateAble"]); model.RetrieveAble = ConverToStr(rdr["RetrieveAble"]); model.UpdateAble = ConverToStr(rdr["UpdateAble"]); model.DeleteAble = ConverToStr(rdr["DeleteAble"]); model.Remind = ConverToStr(rdr["Remind"]); model.OwnGroupID = ConverToStr(rdr["OwnGroupID"]); rdr.Close(); rdr.Dispose(); return(model); }