/// <summary> /// 更新一条数据 /// </summary> public bool Update(XCLShouCang.Model.UserRole model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update UserRole set "); strSql.Append("FK_UserID=@FK_UserID,"); strSql.Append("FK_RoleInfoID=@FK_RoleInfoID"); strSql.Append(" where UserRoleID=@UserRoleID"); SqlParameter[] parameters = { new SqlParameter("@FK_UserID", SqlDbType.BigInt, 8), new SqlParameter("@FK_RoleInfoID", SqlDbType.BigInt, 8), new SqlParameter("@UserRoleID", SqlDbType.BigInt, 8) }; parameters[0].Value = model.FK_UserID; parameters[1].Value = model.FK_RoleInfoID; parameters[2].Value = model.UserRoleID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(XCLShouCang.Model.UserRole model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UserRole("); strSql.Append("FK_UserID,FK_RoleInfoID)"); strSql.Append(" values ("); strSql.Append("@FK_UserID,@FK_RoleInfoID)"); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@FK_UserID", SqlDbType.BigInt, 8), new SqlParameter("@FK_RoleInfoID", SqlDbType.BigInt, 8) }; parameters[0].Value = model.FK_UserID; parameters[1].Value = model.FK_RoleInfoID; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XCLShouCang.Model.UserRole DataRowToModel(DataRow row) { XCLShouCang.Model.UserRole model = new XCLShouCang.Model.UserRole(); if (row != null) { if (row["UserRoleID"] != null && row["UserRoleID"].ToString() != "") { model.UserRoleID = long.Parse(row["UserRoleID"].ToString()); } if (row["FK_UserID"] != null && row["FK_UserID"].ToString() != "") { model.FK_UserID = long.Parse(row["FK_UserID"].ToString()); } if (row["FK_RoleInfoID"] != null && row["FK_RoleInfoID"].ToString() != "") { model.FK_RoleInfoID = long.Parse(row["FK_RoleInfoID"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public XCLShouCang.Model.UserRole GetModel(long UserRoleID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UserRoleID,FK_UserID,FK_RoleInfoID from UserRole "); strSql.Append(" where UserRoleID=@UserRoleID"); SqlParameter[] parameters = { new SqlParameter("@UserRoleID", SqlDbType.BigInt) }; parameters[0].Value = UserRoleID; XCLShouCang.Model.UserRole model = new XCLShouCang.Model.UserRole(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }