/// <summary> /// 把DataRow转换成Model /// </summary> public UserLabelInfolog ToModel(MySqlDataReader dr) { UserLabelInfolog userLabelInfolog = new UserLabelInfolog(); userLabelInfolog.UserLabelInfoID = (long)ToModelValue(dr, "UserLabelInfoID"); userLabelInfolog.LabelName = (string)ToModelValue(dr, "LabelName"); userLabelInfolog.UserInfoID = (long)ToModelValue(dr, "UserInfoID"); userLabelInfolog.CreateTime = (DateTime)ToModelValue(dr, "CreateTime"); return(userLabelInfolog); }
/// <summary> /// 根据传入Model更新数据并返回更新后的Model /// </summary> public int Update(UserLabelInfolog userLabelInfolog) { string sql = "UPDATE tblUserLabelInfolog " + "SET " + " LabelName = @LabelName" + ", UserInfoID = @UserInfoID" + ", CreateTime = @CreateTime" + " WHERE UserLabelInfoID = @UserLabelInfoID"; MySqlParameter[] para = new MySqlParameter[] { new MySqlParameter("@UserLabelInfoID", userLabelInfolog.UserLabelInfoID) , new MySqlParameter("@LabelName", ToDBValue(userLabelInfolog.LabelName)) , new MySqlParameter("@UserInfoID", ToDBValue(userLabelInfolog.UserInfoID)) , new MySqlParameter("@CreateTime", ToDBValue(userLabelInfolog.CreateTime)) }; return(MyDBHelper.ExecuteNonQuery(sql, para)); }
/// <summary> /// 根据传入Model,并返回Model /// </summary> public bool Add(UserLabelInfolog userLabelInfolog) { string sql = "INSERT INTO tblUserLabelInfolog (LabelName, UserInfoID, CreateTime) VALUES (@LabelName, @UserInfoID, @CreateTime)"; MySqlParameter[] para = new MySqlParameter[] { new MySqlParameter("@LabelName", ToDBValue(userLabelInfolog.LabelName)), new MySqlParameter("@UserInfoID", ToDBValue(userLabelInfolog.UserInfoID)), new MySqlParameter("@CreateTime", ToDBValue(userLabelInfolog.CreateTime)), }; int AddId = (int)MyDBHelper.ExecuteScalar(sql, para); if (AddId == 1) { return(true); } else { return(false); } }
public int Update(UserLabelInfolog userLabelInfolog) { return(new UserLabelInfologDAL().Update(userLabelInfolog)); }
public bool UserLabelInfologAdd(UserLabelInfolog userLabelInfolog) { return(new UserLabelInfologDAL().Add(userLabelInfolog)); }