/// <summary>
/// ī�װ�� �ڵ带 �����´�
/// </summary>
/// <param name="lcode">��з� �ڵ� ������� -1</param>
/// <returns></returns>
public static CategoryCodeModel GetCategoryCodes(int lCode)
{
SqlParameter[] param = { CreateInParam("@LCode", SqlDbType.Int,4, lCode) };
SqlCommand cmd = GetSpCommand("UBI_GetCategoryCodes", param);
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CategoryCodeModel code = new CategoryCodeModel();
while (reader.Read())
{
code.Add( new CategoryCodeModel(
(int)reader["CategoryLCode"], reader["CategoryLTitle"].ToString()));
}
if (reader.NextResult())
{
code.CreateCategoryMCode();
while (reader.Read())
{
code.CategoryMCode.Add(new CategoryCodeModel(
(int)reader["CategoryMCode"], reader["CategoryMTitle"].ToString()));
}
}
ReleaseCommand(cmd);
return code;
}
