public int Insert(Permission model) { using (DataCommand cmd = DataCommandManager.GetDataCommand("InsertPermission")) { cmd.SetParameterValue("@PermissionId", model.PermissionId); cmd.SetParameterValue("@Code", model.Code); cmd.SetParameterValue("@Fullname", model.Fullname); cmd.SetParameterValue("@ParentId", model.ParentId); cmd.SetParameterValue("@SortCode", model.SortCode); cmd.SetParameterValue("@Description", model.Description); return cmd.ExecuteNonQuery(); } }
public List<Permission> GetPermissions(string sqlWhere) { List<Permission> permissions=new List<Permission>(); using (DataCommand cmd = DataCommandManager.GetDataCommand("GetPermission")) { if(!string.IsNullOrEmpty(sqlWhere)) { cmd.CommandText = cmd.CommandText + " " + sqlWhere; } using(IDataReader dr=cmd.ExecuteDataReader()) { while (dr.Read()) { Permission model=new Permission(); if (!Convert.IsDBNull(dr["PermissionId"])) { model.PermissionId = Convert.ToInt32(dr["PermissionId"]); } if (!Convert.IsDBNull(dr["Code"])) { model.Code = dr["Code"].ToString(); } if (!Convert.IsDBNull(dr["Fullname"])) { model.Fullname =dr["Fullname"].ToString(); } if (!Convert.IsDBNull(dr["ParentId"])) { model.ParentId = dr["ParentId"].ToString(); } if (!Convert.IsDBNull(dr["SortCode"])) { model.SortCode = Convert.ToInt32(dr["SortCode"]) ; } if (!Convert.IsDBNull(dr["Description"])) { model.Description = dr["Description"].ToString(); } permissions.Add(model); } } } return permissions; }
public int Insert(Permission model) { throw new NotImplementedException(); }