/// <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));
}
