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