public void Create(SelfStockGroup stockGroup)
{
var parameters = new IDataParameter[]
{
new MySqlParameter("@P_USERID", stockGroup.UserId),
new MySqlParameter("@P_GROUPNAME", stockGroup.Name),
new MySqlParameter("@P_RETURN_VALUE",MySqlDbType.Int32){ Direction = ParameterDirection.Output }
};
var returnCode = this.DbRequest.ExecuteNonQuery(this.ConnectionString, "P_STOCK_GROUP_CREATE", parameters);
}
public void Update(SelfStockGroup stockGroup)
{
var parameters = new IDataParameter[]
{
new MySqlParameter("@P_ID", stockGroup.Id),
new MySqlParameter("@P_UserId", stockGroup.UserId),
new MySqlParameter("@P_GroupName", stockGroup.Name),
new MySqlParameter("@P_DisplayOrder", stockGroup.DisplayOrder),
new MySqlParameter("@P_IsHidden", stockGroup.IsHidden),
};
var returnCode = this.DbRequest.ExecuteNonQuery(this.ConnectionString, "P_STOCK_GROUP_UPDATE", parameters);
}
