public static RoleEntity[] DataTableToBindEntitys(DataTable dt) { if (dt == null) return null; var results = new RoleEntity[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { results[i] = DataRowToBindEntity(dt.Rows[i]); } return results; }
public string CreateRole(RoleEntity role) { string RoleId = string.Empty; base.UseTran((tran) => { DbCommand cmd = base.Database.GetStoredProcCommand("P_CreateRole"); base.Database.AddOutParameter(cmd, "RoleId", DbType.String, 36); base.Database.AddInParameter(cmd, "RoleNo", DbType.String, role.RoleNo); base.Database.AddInParameter(cmd, "RoleName", DbType.String, role.RoleName); base.Database.AddInParameter(cmd, "CreateId", DbType.String, role.CreateId); base.Database.AddInParameter(cmd, "IsLock", DbType.String, role.IsLock); base.Database.AddInParameter(cmd, "Remark", DbType.String, role.Remark); base.Database.ExecuteNonQuery(cmd, tran); RoleId = base.Database.GetParameterValue(cmd, "RoleId").ToString(); }); return RoleId; }
public static RoleEntity DataRowToBindEntity(DataRow row) { if (row == null) return null; var result = new RoleEntity() { CreateDate = (System.DateTime)(row["CreateDate"]), CreateId = Convert.ToString(row["CreateId"]), IsLock = Convert.ToBoolean(row["IsLock"]), LastModifyDate = Convert.ToDateTime(row["LastModifyDate"]), LastModifyId = Convert.ToString(row["LastModifyId"]), Remark = Convert.ToString(row["Remark"]), RoleId = Convert.ToString(row["RoleId"]), RoleNo = Convert.ToString(row["RoleNo"]), IsSuper = Convert.ToBoolean(row["IsSuper"]), RoleName = Convert.ToString(row["RoleName"]), }; return result; }
public void UpdateRole(RoleEntity role) { base.UseTran((tran) => { DbCommand cmd = base.Database.GetStoredProcCommand("P_UpdateRole"); base.Database.AddInParameter(cmd, "RoleId", DbType.String, role.RoleId); base.Database.AddInParameter(cmd, "RoleNo", DbType.String, role.RoleNo); base.Database.AddInParameter(cmd, "RoleName", DbType.String, role.RoleName); base.Database.AddInParameter(cmd, "LastModifyId", DbType.String, role.LastModifyId); base.Database.AddInParameter(cmd, "IsLock", DbType.String, role.IsLock); base.Database.AddInParameter(cmd, "Remark", DbType.String, role.Remark); base.Database.ExecuteNonQuery(cmd, tran); }); }